Dreamweaver and WordPress: Core Concepts
Illustration by John Hersey

Exporting and importing WordPress files


From:

Dreamweaver and WordPress: Core Concepts

with Joseph Lowery

Video: Exporting and importing WordPress files

As noted earlier in the course, WordPress stores all the site's post pages and other info safely in a database so you never have to worry, right? Because nothing ever goes wrong, right? Well, in the real world, things do happen, servers crash, data gets corrupted, web host go offline. It's best to be safe and know how to take control of your WordPress data. In this chapter we'll examine two ways to do just that. One method outside of WordPress and in this lesson one method built right in.
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 your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now
please wait ...
Watch the Online Video Course Dreamweaver and WordPress: Core Concepts
5h 44m Intermediate May 27, 2010 Updated Oct 23, 2012

Viewers: in countries Watching now:

In this course, author Joseph Lowery shows how to combine the utility of WordPress and the power of Adobe Dreamweaver to transition existing websites to the WordPress platform. The course demonstrates how to create new blog posts and pages, customize WordPress themes, and extend WordPress editable pages from within Dreamweaver. It also covers how to add Spry elements, add and customize plugins, and enhance WordPress-stored content with Dreamweaver's dynamic pages. Plus, a chapter on responsive design shows how you can adapt your layouts for tablets and mobile devices.

Topics include:
  • Using the Dynamically-Related Files feature in Dreamweaver to design WordPress pages
  • Applying WordPress themes
  • Customizing themes
  • Adding Spry widgets
  • Adding WordPress dynamic data
  • Populating the WordPress database
  • Publishing a WordPress site
Subject:
Web
Software:
Dreamweaver WordPress
Author:
Joseph Lowery

Exporting and importing WordPress files

As noted earlier in the course, WordPress stores all the site's post pages and other info safely in a database so you never have to worry, right? Because nothing ever goes wrong, right? Well, in the real world, things do happen, servers crash, data gets corrupted, web host go offline. It's best to be safe and know how to take control of your WordPress data. In this chapter we'll examine two ways to do just that. One method outside of WordPress and in this lesson one method built right in.

WordPress includes tools for both exporting and importing its data. You'll find them handily stored right under the Tools menu. So let's take a look at Export first. WordPress exports its data to a text file utilizing a version of XML they call WordPress eXtended RSS, or WXR. Honestly, it doesn't matter what they call it because it just works, and the only thing it's really useful for is outputting your data so you can import it using another of their tools which we'll get into a little bit later.

As you can see, from the Export screen you have the option of exporting All of your data or just the Posts or just the Pages. Let's try it out with the Export All Content option. So I'm going to click Download Export File. Google Chrome will save it down here to the bottom. I'm going to show it in Finder, and there is a file. WordPress automatically gives a file a name that includes your site name, the word WordPress, so you know where the data came from, and the date. This is really helpful when making backups on a regular basis.

Now let's switch over to Dreamweaver and open up that file, because as you probably know Dreamweaver speaks XML quite well. So I'll go to File > Open, navigate to my Downloads and then double-click on that XML file. Up top in the Comments section, there are some instructions on how to work with this file, primarily importing it back into WordPress, which we'll cover later in this lesson. Then after that, the actual data begins. Let's scroll down a little bit, and here we can see a number of categories being defined.

You see both the term_id listed as the first item and then after that what WordPress calls the category_nicename, and what's shown in the Dashboard as the slug. A little further down, you'll start to see some sample content. Now this is the page that's included as a sample page, and once we get past that, we can see some content that we entered. Chances are you won't really need to open the file and look at anything or manipulate anything. You just use it as a source file that you can later import. Besides backing up your data, one of the primary uses that I found with WordPress' Export Import features is to move content developed locally to a live site.

So to demonstrate that, I've set up another WordPress installation on my local server here called roux2 so you can see how it's done. Let's go back to the browser, and there's a second tab here shows my roux2 site, as you can see by the path up there, and I'll click Dismiss. I've also named the site Roux Academy Live just to distinguish it from our development site. As you can see, this WordPress site is brand-new, just-installed condition. So let's bring in the data that we exported, and we'll see what happens.

So I go to Tools and choose Import. You'll find a host of import possibilities. The one we're most interested in is the last one, WordPress. So click that. Now that, that's installed, let's Activate the Plug-in and Run the Importer. So we get to choose an exported file, which as you recall we put in our Downloads folder and here it is here. So I'll select that. Click Open and then Upload file and import. After WordPress has brought in the file it reads through all the users, and as it says, sets up new passwords that are randomly generated for each one.

