How To Make a WordPress Database Backup Manually

It is strongly recommended that you backup your database at regular intervals and before an upgrade.

Using phpMyAdmin

Information below has been tried and tested using phpMyAdmin version 4.4.13 connects to MySQL version 5.6.28 running on Linux.

How To Make a WordPress Database Backup Manually

Top ↑

Quick backup process

When you backup all tables in the WordPress database without compression, you can use simple method. To restore this backup, your new database should not have any tables.

  1. Log into phpMyAdmin on your server
  2. From the left side window, select your WordPress database. In this example, the name of database is “wp”.
  3. The right side window will show you all the tables inside your WordPress database. Click the ‘Export’ tab on the top set of tabs.
How To Make a WordPress Database Backup Manually

4. Ensure that the Quick option is selected, and click ‘Go’ and you should be prompted for a file to download. Save the file to your computer. Depending on the database size, this may take a few moments.

How To Make a WordPress Database Backup Manually

Top ↑

Custom backup process

If you want to change default behavior, select Custom backup.  In above Step 4, select Custom option. Detailed options are displayed.

How To Make a WordPress Database Backup Manually

Top ↑

The Table section

All the tables in the database are selected. If you have other programs that use the database, then choose only those tables that correspond to your WordPress install. They will be the ones with that start with “wp_” or whatever ‘table_prefix’ you specified in your ‘wp-config.php’ file.

If you only have your WordPress blog installed, leave it as is (or click ‘Select All’ if you changed the selection)

Top ↑

The Output section

Select ‘zipped’ or ‘gzipped’ from Compression box to compress the data.

How To Make a WordPress Database Backup Manually

Top ↑

The Format section

Ensure that the SQL is selected. Unlike CSV or other data formats, this option exports a sequence of SQL commands.

In the Format-specific options section, leave options as they are.

How To Make a WordPress Database Backup Manually

Top ↑

The Object creation options section

Select Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER statement. Before table creation on target database, it will call DROP statement to delete the old existing table if it exist.

How To Make a WordPress Database Backup Manually

Top ↑

The Data creation options section

Leave options as they are.

How To Make a WordPress Database Backup Manually

Now click ‘Go’ at the bottom of the window and you should be prompted for a file to download. Save the file to your computer. Depending on the database size, this may take a few moments.

Do you want to know how to make a WordPress database backup manually without using a plugin? Knowing the manual method allows you to quickly create a database backup whenever you need it. In this article, we will show you how to make a WordPress database backup manually.

WordPress Database Backup Manually

When and Why Make a WordPress Database Backup Manually

You should always install and setup a WordPress backup system for your site. This allows you to restore your site should something go wrong.

Many users lose access to their WordPress admin area after a hack attempt or some plugin error. In these cases, most tutorials recommend that you create a complete WordPress backup.

However, since you cannot access the admin area, it would be hard for you to use a plugin for backups. This is where knowing how to make a WordPress database backup manually comes in handy.

A manual database backup is exactly the same as the database backups created by a plugin.

Having said that, let’s take a look at how to easily make a WordPress database backup manually.

Creating a Manual WordPress Database Backup from cPanel

Most good WordPress hosting companies also offer easier ways to download on demand backups. Here is how you can use that to make a manual WordPress database backup.

Simply login to your hosting control panel and scroll down to the files section where you will see the Backup button. Bhosting and all have similar options.

On the backups page, scroll down to partial backups section and click on your database name to download your database backup file.

How To Make a WordPress Database Backup Manually

You can also download your WordPress files backup from this page if you need to.

Editor’s Note: You can make WordPress database backups manually, but keep in mind that it is not an alternative to a proper backup solution for your WordPress site.

There are situations when you may not have access to your WordPress database at all. Like if your hosting company suspends your account, or loses your data.

Another possible scenario is when some hacker has injected data in your WordPress database, cleaning an infected database would be a lot more difficult.

Use a proper backup plugin to automatically store your WordPress database backups on the cloud. We recommend using BackupBuddy, it automatically creates and stores your backups on a cloud storage service like Google Drive, DropBox, or Stash.

 

Leave a Reply

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