Using the Import/Export Tools in WordPress

Lately, I’ve been working with clients to move their website from to With this request, I use the Import/Export tools to move the content from one site to the other. This tool bundles the content on the site into a .zip file which you can then move to another location. Disclaimer: It isn’t perfect, you only get the content of the site, so things like posts, pages, and settings on the site. The plugins, themes, and media arent’ included, so, if your site has a lot of media, or has a ton of plugins, this tool might not work for you. (I’m writing another post about a plugin that will move everything on the site for you so stay tuned).

As I’m writing to the clients with instructions on how to set up their site using these tools, I started looking for a tutorial that would walk them through the process. And can you believe it, there are no tutorials that show the process from start to finish? So I wanted to take the time to write the process down. This article will showcase the import/export tools within WordPress (.com and .org) the process is essentially the same for both, they just look a little different.

But wait, there are two versions of WordPress? Yes, there are, but they are run in different ways.  WordPress, in a nutshell, is an open-source content management software (if you want to look at a more in-depth explanation you can read about it here).  Automattic Inc. helps develop and maintain this software. We offer this software at Reclaim and users can install an instance on their domain, in fact, you’re reading this post on a WordPress installation. is Automattic Inc.’s hosting company that runs the WordPress software explicitly. They offer free accounts with subdomains like for free or users can purchase a domain. Then users can opt-in to pay a monthly fee to get full use of the software, like you would if you installed WordPress on your domain through your hosting company.


The first thing you’ll want to do is export all of the content. Also, take note of the plugins and theme the site is using (this will save time on the other side).

  1. Log in to and click ‘My Sites’. In the menu on the left find ‘Tools’ and click ‘Export’.
  2. From here you can choose the amount of content you’d like to export, or you can export the entire content on the website. When you’ve decided what to export, click ‘Export All’:
  3. WordPress begins to package the content together. When it finishes, a banner should appear at the top of the screen. Click ‘Download’:


  1. Navigate to the ‘Tools’ section (steps 1 of the Export section). Click ‘Import.’
  2. Click ‘WordPress’ when selecting where to import your content from.
  3. Upload the exported content file you downloaded (you may have to unzip the file first). Once the file is uploaded, click ‘Continue’ to start the import.


  1. You’ll be asked to import the authors of the site, but if you’re the only user on the site click ‘Start Import.’
  2. You should see a progress bar like this:

From here you don’t have to stay in the window to keep it going, will send you a notification when the import finishes. Once the import completes, the content on the site is ready to go! (Software version)


This process is similar to but I thought it’d be worth going through separately.

  1. Within the dashboard of your site, Navigate to ‘Tools’ and click ‘Export.’image
  2. From there, you’ll choose what content you’d like to export. Also, take note of the themes and plugins you use. When you’re ready to export click ‘Download Export File.’

Easy as that!


    1. Within the dashboard of your site, Navigate to ‘Tools’ and click ‘Import.’image
    2. You’ll need to install the WordPress Importer plugin. Click ‘Install Now.’ Once the install completes, click ‘Activate or ‘Run Importer.’ 
    3. Click ‘Choose File’ or ‘Browse’ to select the export file you’d like to import. Then click ‘Upload file and import.’


    4. When the import is complete, you should see something along the lines of “All done. Have fun!” at the bottom of the screen.

Repairing a Crashed Table in phpMyAdmin

Yesterday, a ticket came in where a student’s website was not establishing a database connection. I started my usual checks to see what kind of installation she had on her domain. In this case it was a WordPress installation. I went to double check that the username and password in the wp-config.php file was the same as the wp-options table in phpMyAdmin. After trying to open the wp-options I received an error similar to this:

mysql> select * from nagios_servicechecks;

ERROR 1194 (HY000): Table ‘nagios_servicechecks’ is marked as crashed and should be repaired

This error can say a wide range of things, but this fix works when it says that the table should be repaired.

**Note, this error was not what I was working on it’s definitely similar though. I didn’t grab a screenshot of it before fixing the error**

To fix this first click the checkbox next to the table you’d like to repair. Then click the ‘With Selected’ dropdown box. 

Once that’s done, click ‘Go’ on the bottom right of the screen. 

Once complete you’ll see this.

Double check that the site loads now. If you’re still getting the “Error Establishing Database Connection” try refreshing your browser cache or load the site from your phone with the Wi-Fi turned off.