Monday, December 19, 2011

How To Move Wordpress Website From Localhost To The Destination Server

A good guide on Posting your offline local test Wordpress site to your online web server. Thank Revolution Media for this great info. It work for me, and I think it will for you too. The original post is here

Did you ever experienced hard times trying to get your hand crafted Wordpress website transferred from your local test environment to the destination server? Did you spend countless hours trying to make things work? If you can answer yes to these questions then this article is for you. I’ll explain in plain English how to make a smooth transition from you localhost to the destination server.
Before we begin, I need to make some assumptions:
  • You have your website working perfectly on your local machine.
  • Local environment is either a PC or Mac on which you run a web server with PHP and a MySQL database and you have access to phpMyAdmin.
  • Destination server runs Apache or IIS, you have FTP details, access to phpMyAdmin, database server name, database name, database user name & password.
  • Other configurations may work as well.
  • It doesn’t matter which version of Wordpress you are using.
Also, a quick “executive summary” of all the steps below:
  1. Export your local Wordpress database to a text file.
  2. Search and replace http://localhost/yoursite with
  3. Create a database on your destination server and import your database.
  4. Copy all files from your local machine to destination server and amend wp-config.php file with new database details.
  5. If necessary change file and folders permissions so Wordpress will be able to use them.

Step 1 – Export Local Database To Text File

Open up your browser and access phpMyAdmin and select your website database from the drop down box on the left. This may look like this:
Step 1a (click to enlarge)
Go to Export section (click on the Export tab at the top). Depend on your version of the phpMyAdmin this section may look bit different but the functionality will be the same.
Click ‘Select All’ in the Export form. All tables should be selected now. Leave other options as they are. Navigate to the bottom and tick ‘Save as file’ checkbox. Click ‘Go’.
Step 1b (click to enlarge)
Step 1b (click to enlarge)
Step 1c (click to enlarge)
File save dialog will appear. Click OK and save that SQL file on your computer. Step 1 completed. Get yourself a coffee.
Step 1d (click to enlarge)
Step 1d (click to enlarge)

Step 2 – Search & Replace

Now, we have to change your database export file and find & replace all URLs that contain http://localhost/yoursite with
I’m using Dreamweaver but you can use any text editor to do the same.
Step 2a (click to enlarge)
Step 2a (click to enlarge)
We have to change another line as well. Find line C:\\Program Files\\xampp\\htdocs\\yoursite/wp-content/uploads and strip it down to /wp-content/uploads and finally save your SQL file.
Step 2b (click to enlarge)
Step 2b (click to enlarge)

Step 3 – Import Information Into Destination Server Database

On your destination server you have to create database for your WP installation. It may look like this screen below (assuming you’ll be using phpMyAdmin) However in most cases you’ll have to log onto your server administration panel and create database, user and password from there. It varies from provider to provider so please refer to your hosting provider help section.
Step 3a (click to enlarge)
Step 3a (click to enlarge)
Now as you have your database created you should populate it with your data. Click on the Import tab at the top of the page. Click on Browse in the ‘File to import’ section and select your amended SQL file. Click Go to proceed.
Step 3b (click to enlarge)
Step 3b (click to enlarge)
If everything went well you should see table names on the left hand side and a message saying something similar to this: ‘Import has been successfully finished, 162 queries executed.’ You’re done and deserve another coffee.
Step 3c (click to enlarge)
Step 3c (click to enlarge)

Step 4 – Upload Wordpress Files

In this step you should use your favourite FTP client to upload all files to your destination server. If you created a brand new website than you can upload everything including index.php file. If you upgrading an existing website then you have to make sure that it will work until you launch your WP website. DON’T DELETE ANY FILES that belongs to your existing website. Make sure your Wordpress website works first, then you’re safe to delete the old files.
To make your website work you should update wp-config.php file with your database details: database name, database server address, database user and password. Once done, you should be able to see your new website at
Now, you have to test if you can login to the administration panel. So type in to find out. If you can see WP admin login screen you’re half way there. Type in your login details and login. If you’re successfull you should see WP Dashboard.
That’s it. You’re done.

Step 5 – Fine Tuning your Wordpress website

Few other thing you should take care of:
  • Make sure that you can upload any new images or documents. If you can’t it means that you have to change files/folders permissions and give Wordpress read/write right for necessary folders.
  • Check if your permalink structure works. Amend if necessary.
  • Make sure you’re running the latest version of Wordpress and upgrade automatically to the newest one where possible.
  • Check if you have installed latest versions of any plugins that you’re using. Be careful though! Some plugins require PHP5 to work properly or require additional libraries to be enabled. Check this prior to any upgrades.

Friday, December 16, 2011

Install Microsoft (UAA) High Definition Audio class on Windows XP SP3

How to install  kb888111 in Windows XP SP3, 
If you have a sound problem after Windows XP (SP2 and SP3) installed on their laptop...
this post (Laptop Sound Problem - How to Solve it) will solve sound problem on Windows XP SP2, on step 3, you need to install kb888111, but this message will appear when you try to install it on Windows XP SP3 :

KB888111WXPSP2 Setup Error Setup has detected that the Service Pack version of this system is newer than the update you are applying. There is no need to install this update.

Follow this guide to install Microsoft (UAA) High Definition Audio class (kb888111) on Windows XP SP3 :

step 1:
Click Start > Run... > type regedit > click OK 

step 2:
then double click on CSDVersion

step 3:
Change CSDVersion value data from 300 to 200 then click OK

step 4:
You can close regedit window then please restart your laptop...
done.. now you can install KB888111 on yur Windows XP SP3

Microsoft (UAA) High Definition Audio class (KB888111) setup window on XP SP3

original post is here 

Saturday, December 10, 2011

Laptop Sound problem for Windows XP SP2

 laptop sound after install Windows XP SP2....
for everyone please try this :

step 1 :
Please uninstall any audio drivers and Microsoft UAA (kb888111) - if it's installed....

step 2:
this will open device manager
Click Start > Run... > type devmgmt.msc > press Enter
On Device Manager, please uninstall (right click > select Uninstall) a PCI device marked as unknown (e.g. with a '!' or maybe Yellow question mark)
then Restart your laptop.

step 3:
After your laptop restarted,
Windows will ask you to install automatically the drivers for Microsoft UAA Bus.
Cancel it and install this kb888111 - Universal Audio Architecture (UAA) High Definition Audio (Download for XP SP2)
Restart your laptop

step 4:
After laptop restart
windows will once more ask you to install automatically the drivers for Microsoft UAA Bus.
let windows install it automatically....
then please install the sound driver (e.g. Realtek Sound Driver)

Original Post is here

Emax Search Engine

Custom Search