Now you will need to go in and modify those passwords to make sure that they're properly set up. So you have the option for importing an author and putting them on a new username or assigning them to an existing user. In this case, we're going to set it up as admin and importing another author here which I could put in as a separate username if I wanted to. I don't really want to assign it to my only other existing user. So one strategy is you might before you import set up additional users and bring in that data, if you know ahead of time that you're working with that kind of situation.

The option for downloading and importing file attachments, and let's click that and then click Submit. It reminds you to update the passwords and roles of imported users. So you would want to go over and edit Debra's and then put in her New Password or her old password, Update the User. Now let's head over to the Dashboard to see that we have our post that we've added. Now it does because it's a new installation that we're bringing data in.

You're going to find all of that placeholder content still there. It won't remove data that's already there, such as the Hello world, or if we go to Pages, the Sample Pages, and because I didn't remove sample page before installation you'll see it twice. So it's one that came in with the original installation and one that was still in my data that I imported. So let's take a look at the site. Now don't be shocked. But when you first choose it you may very well be, because the first time I saw what was happening I thought, oh no, I've lost all of that work. Well, you haven't.

WordPress just uses the default theme. It brings in just the content, the posts, and the pages. It does not bring in your theme. So you've the option for zipping up your theme folders--both parent and child in our case-- and installing them or just transferring the files. I'm going to use Finder to copy custom and roux theme folders. So here are my two sites. I'm going to extend roux_academy and then go down into blog, and open up content, open up themes.

Here is custom and here's roux. I'm going to copy both of those and then close that down. Now this particular site that I have here doesn't use a separate blog folder or anything. So wp-content is going to be in the site root. I'll expand, and then just let me double- click on themes to dive into that exclusively and then I'll paste in my two folders. Let's head back to the Dashboard, and now I can go to Appearance > Themes, and you'll see my available themes listed here.

Let's Activate Roux and then head on over to our site one more time, and now our blog site is back in all of its glory. There is definitely some clean-up you'll need to do. Be sure to budget that time in. I checked all the various sections of WordPress, Posts, Pages, Categories, Tags, and removed any unwanted elements. While it's not the most robust solution, WordPress' Import and Export feature definitely fits the need. In the next lesson I'll show you an alternative approach.

Find answers to the most frequently asked questions about Dreamweaver and WordPress: Core Concepts .


Expand all | Collapse all
please wait ...
Q: While trying to set up a Dreamweaver site, an error occurs that says Dreamweaver cannot resolve the dynamic files because the site definition is incorrect. What is causing this? This is using WAMP on a Windows 7 computer.
A: When setting up the site in Dreamweaver and creating a local testing server, make sure to point it to the folder in c:/wamp/www/ that is being used for the site. If using the same naming convention as shown in the videos, the server folder should be pointing to C:\wamp\www\explore_ca\ and the Web URL field should read http://localhost/explore_ca/, like the picture here:

Q: How do I set the password for WAMP Server 2?
A: The WAMP server does not include a password for MySQL when first installed. You’ll need to add a password by modifying a configuration text file and set up a password in the MySQL server.
Setting a password on the MySQL server:

  1. From the Start menu, enter CMD to open the command line interface.
  2. Switch to the bin directory of your MySQL folder, installed by WAMP. For version 5.1.36 of MySQL, for example, enter cd c:\wamp\bin\mysql\mysql5.1.36\bin
    Navigate within the WAMP folder installed on your system to find the proper path.
  3.  Enter the following: mysql -u root
  4. The command line for MySQL will open with a mysql prompt like this: mysql>
  5. Enter the following:
    SET PASSWORD for 'root'@'localhost' = PASSWORD('yourPassword');
    - replace 'yourPassword' with the password you want to use. 
  6. Close the CMD window.
Setting the password in the phpMyAdmin config file:
After you change the MySQL password you will have to edit the config.inc.php file. Here's how:
  1. In Windows Explorer, navigate to C:\wamp\apps\phpmyadmin3.2.0.1 (version number may vary). 
  2. Open the file config.inc.php in Dreamweaver or another text editor.
  3. Locate the following line:
    $cfg['Servers'][$i]['password'] = '';
  4. Enter your password between the quotes; make sure the password is the same as the one you set in the MySQL server.
  5. Save the file.
  6. From the system tray icon for WAMP, choose Restart All Services.
  7. To test, choose phpMyAdmin from the WAMP system tray icon.

