When I type in my VPS: $ mysqldump --opt --user=root --password=myPass dbName>/home/myuser/dbName.sql it works and makes a backup of my dbName, but if I do it from a crontab job, it creates an ...
In crontab I have the following cronjob working. 0 0 * * * mysqldump -e --user=root --password=MYPASSWORD MYDB | gzip | uuencode db_date +"\%Y-\%m-\%d".gz | mail -s 'date +"\%Y-\%m-\%d"_dump' ...
How to setup crontab on dedicated server to dump WordPress MySQL database and email it to a Gmail account
I know I can do a mysql dump for my WordPress databases on my dedicated server. But I want to do this automatically, and I want the dump to be emailed to my Gmail account. Is this even possible?
I am attempting to setup a cron to use mysqldump once a day. There is no output and I cannot see any database usage while watching top. The crontab is: mysqldump [database] -u[user] -p'[password]' ...