Publish a WordPress Site: Backup and Restore the Database


show more Backing up and restoring the database provides you with in-depth training on Web. Taught by Joseph Lowery as part of the Dreamweaver and WordPress: Core Concepts show less
please wait ...

Backing up and restoring the database

Backing up and restoring your database falls into the fact of life category of web professional chores. In this lesson, I'm going to walk you through the process of exporting your database completely, and then moving it to another location. I'll also discuss how you can restore the data to the same database. So, let's go to MAMP that I have open here and click Open the start page. So, I can get to phpMyAdmin. We will use this tool which is found on many web hosts and also accessible for you to download and install on your own systems at no cost.

So, I'm going to select my roux_blog database here. This is all the information that WordPress stores. You can see all the tables it creates. And should you so choose, you can easily choose a table such as posts and then select browse to see all the information. But what we're really interested in is going to roux_blog here and then exporting the entire database. Now, the latest version of phpMyAdmin has an option for choosing Quick and ...

Backing up and restoring the database
Video duration: 8m 10s 5h 44m Intermediate Updated Oct 23, 2012

Viewers:

Backing up and restoring the database provides you with in-depth training on Web. Taught by Joseph Lowery as part of the Dreamweaver and WordPress: Core Concepts

Subject:
Web
Software:
Dreamweaver WordPress
Author:
please wait ...