SIGN IN YOUR ACCOUNT TO HAVE ACCESS TO DIFFERENT FEATURES

FORGOT YOUR PASSWORD?

FORGOT YOUR DETAILS?

AAH, WAIT, I REMEMBER NOW!
Zyger
  • About
  • Services
    • Overview
    • Design
    • Development
    • Hosting
    • Marketing
    • IT Services
  • Portfolio
  • News
  • Contact

Zyger designs and builds
only the very best websites!

Restoring Your Database From Backup

by Shu-aib / Wed, 03 Feb 2016 / Published in Design, Hosting, Website, Wordpress

Restoring Your Database From Backup

Using phpMyAdmin

phpMyAdmin is a program used to manipulate a database remotely through a web interface. A good hosting package will have this included. For information on backing up your WordPress database, see Backing 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 backup, reverting your database to the state it was in when you backed up.

 

Restore Process

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

 

  • Login to phpMyAdmin.
  • Click “Databases” and select the database that you will be importing your data into.
  • 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.
  • Across the top of the screen will be a row of tabs. Click the Import tab.
  • On the next screen will be a location of text file box, and next to that a button named Browse.
  • Click Browse. Locate the backup file stored on your computer.
  • Make sure SQL is selected in the Format drop-down menu.
  • Click the Go button.
  • Now grab a coffee. This bit takes a while. Eventually you will see a success screen.
  • If you get an error message, your best bet is to post to the WordPress support forums to get help.

 

Using MySQL Commands

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

 

Assuming your backup is a .bz2 file, created using instructions similar to those given for Backing up your database using MySQL commands, the following steps will guide you through restoring your database:

 

  1. Unzip your .bz2 file:

 

user@linux:~/files/blog> bzip2 -d blog.bak.sql.bz2

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

 

tar -zxvf blog.bak.sql.tar.gz

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

 

  1. Put the backed-up SQL back into MySQL:

 

user@linux:~/files/blog> mysql -h mysqlhostserver -u mysqlusername

-p databasename < blog.bak.sql

 

Enter password: (enter your mysql password)

user@linux~/files/blog:>

  • Tweet
Tagged under: Avatars, Backup, Computer, Database, Databases, Laptop, Restore, Tips, Tutorials, updates, website, Website desgining, wordpress tips, Worpress, ZYGER

About Shu-aib

What you can read next

WordPress Backups
Photoblogs and Galleries
Developer Documentation Plugins

Leave a Reply Cancel reply

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

Recent Posts

  • New to WordPress – Where to Start

    If you are new to WordPress, here is a step-by-...
  • Testimonial-Francis Benfatto

    Hi all, Zyger without a doubt has been the d...
  • Testimonial-Adele van Straaten

    Ambition… Our brand is based on that very wo...
  • First Steps With WordPress

    First Steps With WordPress   Now What? You...
  • Introduction To Emoji

    Emoji   Introduction To Emoji Emoji are th...

Recent Comments

    Archives

    • Feb 2018
    • Feb 2016

    Categories

    • Design
    • Hosting
    • Media
    • News
    • Testimonials
    • Website
    • Wordpress
    • Wordpress tips
    • Zyger
    • Zyger Design

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org



    ©2018. Zyger
    All Rights Reserved

    TOP