WordPress Database Backup

Something I’m horribly neglectful of … backing up my WordPress Database. It’s probably one of the simplest things in the world to do, yet all too often it goes undone because evidently I have way too much faith in my web host :-)

But I definitely should be doing it weekly, if not more, and it’s always nice to get a little reminder from one of the feeds I keep track of.

Thanks MinTheGap for reminding us!

If you would like a good explanation on how to back up your WordPress databackup, head over to the site and check it out. He has download links, a small explanation of the plugin, and a couple other tips.

HT: MinTheGap.com

Posted May 23, 2007 by Nathan Rice | Filed Under Blog 

Comments

6 Responses to “WordPress Database Backup”

  1. MInTheGap on May 23rd, 2007 10:01 am

    Thanks for the link!

    Yes, it is so very important to make sure that you have a current database backup. It’s useful not only if you’re in a pinch, but also if you find that you want to develop with your blog locally (for those of us that like to tinker!).

  2. franky on May 23rd, 2007 12:17 pm

    Maybe it’s just me, but I honestly am too lazy to remind myself weekly to think of my weekly dbase backup, hence why I use a cron job to do this. Let the script run every night, 7 times (use for every day another filename - don’t bother with timestamped backups, they will only clutter your web space) and you’ll always have 7 backups available. No loss of entries, comments or anything and even if you’ve been playing with your dbase, you’ll be able to minimize the loss.
    And after a week they get overwritten with the new backup for that day.

  3. skarld on May 23rd, 2007 12:21 pm

    I updated to this plugin yesterday on a new site and it worked perfectly with WP 2.2

  4. MInTheGap on May 23rd, 2007 12:40 pm

    franky, where does your cron job leave the database backups? If the backups are left on the same server that the database resides on then if the server goes down you lose those backups as well.

  5. franky on May 23rd, 2007 12:53 pm

    MTG, that script is set to store them on the server, as it was only the first part of a series about automated backup, but one can easily email them and I (having some rather large dbases, too large for most email accounts and the server might as well go down during the download process :P) go further in the backup and FTP them to Amazon S3 and also to my home box (yeah a Windoze!).

    And once every week I backup/download my complete CPanel, also with a cron job, yes I am lazy ;-).

  6. Friday Favorites - MInTheGap » Nathan’s Blog on July 6th, 2007 9:46 am

    [...] a great blog and definitely is worth a spot in my reader (I even gave him some link love over on WPT.com). Have a look and have a great [...]

Leave a Reply