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?
You can use the wp-db-backup plugin to backup your database to gmail or any other email address.
This tutorial explains how to backup and email a wordpress database.
Extract from the script
A quick tutorial how to setup crontab
There are two ways to set up
In your case, for option (2), you could enter the following two lines to have it update every Sunday at 4:00 am and email you the results.
The command you probably want to use is
This will dump the database to stdout, which crontab will email to you. The dump will be in the message of the email. You can configure which email to send it to by including a line in the crontab like
If you would rather save the database to a file on the server instead of emailing it to yourself, you could use the command