How to Fix Missing WordPress Database Backup Emails
I use the amazing WordPress Database Backup wordpress plugin to create backup of my WordPress database. The latest version, powered by WordPress 2.2, can email you a daily backup of your MySQL database using WordPress cron system. I have configured WordPress Database Backup wordpress plugin to email the database files weekly, but for the last 2 weeks, I received no backup email! I tried to create an on-demand backup (which went well), but still got no email… and it was not a plugin bug at all!
I checked out various forums where it was suggested that a new version of the plugin fiuxed the issue. I was already using the latest version of 2.1.2. I reupdated my plugin, but still no emails were being sent.
Then I figured out what the problem was. It was not a plugin bug at all. Maybe my database file was too large and my email address did not allow huge attachments. I checked that Gmail allows you to send and receive messages a maximum of 20 MB in size (including attachments). Then I tried sending the backup to my Yahoo mail account, but still no luck (The free Yahoo! Mail account has even lower limits of 10MB per message only! Mail Plus users limits upto 20MB)
I remembered my experience while upgrading to WordPress 2.1, I had got a huge database file of 41MB! I checked my previous database files over the weeks, they vary from 2-7 MB. So maybe the database file was so huge that it crossed the email maximum size limits and never reached me.
I checked that there were over 23000 spam comments blocked by Akismet waiting clearance. So indeed the database table size would be huge. Then I used my trick of deleting Akismet spam to reduce database file size.
And did it work? Of course it did. The database was backed up much faster, was error free and I have a 2.7MB .sql.qz file sitting in my inbox right now!
Mike – I have made no changes on Dreamhost. I use the latest plugin. Delete all Akismet blocked spam to reduce database size and then try.
I’m using Spam Karma and have set the backup to not include the spam protection tables. Like I said, it’s the same version of the software as I’m using on a number of other servers and yet it’s only DH that’s proving troublesome.
Ho hum!
Thanks for coming back to me :)
I ve used this plugin. I didn’t received any mails containing the zipped folder nor any mail with garbage codes. I am using gmail account and my new blog has only 60 posts. Can you help me out??
Delete all Akismet blocked spam before backing up the database. Should work.
very handy…