Install Wordpress offline on Your PC using Xampp

by Abhishek Jain on December 6, 2009

in Wordpress

Every Self-hosted Wordpress user wonders “If there was a way via which Wordpress could be installed offline and all the themes could be tested and corrected as per the requirements offline?”

Yes! of course there are hundreds of ways to do this, but most of them are time-consuming and aren’t user friendly and it takes the users nerve to set up Wordpress offline.

There’s a post previously written on Shoutmeloud by Harsh, giving instructions to install Wordpress offline using Wamp server, but after using Wamp, I felt it’s not as much user friendly as Xampp-Lite! So thought of helping you all out with the Xampp installation!

Here’s a quick 5 minute (8 steps) procedure to Install Wordpress Offline.

In order to run Wordpress offline, you need an Apache server and My Sql database(PhpMyAdmin) installed on your system.

1) Download Xampp Lite from the official website Apachefriends.org

2) Install Xampp Lite with Apache and MySql services.

Install Xampp

3) After the installation, run Xampp Control panel and start Apache and MySql services as indicated in the image below.

Xampp Control Panel

4) We need to configure MySql Databases, Open your web browser and go to http:://localhost.

Select the language of your choice and then go to http://localhost/security/index.php & there change MySql database password.

In this tutorial I have given the password as test. (Password is case-sensitive)Localhost

5) Now we have to create  MySql Database tables for your Wordpress install.

To do this Go to http://localhost/phpmyadmin, Login using  root as username and test as password, or the password which you gave in the previous step.

Create a new database through the PhpMyAdmin interface. Give a name for your database and don’t change any other setting (refer the Image below).

PhpMyAdmin6) Now, download the latest version of Wordpress from www.wordpress.org

After the download, go to the folder where you installed Xampp, there you will find a folder by name htdocs, open it and extract the latest version of Wordpress there.

htdocs Folder

7) Open the Wordpress folder (the one which you extracted in the above step), you will find a file by name wp-config-sample.php, open the file with wordpad and edit the data as per the image.

Wp-Config.phpSave the file and rename it as wp-config.php.

8)Now go to http://localhost/wordpress and install wordpress!!

Offline WordpressIf you find any errors in installing or have any queries please post them as comments.

This is a guest post by Abhishek, who writes on his personal blog at rnsitian. If you want to write for Shoutmeloud See : Shoutmeloud Revenue sharing program

Related posts:

  1. How To Install wordpress Locally Using WAMP
  2. How To Change Wordpress Default Username For Security
  3. How to Install Buddypress in Wordpress MU
  4. Wordpress Problem : You cannot install more than 1 script in root
  5. Step by step guide to Install self hosted wordpress blog
  6. How to install more than one Wordpress plugins in single click
  7. How to Install Wordpress on Hostgator
  8. How to install wordpress plugin from your blog dashboard


{ 1 trackback }

You are now listed on FAQPAL
December 6, 2009 at 21:12

{ 15 comments… read them below or add one }

1 Sunil December 6, 2009 at 15:52

Really needed that..Wil give it a try today and ask u if anything goes wrong..Thanks..

Sunil

Reply

2 Sudheer December 6, 2009 at 16:04

Nice post…Easily understandable..

Reply

3 chandan December 6, 2009 at 19:41

Really very nice tutorial, thank you bro.

Reply

4 arun kamath December 6, 2009 at 22:00

From this post I learnt how database actually works… Three years of Graduation couldn’t do that for me.

Reply

5 Siddanth December 7, 2009 at 07:51

This is how i used to do before but if u have issues with iis like iis core is not installed properly this method will work til xampp install then it wont open in browser..

Reply

6 Abhishek December 7, 2009 at 09:40

@arun kamath
thanks a lot! I never though my post would help you out to learn which even graduation doesn’t teaches! Ha ha ha :-)

Reply

7 Pubudu Kodikara December 7, 2009 at 18:45

This is very useful when you want to test new additions to your site! Can test without a risk :D Thanks for the article mate!

Reply

8 max December 7, 2009 at 19:59

looks good.. but i use wamp..

Reply

9 Nihar December 10, 2009 at 00:57

Great tutorial.

I will follow it and install the wordpress on desktop

Reply

10 Mandar Salvi December 19, 2009 at 11:11

Hey Harsh,

I am getting this error while importing my database.

Fatal error: Maximum execution time of 300 seconds exceeded in C:\Program Files\XAMPP\xampplite\phpMyAdmin\libraries\import\sql.php on line 131

What to do? :P

Reply

11 Mandar Salvi December 19, 2009 at 11:39

I have fixed it. Thank you :) Anyways delete my comments if you want.

Reply

12 Harsh Agrawal December 19, 2009 at 15:07

Mandar why dont you mention the steps which you have taken to rectify the problem. This will help other users.

Reply

13 Mandar Salvi December 19, 2009 at 16:28

You are getting this error due to PHPMyAdmin time limit. To increase time limit follow these simple tips:

1) Take a look in .\xampp\phpMyAdmin for config-inc.php file.
2) Look for this line and adjust as required:

$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)

Or

If your config-inc.php file is small and missing the above line or missing altogether then the file config.default.php in the .\xampp\phpMyAdmin\libraries folder is used.

1) The line in config-default.php may look similar to this:

/**
* maximum execution time in seconds (0 for no limit)
*
* @global integer $cfg['ExecTimeLimit']
*/
$cfg['ExecTimeLimit'] = 300;

All you have to do is to remove ‘300′ and use ‘0′ for no limit. :) [Credits]

Reply

14 peter January 8, 2010 at 21:36

I Downloaded the Wordpress 2.9 from their org website. And installed it using XAMPP. But during installation it came up with warnings and other messages –

Deprecated: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\wp27\wp-settings.php on line 512
The above comes up when I open the front end.

If I try logging in then -
Deprecated: Assigning the return value of new by reference is deprecated in C:\xampp\htdocs\wp27\wp-includes\theme.php on line 1109

Warning: Cannot modify header information – headers already sent by (output started at C:\xampp\htdocs\wp27\wp-settings.php:512) in C:\xampp\htdocs\wp27\wp-login.php on line 255

Any recommendations would be appreciated.

Reply

15 Mayur March 9, 2010 at 14:35

This guide works perfect :)

Reply

Leave a Comment

Previous post:

Next post: