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
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
Thanks for watching
thanks much, guy
Reply
Your article made me worried – when did I made my last database backup?! Thank you to remind me.
Reply
Very helpful your description – thank you for posting.
Reply
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
I have always copied the .sql fiel and restored from there. Never done it like this. Cool!
Reply
Hey thanks for the info. I tried to copy my database from oner server to another, but got error messages. After I read your post i clicked the export option “add DROP TABLE” and it worked. So great job and nice videos too.
Reply
[...] Re: Clone A Wordpress Blog – Best Way? There may be some software, I’m not sure. But it’s really not that hard. Keep all of your plugins/themes in a folder, upload them to the appropriate directories. As for the database, it can easily be imported/exported in PHPmyadmin. I can’t really explain every step here, but once you do it once or twice it’s pretty easy. Here’s what a quick Google search brought up… phpMyAdmin: Backup and Restore Wordpress Database [...]
This might be a good idea. I havent tried this one but I will.
thanks for sharing dude..
Reply
[...] Originally Posted by yesacpow here is your answer: How To: Move Your WordPress Blog to a New Domain Those are the instructions that I use as well or if you want to back up and restore the database this is how I do it: phpMyAdmin: Backup and Restore Wordpress Database [...]
it is necessary to have a back up for the wordpress data base?
Reply
very nice
Reply
Cpanel + Fantastico + Wordpress + ‘plugin updating’ plugin = Blog happiness. Update with a few button pushes (in theory). Make a backup before you do so and save in an older version of SQL too in case your new host doesn’t support the latest.
Reply
[...] There are moments in life that you might say "OOH SH$T! What was the password", I lost my WordPress admin name, I don’t remember it, I didn’t get the email with my password, etc. Well nothing to despair, the solution takes less than two minutes. To proceed you need to log in into your website control panel that most likely is provided by your web host, and most like you have phpMyAdmin too. In fact we need phpMyAdmin to put our hands into WordPress database and do modifications in there, but remember it is not a playground, a mistake and you can say bye bye to your blog. Just don’t wonder what the "drop" link might do, simply follow these few steps and you should bet alright. Just to be on the safe side, ALWAYS backup your database, if you have no clue how to do that just read my other tutorial. [...]