Backing up WordPress with phpMyAdmin

With a multitude of upgrades released every 30 seconds in the WordPress community, it’s integral that a regular back-up is taken just to be on the safe side. Although there are plugins available which do this for you, I’m a cynical old bugger and don’t trust anything or anyone.

Most hosts supply phpMyAdmin. If you have access to MySQL Databases, chances are you have phpMyAdmin. You will need to find this little tool. If you’re with Site5, go into SiteAdmin and select the option from under MySQL Databases in the left menu. If you’ve got standard cpanel hosting, go into cpanel > MySQL Databases, and phpMyAdmin is linked near the bottom.

Once your phpMyAdmin window is open, find your WordPress blog in the menu on the left hand side. This may be in a list or a drop-down menu, but will be in there. Usually named username_xxx, where username is the name you use to log into cpanel/SiteAdmin and xxx is the name of the database. Once selected, the main database page should load. Choose Export from the menu across the top:

export db

When the Export page has loaded, make sure all tables are selected:

tables highlighted

Then, near the bottom of the page tick ‘Save as File’ > zipped option. When you’re ready, click Go. Save the file to your computer, and tada: one database back-up.

This entry was posted on Monday, April 28th, 2008 at 8:51 pm and is filed in WordPress.

17 Comments on “Backing up WordPress with phpMyAdmin”

  1. Barbilee says:

    thanks i always wonders how to do this ………. also how to movie it to my root folder from the sub folder that its in ………….. yah i am still a dumb n00b with wordpress :(

    Response posted: April 28th, 2008 at 9:32 pm
  2. Meli says:

    Got a request for you. I had figured out this way to back things up a while back (I don’t trust plugins either), and thankfully nothing’s ever gone wrong because I don’t know how to USE this backup in case of something messing up. Could you enlighten us? God, I feel dumb!

    Response posted: April 28th, 2008 at 9:39 pm
  3. Jem says:

    I plan to post that one next Meli - probably tomorrow :)

    Response posted: April 28th, 2008 at 9:44 pm
  4. Nyx says:

    … there are ways other than this to backup a database? :O

    Response posted: April 28th, 2008 at 10:50 pm
  5. Chien Yee says:

    I use the auto tool cPanel has, because I’m too lazy :P

    Response posted: April 28th, 2008 at 11:09 pm
  6. Sarah says:

    Thanks. I need to do this.

    Response posted: April 28th, 2008 at 11:48 pm
  7. Niki says:

    @ Chien: You’re not alone! :P

    Response posted: April 28th, 2008 at 11:52 pm
  8. Hannah says:

    Or you could be lazy like me and use the WordPress Database Backup plugin ;D

    Response posted: April 29th, 2008 at 12:01 am
  9. Jessica says:

    I just lost the contents of my database during the latest upgrade, and phpMyAdmin wouldn’t let me restore from the backup Wordpress Database Backup gave me. I don’t know if it would have let me restore from a phpMyAdmin backup (it just kept whinging about “Rails application failed to start properly”), but MAYBE it would have stood a better chance of working!

    Response posted: April 29th, 2008 at 12:19 am
  10. Vera says:

    For me it depends: most of the time I use the plugin, but sometimes when I get really paranoid I also use phpMyAdmin for Beth’s site.

    I’m also interested in the tutorial on how to use it. While I do actually use it, I feel I always make too many changes. :P ( your “sticks out tongue” smiley looks weird).

    Response posted: April 29th, 2008 at 5:06 am
  11. Barbilee says:

    yah i love tryign to find new tuts on wordpress one day i have it down ……… but if you could for me make a tut on how to move stuff to the root folder and so on from a subfolder :)

    Response posted: April 29th, 2008 at 5:32 am
  12. mae says:

    I second Hannah hehe I use its automatic backup and send those zip files in another gmail account :P

    Response posted: April 29th, 2008 at 7:17 am
  13. Loadx says:

    pssh phpmyadmin.
    Just ssh in and mysqldump that sucker :P

    Response posted: April 29th, 2008 at 11:15 am
  14. Han says:

    what I need to find is a way to set up a cronjob to do this autmatically. If of course such a thing is possible! *fingers crossed it is!*

    Response posted: April 29th, 2008 at 12:28 pm
  15. Phil Nash says:

    I use a plugin that emails me a database back up once a week. No hassle, no worries.

    I’ll go find the link for it if anyone’s interested.

    Response posted: April 30th, 2008 at 9:07 am
  16. Rebecca says:

    I’ve been doing this since day one, but it’s good to show everyone else as well. Like you, I don’t trust other peoples’ tools unless I pour over them with my own eyes (but I still don’t use tools). It’s just as easy to do it this way. :)

    Response posted: May 5th, 2008 at 2:49 am
  17. Hev says:

    Oh my, Jem. Thank you so much for this. I kept trying to figure this out, & never could make it work. Thanks so much.

    Response posted: May 8th, 2008 at 7:39 pm

Leave a Reply

I'm not interested in viagra or penis enhancers, first-time commenters are moderated and anonymous comments are deleted. Don't waste my time, or yours.