Import Blogger Posts into WordPress Using Windows XP XAMPP

This tutorial covers transferring Blogger posts to a WordPress local host powered by XAMPP. XAMPP is a local Apache server for Windows XP, which enables you to run a PHP-MySQL-powered website right on your Windows XP Home computer.

However, how to set up and configure XAMPP to run in Windows XP is beyond the scope of this tutorial. I highly recommend reading this very useful tutorial if you run the Windows XP Home operating system on your computer. 

One of the most frequent reasons for importing Blogger post to WordPress localhost is to switch from Blogger to WordPress publishing software. In order to work successfully, a localhost WordPress needs to be created and completed before it can be uploaded to your selected web hosting company.

Necessary Prerequisites

In order to maximize what you can learning from this tutorial, it is highly recommended that you meet the following requisites:

  • Enough Blogger posts to transfer (of course, I assume you have enough already). If you have less that five posts to transfer to WordPress, then doing it manually (in a copy-and-paste procedure) will be more efficient than following the methods in this tutorial. 

  • A personal Google account. It is safer that those blogs you are working is under your own personal Google account, if not then you need to obtain some permissions from the real account owner before you can do this.

  • A working XAMPP installation in Windows XP Home. Follow the installation tips given on the above link. 

  • Your selected and final WordPress theme to use. Find suitable themes first. This will ensure that you can immediately see the imported posts the way you wanted people to see them. You can easily select your favorite  WordPress themes. Of course, before you install any themes, you need to install WordPress in the localhost, which will be the first step.

{mospagebreak title=Install WordPress in XAMPP}

You need to download the latest version of WordPress. Always install the latest version for security reasons. After downloading to your desktop, unzip the folder. Once the folder has been completely unzipped, you will find another folder inside it. Rename it to your blog name.

In the example below, I have renamed the folder to “webdevelopmentexperts.” This is correct if the blog hosted by Blogger is webdevelopmentexperts.blogspot.com. You can change it to reflect your own blog name. See the screen shot below for some clarification:

Assuming you have successfully installed XAMPP in your computer, copy the folder “webdevelopmentexperts” to XAMPP htdocs. If you have installed XAMPP in drive C root, the correct installation path for your blog should be: C:xampphtdocswebdevelopmentexperts

After that, you need to create a database for WordPress installation. You need to go to phpmyadmin by typing the following into the browser: http://localhost/phpmyadmin. Under “Create new database” type your blog name; in our example it is “webdevelopmentexperts.” This will create a new database where all of your post will be stored using the name of your blog as the database name.

Do not yet fill up the tables if phpmyadmin asks you, WordPress will fill them automatically during installation. You need to log out of phpmyadmin after creating the database.

{mospagebreak title=Configuring the Files}

Now open the file: wp-config-sample, which can be found in WordPress files under “webdevelopmentexperts” (in my example). Find the following lines:

// ** MySQL settings – You can get this info from your web host ** //

/** The name of the database for WordPress */

define(‘DB_NAME’, ‘putyourdbnamehere’);

/** MySQL database username */

define(‘DB_USER’, ‘usernamehere’);

/** MySQL database password */

define(‘DB_PASSWORD’, ‘yourpasswordhere’);

/** MySQL hostname */

define(‘DB_HOST’, ‘localhost’);

You can now declare the database name you have created in the previous steps along with your PHPmyadmin access. Suppose I have the following information:

Database name: webdevelopmentexperts

Database username: codexm

Database password: district9

Database hostname: localhost

If you are using XAMPP, the database hostname should always be ”localhost.” The revised lines of the WordPress configuration file are these:

// ** MySQL settings – You can get this info from your web host ** //

/** The name of the database for WordPress */

define(‘DB_NAME’, ‘webdevelopmentexperts’);

/** MySQL database username */

define(‘DB_USER’, ‘codexm’);

/** MySQL database password */

define(‘DB_PASSWORD’, ‘district9′);

/** MySQL hostname */

define(‘DB_HOST’, ‘localhost’);

Save the file as “wp-config.php” in the same location as wp-config-sample.php. Now, since my blog is: webdevelopmentexperts, type this in the browser to complete the installation: http://localhost/webdevelopmentexperts/wp-admin/install.php and follow the rest of those procedures provided by WordPress. Take note of the username/password, and keep it in a safe location. Do not yet log in to WordPress at this stage.

To see if you have successfully installed WordPress, type your blog localhost address; in my example it is: http://localhost/webdevelopmentexperts . You should not see any error.

{mospagebreak title=Log in to the WordPress admin panel}

Using the username and passwords provided, log in to your blog admin panel. In my case it will be: http://localhost/webdevelopmentexperts/wp-admin

Log in to your Google Blogger Account

You need to log in also to Google Blogger: http://www.blogger.com

In the Dashboard, go to Tools -> Import

WordPress currently supports a lot of blog publishing software, as you will see from the list. On the list, just click “Blogger.” WordPress will then take you to a page; once there, click “Authorize.”

After clicking “authorize.” you will be transferred to a Google page. Once there, click “Grant Access.” The WordPress Importing Magic Button will then be displayed

You can see it on the right. Select the blog you would like to be imported, click the “Import” button, and then click the ”Continue” button to complete the transfer.

Sometimes, in rare situations, you may encounter errors during the importing process, such as: “Unable to find the socket transport ‘ssl’ – did you forget to enable it when you configured PHP? (429496729)”

This means there is a problem with the SSL installation of XAMPP that needs to be fixed before those Blogger posts can be imported. To fix this problem, read this tutorial

Basically, you will need to complete the following four steps:

1. Stop the Apache service. You can stop the Apache service by going into Control Panel -> Administrative Tools -> Services, finding Apache in that list – for example, “Apache 2.2″ — double clicking on it and then clicking stop.

2. Copy libeay32.dll and ssleay32.dll from the XAMPP PHP folder (which is located in: C:xamppphp if you install XAMPP in drive C) to the XAMPP Apache Bin folder located in: C:xamppapachebin

Overwrite the files in the bin folder with the file from the PHP folder.

Note: Do not forget to back up files first.

3. Find php.ini file under C:xamppapachebin and open it with your favorite PHP editor. Remove the semicolon (comment) at the start of this line: extension=php_openssl.dll

This will uncomment that option. See the screen shot below for the correct removal of semicolon:

4. Restart the Apache service: Control Panel -> Administrative Tools -> Services

To confirm whether SSL transport has been activated correctly, go to:

http://localhost/xampp

Then you should see Registered Stream Socket Transports: tcp, udp, ssl, sslv3, sslv2, tls.

[gp-comments width="770" linklove="off" ]