Q: After creating a template following the instructions in the Chapter 5 video “Creating a page template in Dreamweaver,” I am unable to select the template. In the video, the instructor’s page shows a heading of Template, with a dropdown menu, but my version shows only a dropdown labeled “Attributes,” and the newly created template does not appear. What is causing this issue?
A: This seems to be a bug in WordPress that occurs occasionally. Although a cause has yet to be determined, a possible workaround to get the Template option to appear is switch themes. Switching to the default theme and then back again to Explore_California should reveal the Template option.
Q: While following along with the instructions in the "Setting up a MySQL password for Windows," I encountered this error: MySQL said: "#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)" What is causing this error?
A: This error occurs when trying to enter the MySQL monitor with a password for a user who has not set a password yet. In that case, removing the “-u root” part should resolve the problem.
Q: While following along to the chapter 2 movie "Using dynamically related files," I get an error message that reads: "Dynamically-related files could not be resolved because the site definition is not correct for this server." What is causing this error?
A: This is a known issue with Dreamweaver, and relates to the permalink settings in the WordPress installation. If the permalink setting is set to something other than the default, like “Month & Name,” for example, Dreamweaver is unable to resolve the dynamic files, and the described error will occur. Changing the permalink setting back to Default will clear the error.
Q: I am bit confused as to my need to use MAMP with a WordPress site in Dreamweaver. If I am going to use a separate commercial hosting site as my server, do I still need to use MAMP in my WordPress site?
A: MAMP is installed to provide an easy-to-use development server capable of handling MySQL and PHP on your local computer. It's also possible to set up MySQL and PHP servers separately, but it requires many more steps and is not as "user-friendly" as the described process. Your hosting server will have MySQL/PHP enabled on their servers for the remote live setup, but that doesn't have anything to do with developing and testing pages on your own computer.
Q: I can't find the file named commevents.php in the exercise files. I need it to set up an online database in the last chapter.
A: This is a file you create yourself when you first connect to a database. Refer to the "Adding WordPress dynamic data to pages" video in Chapter 7. commevents.php should appear in the Connections folder once you establish a connection.
Q:  In "Setting up a MySQL password for Windows", I'm getting the error "#1045 - Access denied for user 'root'@'localhost'" when testing the phpMyAdmin.

If I try and re-do the steps, I get the following error "ERROR 1044 (42000): Access denied for user ''@'localhost' to database mysql'" when I try to change the password.
A: This seems to be happening because of the combination of Windows 7 and a
new version of WampServer 2.1. Here's another approach that should work
for the new combination.

Follow these steps instead of the ones using the CMD prompt. (As a bonus, they're much easier!)
  1. Left-click on the WampServer icon tray.
  2. Choose phpMyAdmin.
  3. When the phpMyAdmin page opens in your browser, click the Privileges tab found after the Engines tab.
  4. Locate the line in the User table with "root - localhost - No..." (probably the last one).
  5. Click the Edit icon (the final item in the row).
  6. Scroll down to the Change Password section.
  7. Select Password and enter your password twice. (If you're following the exercises, enter root).
  8. Click Go in the lower-right corner.
Now follow the rest of the steps in "Setting up a MySQL password for Windows" video, starting at the 4:13 mark. This is where you use a text editor to make a change in the config.inc PHP file and restart all WampServer services when you're done.
Q:  I want to setup the practice files and site on my localhost, as described; however, I already have my current WordPress site (under development) running on my localhost. How do I run two WordPress sites on my localhost?
A:  You can easily do it by setting up another site in Dreamweaver. Just copy the WordPress files to that folder as described and establish a new database via phpMyAdmin. You can set up as many WordPress sites as you need to. The author has upwards of 80 on his system, all for different clients.
Q: This course was updated on 10/23/2012. What changed?
A: The course was thoroughly revised and uses the most current versions of both programs. We added chapters on responsive design and creating a custom administration panel in WordPress, new movies about concepts and taxonomies, and extended the Spry chapter to include jQuery, among other changes. New movies are indicated by the NEW tag next to the movie name.
 
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

* Estimated file size

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 ?

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 preferences from 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.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your lynda.com subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

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.