If you execute mysqldump manually, mysqldump will prompt you for password. If you setup mysqldump via cronjob, you need to find a solution to disable the password. I’ve setup mysqldump to backup my db via cronjob without password. All you need to do is just to add a file in your home directory and it will disable the mysqldump password prompting.
To setup mysqldump without password in Cronjob, follow the steps below:-
Advertisements
- Start your terminal and login to your server
- Create a .my.cnf file in the home directory
vi ~/.my.cnf
- Copy the content below and replace with your mysql username and password.
[mysqldump] user = mysqluser password = secret
- Now change the file permission to 600 to prevent other user from reading it
chmod 600 ~/.my.cnf
- Now you can try to execute mysqldump and system will not prompt you for password by now
- To setup the cronjob
crontab -e
Append the line below to your crontab and it will run mysqldump every night at 12:00am
0 0 * * * mysqldump -u mysqluser -h localhost --all-databases | gzip -9 > alldb.sql.gz > /dev/null
* for more information on mysql backup, refer to how to backup mysql database
Related posts:
How to change system date in Linux
How to shrink worksheet for printing in Calc - OpenOffice
How to add user to sudoer list in Linux
Speed Up and Save Your Website Bandwidth with GZip Compression
Symfony2: How to get Doctrine Entity Manager in Console command
Prestashop 1.6: "Unexpected token <" error when upload category thumbnail
How to extract .bz2 file in Linux?
CPAN Error: make test had returned bad status, won't install without force
Share this with your friends:-
Thanks, simple and a life saver
Excellent tutorial, thank you!
Great & simple post. Thanks.
Excellent post, thanks!
This is very useful.
Cheers,
-Pipe