phpMyAdmin: Backup and Restore Wordpress Database

22 10 2007

BACKUP

Backup you database, when ever you update your wordpress installation, you do some work on your theme or just to keep a copy of you data, become familiar with the process of backing up and restoring DB’s.

There are many ways to do a backup, there are even plugins for wordpress that make the job easier, take a look here, but it’s alwasy useful to have an extra ace in your sleves.

With phpMyAdmin it takes few click, first select your wordpress database (you might have more than one DB), click “Export” link, now take a quick look on the “Structure” pane and checkmark “add DROP TABLE”, “add AUTO_INCREMENT value” and “Enclose table and field names with backquotes”.Below “Structure” you can see a section called “DATA” and a checkbox near it, make sure it’s selected, beside that, nothing should be change for the other selections.

In the “Export” pane on the left side you see a box containing all the tables selected for backup, if there are none selected do so, at this point we are almost done, just be sure that the export format is SQL, “Save as file” is marked and pick a compression type, in this case I used “zipped”.
Click “Go” and wait, be patient, if you have a lot of posts it might take few minutes.

DB backup video

You need to upgrade your Flash Player

RESTORE

When you backup data, sooner or later you will need to restore it, nothing easier.

As you did for the backup, in phpMyAdmin select your database, this time click “Import” and browse for you backup copy, click “Go” and pra…mmm, wait!

If everything goes well you just restored your database, otherwise you will be notified of any unsuccesful result. If that’s the case google is your best friend.

DB restore video

You need to upgrade your Flash Player

Thanks for watching

Bookmark It

Hide Sites

Actions

Informations

Date : 22 October 2007
Categories : Computer Tips and Tricks, Tutorials, Wordpress

7 responses to “phpMyAdmin: Backup and Restore Wordpress Database”

22 09 2008: cagpobia (23:46:18) :

thanks much, guy

[Reply]
6 12 2008: Muki (15:44:13) :

Your article made me worried - when did I made my last database backup?! Thank you to remind me.

[Reply]
6 12 2008: Zoohandlung (15:58:30) :

Very helpful your description - thank you for posting.

[Reply]
11 12 2008: legolandbridge (18:16:35) :

Nice helpful screenshots. Is that an available plugin that pops up the videos?

[Reply]
Francesco Reply:
December 12th, 2008 at 1:28 pm
I use AFC FLV-Player, it comes with Highslide JS for the pop up window.

[Reply]
legolandbridge Reply:
December 12th, 2008 at 6:01 pm
thanks will check it out.

[Reply]
11 12 2008: Craig Edmonds (22:08:21) :

I have always copied the .sql fiel and restored from there. Never done it like this. Cool!

[Reply]