With a multitude of upgrades released every 30 seconds in the WordPress community, it’s integral that a regular back-up is taken just to be on the safe side. Although there are plugins available which do this for you, I’m a cynical old bugger and don’t trust anything or anyone.
Most hosts supply phpMyAdmin. If you have access to MySQL Databases, chances are you have phpMyAdmin. You will need to find this little tool. If you’re with Site5, go into SiteAdmin and select the option from under MySQL Databases in the left menu. If you’ve got standard cpanel hosting, go into cpanel > MySQL Databases, and phpMyAdmin is linked near the bottom.
Once your phpMyAdmin window is open, find your WordPress blog in the menu on the left hand side. This may be in a list or a drop-down menu, but will be in there. Usually named username_xxx, where username is the name you use to log into cpanel/SiteAdmin and xxx is the name of the database. Once selected, the main database page should load. Choose Export from the menu across the top:
When the Export page has loaded, make sure all tables are selected:
Then, near the bottom of the page tick ‘Save as File’ > zipped option. When you’re ready, click Go. Save the file to your computer, and tada: one database back-up.