How to create a copy of wordpress site into xampp running on your local PC

Having your wordpress site in your local PC will serve as a backup for the site. It also enable you to test new features in it before implemented in the production site.

Following are some steps for performing this task.

1. Using phpMyAdmin, export the database of your site. Replace the URL of original site to new URL in the exported SQL file.

2. Copy the whole wordpress directory of your site to local directory. Normally it is at:
c:\xampp\htdocs\wordpress

3. In your local server, create a new database to be used by the site. If possible, use the same database name as in your production server. You may like to refer to wp-config.php for information of the user ID & password. Configure uers access to the database using "Privileges" function of phpMyAdmin.

4. Restore the database to your local server by using the Import feature of phpMyAdmin.

5. Configure the wp-config.php file

//unless you have changed the setting, else the default will be as follow
define('DB_NAME', 'wordpress'); //change this to the name of the database you have created earlier
define('DB_USER', 'root');
define('DB_PASSWORD', ''); //no password by default. Change this if you have added password during installation
define('DB_HOST', 'localhost'); //99% you won't have to change this

6. To make the permalink work properly, you will need to regenerate the permalink structure in the Permalink setting page in wordpress. Click "Permalinks" under "Settings" in the wordpress configuration page. Next click on "Save Changes" will do!

Good luck!