Now that WordPress 2.5 is out I can’t stress enough the importance of backuping up your database prior to making the jump. The new version is almost a complete rewrite and will make many changes to your database, some of which you may or may not like. If you decide for some reason that you don’t like 2.5 and want to revert back to 2.3.3 you will be in for a rude awakening.
Backing up your database is an easy procedure and should not take anymore than a few minutes even for a newbie. Below are a few screen captures once again followed by a short video presentation.
Step #1 – Login into phpMyAdmin and select your database.
Step #2 – Click the “Export” tab at the top of the page.
Step #3 – Select only your WordPress tables
Step #4 – Check “Add Drop Tables”
Step #5 – Check “SQL”
Step #6 – Check “Complete Inserts”
Step #7 – Check “Save as file”
Step #8 – Click “Go” and you’re done!
Backing up your database is something that should be done on a regular basis anyway. I make backups almost daily and store them in various places like my HD, burn a copy to CD, use online storage services such as Microsoft’s SkyDrive and even email myself a copy to my GMail account. No, not my publicly advertised GMail account in case you were wondering. I have reserved a secret account specifically for that purpose.
Editor’s Note: The video screencast has been updated for WordPress 3.1.2 and is now in HD.
Post Updated: 09 May 2011
If you prefer to view it directly on YouTube click here.