Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Backing up and restoring the database

From: Dreamweaver and WordPress: Core Concepts

Video: 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.

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 Custom.

The older versions only have the Custom one. So let's move to that, so you can see what the whole thing looks like. It's a slightly different screen, but it basically has all the same options. So, I'm going to select all the tables, make sure those are all selected. You have two options, one for saving as output to a file, and one for saving output as text. This time I am going to save the output as text. We'll keep the format as SQL. Just so you know, there are a ton of other options here. Then there's format specific options, including displaying comments, et cetera.

Typically, I find that just keeping the default options works well. So let's scroll down to Object creation options. Again, if you're moving your data to a different location, such as going from a development situation to a live server, keep the Object creation options just as they are, because what you are going to be doing is bringing your data into an empty WordPress installation. Let's continue scroll down. The Data dump options, again, keep these all the same. And when you get all the way down to the bottom, there is a little lonely Go button over here.

In older versions, it's on the right; in the newer versions, it's on the left. So I'll click Go. And pretty quickly, because we don't have a ton of data, you'll see all that information available to you. So to demonstrate the process here, what I am going to do is press Command+A to select everything and then copy it all. Now, I am going to go back to my localhost, choose Databases. Let's create another database. I am just going to call this one roux3. Click Create. Now, this is in the same situation as if you were just installing WordPress, and it was going to add all of its database tables and the like.

But instead of running through the WordPress installation, I'm going to select roux3 here, the database I just created, and go to my SQL tab. Now, you might think what you probably would do would be go to Import. You would only do that if you had saved the data as a file. Because I saved it as a text file and then copied it into memory, I can go right to my SQL tab. So I'm going to just paste in my copied SQL by pressing Command+V. Now, before we click Go, you actually want to go all the way up to the top of the information.

In this situation what I will need to do is to scroll over a little bit to the right so I can see the scrollbar and then grab it and go all the way to the top. It looks like that's fixed that. What I want to do is get to the name where it says the Database name. I am going to change that to whatever database that you're bringing it into. Now, we exported it from roux_blog, but we want to bring it into roux3. So, we'll add the 3 there, and now I can go ahead and click Go. Let's see what it did.

Now again, another difference between older and newer versions of PHP, with newer versions, you won't get a confirmation message that the data was imported. So just click the name of the database, and you'll see all of your tables in place. Older versions put up a mission accomplished type of statement. Now, we've bought our data in, but we are not quite finished. There are a couple of really critical chores. And the first one involves the wp_options table. So, select that. You want to change two values, the first one is right up top, and it's actually option_id number 1.

And if I go ahead and click on the Pencil Edit icon, you can see that what this is is the site URL. And you want to make sure to change the path, and I am just going to change this to my roux3 designation here. You want to make sure to change the path to whatever your new location is. If it's something that's on the website, you might want to make it something like this. Now, once you've got the website address up there, copy that, and then click Go. Now, you copy it because you're going to need to put it in another location, and you want to make sure that they're the same.

Of course, you want to make sure that they're both correct. Now, we need to go to the next page in order to see the next item that we have to change. So, click the next button that you see here, which is just the greater-than sign. We want to go to item 37 and make that edit there. So, this is the home URL. You recall in the General Settings category, we had both a site URL and home URL. We want to make that they're both the same. If you don't do this, you'll get into this kind of endless loop where when you try to log in, WordPress thinks that you're trying to log in to the original URL site and will keep redirecting you there. So, make sure you make these two changes.

I'll click Go to confirm that option. Now, there is one more thing that you may need to change, and that's the wp-config.php file. Let's head back to Dreamweaver. I am going to extend my Files panel, open it up all the way. I am going to go into the blog folder here. The file I'm looking for is the one that WordPress first created when you installed it, and it's called wp-config.php. Now, don't get confused, there is one that's wp-config-sample which is of course just an example of how the page is structured. Actually, it's got the information in it.

So, double-click on that, and I'll collapse my Files panel and then go into Code view. So basically, what you want to do is if you are changing the database name, database username, database password, or the database host, any of those things on your live installation, you want to make those modifications here and then upload it to the live site. This process that I've described is great for moving your database to a new location. But what about just restoring it to your database? The process is pretty much the same, except for one switch.

