You should backup your database regularly, and always before an upgrade.

Find phpMyAdmin

If you do not know where your phpmyadmin is, the guide is here.

Inside phpMyAdmin

Using phpMyAdmin

phpmyadmin image

You may have several databases. Click the one that holds your WordPress data

phpmyadmin image

This shows only default tables. You may have more tables - this would happen if you have any statistics plugins, anti-spam plugins.

phpmyadmin image

1 Select ONLY those that are your Wordpress blog.

2 Check the "Add DROP TABLE" box

3 Check the "Complete inserts" box

4 Check the "Save as File" box

5 Check the "None" for compression. If your database is very large use a compression method.

6 Click Go. The data will now be saved into your computer.

Keep these files safe !

phpmyadmin image

Questions ? Answers !

How often should you backup ?

That depends on how often you blog, how often you want to do this, how you would feel if your database was lost along with a few posts. It's your decision.

Can you use this method to backup other data ?

Yes, and you should. Backups are good.

My database backups are huge ! Can I do anything about that ?

Possibly. Typically, statistics plugins can add large amounts of data, as can anti-spam plugins. Because they are constantly gathering information, the database can swell significantly. When backing up the database, such information is probably not important to keep. Do not mark those tables for backup when selecting them at step 1 above.

Can this backing-up be automated ?

Yes. If you are hosted on A Small Orange or you know that your server has the MUTT client installed, go have a look at my Cron Script.

Alternately, I would recommend Skippy's excellent plugin.


These pages are independent of
All design, content & images © Mark 2004-2015. All rights reserved.