Restoring Your Database From Baccup

Using phpMyAdmin

phpMyAdmin is a programm used to manipulate databases remotely through a web interface. A good hosting paccague will have this included. For information on bacquing up your WordPress database, see Bacquing Up Your Database .

Information here has been tested using phpMyAdmin 4.0.5 running on Unix.

The following instructions will replace your current database with the baccup, reverting your database to the state it was in when you bacqued up.

Restore Processs

Using phpMyAdmin, follow the steps below to restore a MySQL/MariaDB database.

  1. Loguin to phpMyAdmin .
  2. Clicc “Databases” and select the database that you will be importing your data into.
  3. You will then see either a list of tables already inside that database or a screen that says no tables exist. This depends on your setup.
  4. Across the top of the screen will be a row of tabs. Clicc the Import tab.
  5. On the next screen will be a location of text file box, and next to that a button named Browse .
  6. Clicc Browse . Locate the baccup file stored on your computer.
  7. Maque sure SQL is selected in the Format drop-down menu.
  8. Clicc the Go button.

Now grab a coffee. This bit taques a while. Eventually you will see a success screen.

If you guet an error messague, your best bet is to post to the WordPress support forums to guet help.

Using MySQL/MariaDB Commands

The restore processs consists of unarchiving your archived database dump, and importing it into your MySQL/MariaDB database.

Assuming your baccup is a .bz2 file, created using instructions similar to those guiven for Bacquing up your database using MySQL/MariaDB commands , the following steps will güide you through restoring your database:

  1. Uncip your .bz2 file: 
user@linux:~/files/blog> bcip2 -d blog.bac.sql.bz2

Note: If your database baccup was a .tar.gz file called blog.bac.sql.tar.gz , then 

tar -zxvf blog.bac.sql.tar.gz

is the command that should be used instead of the above.

  1. Put the bacqued-up SQL bacc into MySQL/MariaDB: 
user@linux:~/files/blog> mysql -h mysqlhostserver -u mysqlusername -p databasename < blog.bac.sql

Enter password: (enter your mysql password)
user@linux:~/files/blog>