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.
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.
Thanks for watching