How to Restore Your WordPress Blog With phpMyAdmin

Unfortunately blogs crash. Servers go down. Sometimes you decide to move a blog or other wise rearrange your websites. If you have a backup or you have exported your blog then you will need to know how to import and restore it.

Do you backup your blog?

You can easily backup your blog automatically using the WP-DB-Backup plugin by Austin Matazko. With this plugin your blog will send a regularly scheduled backup to your email. This will help you in the case of an unplanned failure. If you use this feature, you will need to visit your email where the backups go and download your latest backup. Note where it saves.

Is there a planned blog failure?

Well, perhaps not “planned” but before you make major changes it is always best to back up your blog. If you use your php to backup you will need to note where your file saves. This does not go into how to export, but will tell you how to restore your blog. Like wise if your blog failed and you use WP-DB-Backup. But first you need to visit your phpMyAdmin.

What is phpMyAdmin?

This is an open source tool used to handle the administration of MySQL. To keep this simple MySQL is a system to control your SQL statements or Databases. The phpMyAdmin basically lets you perform administrative duties, such as creating, modifying, or deleting databases or lines.

So where is my phpMyAdmin?

Once you have your backup, or your export. Log into your cPanel. This is your back office assigned by your webhost. Look for a box labeled databases. In it you should see phpMyAdmin. Click it, and you will be taken to a strange looking place.

How do I find Databases?

From the main menu, underneath My SQL or localhost, pick Databases. You will then see your database(s) depending on how many you have. Click the one you need to restore.

How do import my Database?

Across the top of the screen will be a row of tabs. You need to click the Import tab. The next screen will have a “Location of Text File” box and a Browse button. Click Browse and find your backup file. Make certain you have the SQL radio button checked and press Go. If you need more information visit Codex WordPress.

How does your blog look?

Your blog should be restored. You will probably need to make some adjustments on your WordPress blog to get it back to your previous settings.


Source link