, , , , , ,

Using the Import/Export Tools in WordPress

Lately, I’ve been working with clients to move their website from WordPress.com to WordPress.org. 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.

WordPress.com is Automattic Inc.’s hosting company that runs the WordPress software explicitly. They offer free accounts with subdomains like meredithfierro.wordpress.com 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.  Click ‘Settings’ under ‘Configure’ 
  2. Click ‘Export,’ under the ‘Site Tools’ section:
  3. 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’: 
  4. WordPress begins to package the content together. When it finishes, a banner should appear at the top of the screen. Click ‘Download’: 

Read more

, , ,

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.