Here my steps to backup my WordPress sites:

I. Backup WordPress database with PHPMyAdmin
Note: My cPanel using PHPMyAdmin ver 3.5.8

Backup Process with phpMyAdmin
a. Log into phpMyAdmin on your server
b. Click the name of your WordPress database if you have several databases.
c. The next screen will show you all the tables inside your WordPress database,ignore those, and click the ‘Export‘ tab on the top set of tabs.
d. If you have other programs that use the database, then choose only those tables that correspond to your WordPress install. They will be the ones with that start with “wp_” or whatever ‘table_prefix‘ you specified in your ‘wp-config.php‘ file.
Continue reading →