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 sync Google Calendar with Thunderbird
How to install flash player in Ubuntu
MySQL: Full text search for multiple words
How to remove apache test page in CentOS
How to mount samba in Mac OS X / Linux?
How to add Primary and Secondary DNS server - /etc/resolve.conf - Linux
Common MySQL database maintenance command
Speed Up and Save Your Website Bandwidth with GZip Compression
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