One of the extremely important operation when starting an online business/blog/website and using WodPress is to  to Backup WordPress Database. Problem comes when its least expected, and everyday approximately 15-25% people loose their Data whether its offline or online.

WordPress Database Backup is really very very important for a webmaster after successfully creating a website.

What is the use of Database Backup ?

WordPress website backup eliminates out many troubles from a bloggers life if any emergency occurs at any instant.

For example: If your website gets hacked or you accidentally lost all your important contents due to some human illogical errors or some other issues then your backup database comes into play. It will now definitely shoot out all your tensions and worries in just seconds.

That’s why an administrator must frequently backup their database and files so as to be on safe side.

What type of Contents are stored in Database Backup ?

  • Pages
  • Posts
  • Plugins & Plugin settings
  • Themes & Theme settings
  • Custom Post types
  • Widgets
  • Menus
  • User-Accounts
  • Comments
  • Layouts & Templates
  • Tags
  • Categories

The most important thing to know in the WP database backup is to make an urgent backup of WordPressDatabase File which contains all the posts, comments, pages etc and to backup the WP-content file which contains the entire content of the website.

Also Check Out this : 20+ BackupWordPress Plugins (Full Backup – Database + Files)

With these two files restoration and migration of a website to any other web hosting service becomes possible.

There are many tools available in the internet industry for backup and recovery of a WordPress website/blog.

Lets discuss the main and the most used techniques by bloggers worldwide.

The most easy, reliable and the best WordPress backup is that you are already aware of. Lets see.

1. Backup WordPress Database using WordPress Dashboard

Step 1: Login to your website’s Dashboard and navigate to the ‘Tools’ section.

Step 2: In the Tools section go to “Export

Step 3: In the Export option select ‘All content‘.

export_wordpress_database

The last step is just click on the ‘Download Export File’. You will able to make a backup of your entire WordPress blog in the XML file format.

Contents such as pages, posts, comments, custom post types, categories, tags, users etc will be stored in the backup data.

Method 2 :

 How to use phpMyAdmin to  Backup WordPress Blog

This is one of the most handy tool in the field of WordPress database backup. This tool has the option for viewing, editing, exporting & importing database from one to another.

This tool is quiet easy to use and implement as its available in the cPanel itself and almost all hosting providers also.

The best thing to know that it is Free of cost and you can just access it from your web hosts control panel.

This phpMyAdmin tutorial will lead you to the best backup guide. Lets walk through it.

Step 1: Login to your cPanel and search for to phpMyAdmin in the database section hopefully.

Note: Now if you want to learn how to access phpMyAdmin then in the URL /Address bar enter  “localhost/phpmyadmin”.

Step 2: Now after you locate it then go to the main menu of phpMyAdmin

Step 3: In the main menu move to the left sidebar, you will find a search box, look out for wpdatabase or wp-content or any other file which you want to backup.

Step 4: After you select the file just click on the ‘Export’ tab a bit above in the menu.

localhost_phpmyadmin-blogfruit

Step 5: In the Export method on the export page select the ‘Quick – display only the minimal options‘ and in the next box select ‘SQL‘ and click Go.

 localhost_phpmyadmin-export

Your job is done after the click a .sql file will be downloaded in your computer. Save the file in the appropriate place and all your database are now under backup.

You can use the SQL file to import the the entire database anytime whenever you need to migrate the website.

How to use phpMyAdmin to Import or Restore Database

Restoring or Importing database is well-to-do task using phpMyAdmin backup database.

As we have used the link Export to export all database, similarly beside the export tab we have the Import tab.

Just click on the Import tab and you will be asked to Upload the .sql backup file.

After the upload just click on the Go button to restore all your database.

Thus both Exporting & Importing using phpMyAdmin was quiet easy to do.

3. Backup your WordPress Blog using cPanel Backup method

If you are owing a cPanel i.e control panel of any web hosting company then this job becomes quiet easy for you to implement, lets see how.

Step 1: Login to your cPanel and look out for the ‘Backup’ icon in the panel.

Step 2: Once you are directed to the Backup page, scroll down and look for the ‘Download a MySQL Database backup‘.

In the section check out the database which you want to backup, randomly assume it as the ‘WordPress Database‘, just select it.

Step 3: After that a compressed SQL file will be downloaded in your computer. Just save the file as it will play its role in the long run.

4. Regular Backup Services from Web Hosts

One of the important benefits a user gets if he/she uses a costly and excellent web hosting plan.

In this the web hosting companies provide a regular and effective database backup service for a blog. In this the companies usually captures the snapshots of the database frequently.

If a user wants to download the snapshots then he may ask for the permission to access the web based WordPress backups.

This automated backup feature is usually a premium feature which is provided by top web hosting sites like the HostGator, Bluehost, GoDaddy, iPage etc. Depends on your plan if are able to use the feature for your blog or not.

This is a feature which each and every user must certainly pay for to tighten their security.

Related Useful Tips

One of the best and effortless way for backing up database is to use the Backup Service.

Backup Service is provided by companies like:

  • VaultPress
  • CodeGuard
  • BlogVault
  • Backupify
  • myRepono
  • Backup Buddy