rofessional bloggers might prefer to back up the blog database manually (and this will be the only option if your blog platform doesn’t have an export option or back-up plugin). The most commonly used blogging database is MySQL and your host will have sent you details of how to access it, often through your hosting account control panel and often using phpMyAdmin. Refer back to your welcome email because it differs from host to host.
Click to export
Log in, then click the name of the database used by your blog in the sidebar. In most cases, there will only be one entry here.
This displays a list of all of the tables of data that underpin your site. You can now click Check All at the bottom of the table, then select Export from the With Selected menu. Leave the options on the following page as their defaults and then click Go to download the backup.
To import it later, click on the name of the database in the sidebar, click the Import tab and navigate to the file you’ve just downloaded. Click Go to reinstate its contents.
Exporting the raw contents of your blog database requires that you log into the database control panel, which more often than not uses phpMyAdmin.
Once you have created a backup of the database contents you can easily reinstate them through the Import tab.