How to backup your WordPress database : A Simple Guide


WordPress like any other web applications is subjected to possible disasters. Keeping your WordPress database data backed up saves you from disasters that are of accidental nature or the once that occur due to technical faults. Webmaster is the person who solely holds the responsibility for backing up their website or websites. Regularly backing up your data ensures that you do not lose data or if there is any tempering of data you suffer least data damage.

There are two things that you need to take in account when you think of backing up your WordPress data.
First, what to back up i.e. backing up database and file and second when to back up.

WordPress powered websites can be backed up both manually and by using plug-ins. We will discuss both back-up options one by one.

How to back up WordPress website:-

• Most of the reliable web hosts facilitate webmasters with backup tools the first one is called the backup wizard it is a simple one click back-up database tool, the second tool that most of the web host providers provide is PHP My Admin a interface you can use for backing up your database.

• You can download a copy of your WordPress files using FTP client like Filezilla or through UNIX Shell.
• You can create a mirror copy of your WordPress files using WinSCP.

Why and when back is essential:-

Taking a backup of your WordPress database is essential, especially when you are upgrading to a new version or when you are moving your WordPress website from one physical location to another.

Manual WordPress backup process:-

• To backup your WordPress database you need be familiar with PHP My Admin. Follow the steps below to back up your database manually.

1. On the control panel (provided by your webhost) look for database manager and choose MySQL database.
Manual WordPress backup process

2. After choosing MySQL database log look around for Around for PHP My Admin, it can be found under browse database.
MySQL database log look

3. After Clicking on Browse Database you will come across following screen.
Browse Database

4. Type in your username and password to login into your PHP My Admin panel. Choose your database name from options as listed in screen below.

PHP My Admin panel

5. After choosing you database look for export option as shown in screen below to back up your database. This will back up your database.

database look for export

Backing up WordPress database using plugin:-

Using a plug-in for backing up your WordPress database is a speedy way for performing the backup task.
• To back-up your files using plugin follow the screen options below. Firstly go to add plugin options type in the name of the plugin in the search box. After searching the plugin click on install for installing the plugin. Once the plugin is installed click on activate plugin to use it. For Convention sake we have used WP-DB-Backup Plugin though there are dozens plug-ins out there on the web.
Backing up WordPress database using plugin:-

• Once the plugin is installed it will appear under tools as shown in screen option below.
plugin is installed

• The plug-in allows you to backup all your database files. It will send a copy of your database to you via email and it will also leaves a backup copy of your database at your web server. Refer to screen options shown below.

database files

• Top five WordPress database backup plugins.

1. Online Backup for WordPress
2. Back up WordPress
3. WordPress backup to dropbox
4. Wp-db-backup
5. Back WP up
Being a webmaster securing website is your top most priority, by following the steps mentioned above you can all be on safe and sure side.

Recently Published

»

Importance and actions of cloud computing in e-commerce business

The e-commerce industry is growing in leaps and bounds, and, ...

»

How to remove Options from One Select Box and retain One Option?

One can easily remove  options of a select box from HTML and append ...

»

How to Ensure that Users Do Not Deactivate The Critical WordPress Plugins

It’s no secret that among all the remarkably useful features of ...

»

How to scroll to the top of a webpage using jQuery ?

If you are looking for an extraordinary method of smoothly scrolling ...

»

11 sources to gain perfect knowledge of html5 semantic tags

1. Html5tuts Html5tuts is a site dedicated to HTML5. Feel free to ...

»

How to move an element into another parent element using jQuery?

An important piece to the puzzle when coding with jQuery is that how ...

»

10 optionally Good WordPress Typography Plugins You could Opt For

It is not necessary that the person will follow the standard guide ...

»

8 creative 3d slider wordpress themes to keep your blog active

1. Display Display is a WordPress Theme best used for Portfolio and ...

»

11 quick remote screen sharing apps worth trying

1. Join Me Easy to start, easy to join, easy to manage, join.me takes ...