Skip to main content
Noble Desktop Publishing Team/3 min read

Database Backup

WP-DB-Backup Setup

1

Install WP-DB-Backup Plugin

Plugins → Add New, search 'wp-db-backup', click Install Now.

2

Open Tools → Backup

Adjust which tables to back up beyond the WordPress core tables.

3

Choose Download to Your Computer

Then click Backup now! to save the .sql file locally.

4

Restore by Importing the SQL

Use phpMyAdmin to import the backup if disaster strikes.

Master WordPress at Noble Desktop

Noble Desktop's WordPress Bootcamp teaches themes, plugins, and custom site development.

Learn how to install the WP-DB-Backup plugin, back up and restore your WordPress site's database, adjust the backup settings, make changes to your database, and restore it using the backup in this comprehensive WordPress tutorial.

Topics Covered in This WordPress Tutorial:

Installing the WP-DB-Backup Plugin, Backing up & Restoring

Exercise Preview

Database Backup

Exercise Overview

WordPress sites rely on a database to contain all the content of the site. Therefore, it is very important to back up your database on a regular basis. Luckily, there’s a great plugin that can instantly back up or schedule backups for your site. In this exercise, you will learn to use the WP-DB-Backup plugin to back up a site’s database.

Installing WP-DB-Backup

  1. Go to:
    • Mac: localhost:8888/mrp/wp-admin
    • Windows: localhost/mrp/wp-admin

  2. Log in to the site.

  3. Go to Plugins > Add New.

  4. In the Search field, type wp-db-backup and hit Return (Mac) or Enter (Windows).

  5. Find WP-DB-Backup (it should be at the top) and click Install Now.

  6. When asked if you are sure you want to download the plugin, click OK.

  7. Click Activate Plugin.

Adjusting Settings

  1. Let’s configure the plugin! On the left side of the Dashboard, go to Tools > Backup. Here you can adjust the various WP-DB-Backup backup settings.

  2. The WP-DB-Backup plugin will back up the core tables by default; if you want to back up any other tables, you will need to check them.

  3. Scroll down to Backup Options.

  4. Choose Download to your computer, if it’s not already selected.

  5. Click the Backup now! button.

  6. If it doesn’t automatically download, then a window will pop up asking if you would like to save the file. Click the Save File button. If it asks where to save, put it in your Downloads folder.

Making a Change

  1. Let’s make a change to our database so that we can make sure the backup is working correctly. On the left side of the screen, click Pages.

  2. Click the checkbox next to Title to select all of the pages.

  3. From the Bulk Actions menu, choose Move to Trash.

  4. Click Apply. Oh no, all our pages are gone! Let’s test the backup by restoring our database.

Restoring with the Backup

  1. In the event something catastrophic happens and you lose your database, you will need to restore it from a backup. To do this, log into phpMyAdmin as shown below:

Mac

  1. Switch to the MAMP application.
  2. Click Open WebStart page if the MAMP start page doesn’t automatically open in your default browser.
  3. On the start page, in the nav menu, go to Tools > phpMyAdmin.

Windows

  1. Open XAMPP.
  2. In the control panel, ensure the Apache and MySQL services are running.
  3. Open your browser and go to localhost
  4. On the start page, on the left sidebar, under Tools, click phpMyAdmin.

  1. On the left, select mrp from the list of databases.

  2. Click on the Import tab.

    bonus import

  3. On the next screen, click the Choose File or Browse button.

  4. Navigate to your Downloads folder (or the folder the database was downloaded to).

  5. Double–click the backup SQL file you had just downloaded (it should be named mrp_wp_YYYYMMDD_###.SQL.gz).

  6. Click the Go button.

  7. Go to:
    • Mac: localhost:8888/mrp/wp-admin
    • Windows: localhost/mrp/wp-admin

  8. On the left side of the screen, click Pages. Whew, all our pages have been restored! That was a close one.