When you use blog as platform for content publishing, one crucial part of it is taking backup regulary as blogs get updated on daily basis. If you are using wordpress, you are lucky because there are plenty of plugins that simplify the task and you don’t have to dig phpMyAdmin. In this tutorial we will learn how to create and download wordpress blog’s database backup.

1. Download Wordpress Database Backup plugin. http://www.ilfilosofo.com/blog/wp-db-backup

2. De-compress files locally.

3. Upload, wp-db-backup folder to \wp-content\plugins directory.

4. Open http://www.yourdomain/wp-admin/plugins.php in your browser or click on the Plugins url in your dashboard.

5. Activate the plugin.

6. Navigate to Manage > Backup. This plugin will backup all the core wordpress files automatically. You can select additional tables from the right pan. These tables might be created by other plugins. Click on Select All URL to include all the tables in the backup.

7. Next you have to select the backup options. You have three options. You can save the compressed backup file in your remote server, you can download to your server or you can ask plugin to send you backup by email. Provide a valid email address there. For now select option Download to your computer and press Backup button. A progress bar will tell you about the percentage of backup task completed.

Do not close the browser, refresh the page or click stop and back buttons while backup is in process. After completion, browser’s save dialogue will popup and you can save .gz file in your machine. This compressed file contains .SQL file. It is good practice to take backup regularly.

8. You can also set backup scheduling from there. Set the schedule frequency, include extra tables you want to backup, provide a valid email address and click on submit button. If you have a large database, you should not use this option.

This wraps up the tutorial, remember one thing backup early, backup often.

Subscribe to the post comments feeds or Leave a trackback