Backup MySQL Databases with WordPress

Imagine you run a blog and had worked hard to create and post content. What will happen if the server in which your blog is hosted crashes? If you are lucky you will get a backup of your database from your provider. Sometimes, the damage will be severe and you will not get a copy of your database backup.

In order to prevent an incident as specified above, you need to capture backup of your database from time to time. It is possible to download a copy of your database backup using PhpMyAdmin, which is available with CPanel.

However, you can also generate a backup of your database from within WordPress.

(1) Download WP-DBManager plugin – http://wordpress.org/plugins/wp-dbmanager/

(2) Upload the folder – wp-dbmanager to wp-content/plugins folder using FTP. You can make use of FileZilla software to upload files.

(3) Login to WordPress dahboard and activate the plugin.

Figure_wp-dbmanager

(4) You can also directly search for WP-DBManager plugin from within Plugins section under WordPress dashboard.

(5) You will view the following message soon after activation

Your backup folder MIGHT be visible to the public

It indicates that you have to move .htaccess file to the folder mentioned on the displayed message

(6) You will find an entry named – Database on the left side navigation panel

(7) You have to rectify the errors which you will see in red color before proceeding to backup the database.

(8) The plugin will display the details of all the previous backups under Manage Backup DB page

(9) You can also execute SQL queries by selecting Run SQL Query option

Note that there are plenty of plugins available for database backup. However, I advise you to make use of backup utility available with CPanel so that you can avoid the need to give permissions to folders.

Looking for quality Linux Hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , | Posted under cPanel/Linux Hosting, MySQL | RSS 2.0

Author Spotlight

Anand Narayanaswamy

Anand Narayanaswamy

Anand works as a freelance writer based in Trivandrum, India. Anand runs NetAns, which provides hosting for developers and small scale businesses. He also provides blog installation services. He runs his own blog - www.learnxpress.com and maintains a video portal which publishes videos related to web hosting, windows, social media and other technology related matters- http://tv.learnxpress.com You can follow Anand on twitter - @visualanand

Leave a Reply

Your email address will not be published. Required fields are marked *


× 9 = 36

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>