You want to be sure to throw in the export process. So, let's go back to our phpMyAdmin. And I am going to select the Database again and then Export. Now, let's go through the Custom Options one more time because I want to show you that one difference. And that's in the Object creation options section. You want to make sure to add Drop Table. What this will do is before it imports your data, it will erase any table that is there with the same name.

This ensures that you don't duplicate your data. If you forget to check the Drop Table option, and you've already exported your data, all is not lost. All you need to do at that point is go back to your Database, Check All, and then with All Selected, Drop. And that will clear out all of the tables so that you can properly import the data. It's very important to know how to manage your data. Many web hosts include the ability to back up your data on a regular basis. I encourage you to seek out and set up those options with any live WordPress site.

Show transcript

This video is part of

Image for Dreamweaver and WordPress: Core Concepts
Dreamweaver and WordPress: Core Concepts

55 video lessons · 51316 viewers

Joseph Lowery
Author

 
Expand all | Collapse all
  1. 4m 7s
    1. Welcome
      58s
    2. Using the exercise files
      1m 54s
    3. A word about updates
      1m 15s
  2. 15m 28s
    1. Overview
      1m 51s
    2. Creating the database and the initial site
      3m 45s
    3. Configuring WordPress
      5m 54s
    4. Establishing a Dreamweaver site
      3m 58s
  3. 20m 18s
    1. Accessing dynamically related files
      4m 12s
    2. Filtering files
      4m 20s
    3. Following links
      4m 15s
    4. Employing Live Code
      2m 54s
    5. Enabling site-specific code hinting
      4m 37s
  4. 21m 8s
    1. Adding blog posts
      4m 55s
    2. Editing blog posts
      3m 20s
    3. Adding new pages
      2m 59s
    4. Including images
      6m 59s
    5. Adding videos to posts
      2m 55s
  5. 18m 12s
    1. Understanding WordPress structure
      3m 52s
    2. Activating a theme
      7m 21s
    3. Setting up a child theme
      6m 59s
  6. 1h 29m
    1. Updating the page structure and the background
      12m 53s
    2. Working with web fonts
      4m 3s
    3. Styling a header
      11m 48s
    4. Adding header functions
      7m 40s
    5. Setting up content columns
      10m 9s
    6. Changing the main content
      5m 17s
    7. Managing the content code
      4m 48s
    8. Customizing the sidebar
      10m 32s
    9. Styling search
      7m 8s
    10. Working with search text
      5m 49s
    11. Integrating the footer
      9m 40s
  7. 27m 18s
    1. Setting up media queries
      6m 12s
    2. Customizing for tablets
      12m 19s
    3. Building smartphone layouts
      8m 47s
  8. 23m 28s
    1. Working with categories and posts
      5m 31s
    2. Developing category-driven pages
      11m 22s
    3. Changing headers by category
      6m 35s
  9. 36m 32s
    1. Adding Spry accordion panels
      17m 44s
    2. Working with Spry form validation
      11m 56s
    3. Integrating jQuery functionality
      6m 52s
  10. 11m 7s
    1. Understanding WordPress plugins
      6m 20s
    2. Styling plugin output
      4m 47s
  11. 25m 44s
    1. Customizing the Dashboard
      6m 52s
    2. Working with WordPress functions
      8m 7s
    3. Including administration interactivity
      10m 45s
  12. 13m 10s
    1. Setting up the data in WordPress
      2m 17s
    2. Adding dynamic data from WordPress to your web pages
      10m 53s
  13. 11m 38s
    1. Modifying general settings
      4m 12s
    2. Setting up users
      3m 11s
    3. Restricting access to specific WordPress pages
      4m 15s
  14. 26m 38s
    1. Exporting and importing WordPress files
      7m 9s
    2. Backing up and restoring the database
      8m 10s
    3. Transferring files
      6m 3s
    4. Testing and fine-tuning
      5m 16s
  15. 18s
    1. Next steps
      18s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Dreamweaver and WordPress: Core Concepts.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.