post-page

Install WordPress Locally – Part 2 Of 2

81
responses
by
 
on
January 3rd, 2008
in
HOW-TO, WordPress FAQs
heading
heading
heading
81
Responses

 

Comments

  1. Jon says:

    I know this series will help others, but I’ve been working this way — with WAMPserver even — for awhile. Where I’ve been stymied is on the next step — setting up a virtual host. A virtual host setup is a necessity where the intent is to use WordPress as a CMS and site testing must therefore encompass multiple accounts running on multiple computers. Any chance of a Part 3 covering this topic??

    P.S. Checking the WAMPserver forum I may have just found the solution to my own problem.

    http://www.wampserver.com/phorum/read.php?2,28722

    I’ll follow up after I try it out.

  2. aca463 (3 comments.) says:

    Thank you ver much by post.

  3. Jon says:

    Thanks. Could you cover setting up a virtual host in another post?

  4. Chris (4 comments.) says:

    I created a tutorial about hosting a public website on a personal PC.

  5. larry says:

    Ah… Thanks for part two of this tute..
    I’m still looking into the attempted dialing of my browser whenever I open a page in localhost.

  6. Max (2 comments.) says:

    Thanks!

  7. Jeffro2pt0 (164 comments.) says:

    @Larry You want to look towards the bottom near the screenshot of the SITE URL table within the database. You will need to change the value of SITE URL from it’s current state to http://localhost if you don’t, WP thinks the WordPress install is on the public domain instead of local host.

  8. larry says:

    Yeah I will try that, thanks. My problem is that it trys to dial out anytime I open http://localhost/, then after that I have to cancel the dial everytime I view another page.

  9. Wayne (2 comments.) says:

    I setup my site first, installed WP then exported/imported my posts, then ftp’d my wp-content directory to make sure I have all my plugins and themes.

    What’s the difference between importing the entire SQL database and exporting and importing your posts?

  10. Jeffro2pt0 (164 comments.) says:

    @Wayne The difference between the two is that, importing of the posts is exactly that. You import the posts and nothing else. Where as with the entire SQL database being imported, everything from your options to plugin data is imported.

  11. ayusli (4 comments.) says:

    I’ve installed wampserver and did the changes as instructed. When I tried to access phpmyadmin, I got an error message. I can’t even access localhost. Is there any setting that’s being overlooked? I’m using WinXP Pro SP2.

  12. Carson (46 comments.) says:

    @ayusli: Have you stopped the IIS Admin service? If not WampServer won’t run properly.

  13. Michael (1 comments.) says:

    Thanks for this.

  14. kotoman (1 comments.) says:

    My host doesn’t have a cpanel or a backup function. I’ve tried backing up the database using the phpadmin and the database backup plugin in wordpress but I’m out of my depth regarding how to do this. Also can you explain in further detail the import….

    thanks for the help so far, but I feel a few of us newbies may need a little more hand holding

    many thanks

    Paul http://www.renovationcentral.co.uk

  15. ayusli (4 comments.) says:

    @carson: I have stopped the IIS and can now access localhost. Thank you very very much for the advice.

    @Jeffro2pt0: I think stopping the IIS should be included in the list of things that need to be stopped before running wampserver.

  16. Jeffro2pt0 (164 comments.) says:

    @ausli Thanks for the tip. I’ve added that addition to part 1 of the guide.

    @kotoman I may write up another guide, just for those who don’t have the luxury of accessing Cpanel or Plesk. It is possible though to manually migrate WordPress over to a local install albeit more complicated and timely.

  17. ayusli (4 comments.) says:

    I have successfully done all the steps in part 1 and part 2. I can also view my blog locally as is on public domain. The only problem is.. I can only view the main screen. When I clicked a link to view a single post, or the archive, or a category or any link for that matter, I got an error message page cannot be found. Where have I done wrong?

  18. Austin Matzko (1 comments.) says:

    Actually, it’s no longer necessary to edit the siteurl and home values in the database. Instead, you can set them as constants in the wp-config file, something I do all the time for local versions of WP setups.

    define('WP_HOME', 'localhost' );
    define('WP_SITEURL', 'localhost');

  19. Jeffro2pt0 (164 comments.) says:

    You’re right Austin. Ronald sent me that tip the other day and I forgot to add it into the article. I’ve just added that step before the database editing. Thanks.

  20. dawn (1 comments.) says:

    This was a great tutorial, worked well for me.

    Just one question, I use a modified Hemingway theme on my blog, which doesn’t work locally, in fact, none of the Hemingway based themes worked locally for me, other themes do. Hemingway one’s all say there’s an error on line 647 of functions.php, this line does not exist. Anyone have any ideas?

  21. Richard D. LeCour (4 comments.) says:

    Oddly enough, I struggled through trying to get my WordPress running locally on WampServer just before Christmas vacation. Frustrated for some time, I eventually came up with a very simple solution: adding “127.0.0.1 wordpress.dev” to my Windows HOSTS file. Now I develop and test using http://wordpress.dev/.

  22. Mike (6 comments.) says:

    Oh boy! I spent quite a while setting everything up last night. I should have just read this comprehensive review instead. :)

    I didn’t have WampServer installed, so I had to muck around with the various components.

    IIS was a real pain which required a bit of googling and guessing to get it working properly.

    Eventually it’s all up and running locally which makes editing the site (theming, coding, etc) a real breeze! You’re right, it’s heaps better to develop locally then upload to the live site.

    It also makes more sense so users won’t see an ugly work in progress. :)

  23. Lorelle (10 comments.) says:

    The installation of WAMPS went smoothly. I put WordPress into the WWW directory under the WAMPS installation, created the database, changed the wp-config per your recommendations, ran the install, and it works, but on page 2 of the install, I get no username nor password – no access to the WordPress Administration Panels. No way of logging in. Page 2 only shows the WordPress logo and the rest is blank. Reloading the screen, per default, gives the warning that it’s already installed. I’ve dropped the tables and tried this 5 times from scratch, and still, no password access. I’m going to go in manually and change the password – there has to be an easier way. Hints?

  24. Nick says:

    Thanks for the tutorial. I was not able to fully import yet. Nice to see the comments, as they help. I’d like to add that I’m using XAMMP and has to change this..
    define(‘WP_HOME’, ‘localhost’ );
    define(‘WP_SITEURL’, ‘localhost’);

    to

    define(‘WP_HOME’, ‘http://localhost/wordpress’ );
    define(‘WP_SITEURL’, ‘http://localhost/wordpress’);

    if not i got an error.
    my XAMPP is @ localhost. for some reason the http:// has to be included. hope this helps someone that may be in the same pickle.
    i guess now i need to read about databases!
    thanks again!

  25. Nick says:

    almost got it to work. your tutorial helped so much. i had to do something different though. i’ll share in case it helps and hopefully i can get a hand for the last step.
    -running XAMPP to enable Apache and mySQL on the PC
    -i downloaded mySQL database to my machine, via PHPmyAdmin on my wehbost.
    -so now i had a fresh local install with the database ‘wordpress’.
    -i created a new database called test-import. then clicked import within the same PHPmyAdmin panel and imported the database that was downloaded from the online blog.
    -changed this in wp-config: define(‘DB_NAME’, ‘test-import’); // The name of the database
    -installed all the plugins since you mentioned that is included in the databases.
    -now my blank/fresh install on my machine shows my first page with the 2 posts. but clicking on either post or page takes me to 404 – object not found page.
    updated permalinks in case that was it.
    any ideas? i’m sooo close! :)

  26. Jeffro2pt0 (164 comments.) says:

    @Lorelle Not sure Lorelle. I will go through the installation steps again on my local machine to see if I can reproduce this issue.

    @Nick Have you tried placing a blank or new .htaccess file in your file structure? Usually, using the one that came from your public install of WordPress causes weird issues on a local install.

  27. John Kolbert (23 comments.) says:

    Just a quick question, should I be able to see a posts page? Everything works, but when I click on the permalink for an article, it says it can’t be found. I’m just wondering if this is how it is supposed to be, or if I’ve messed something up.

  28. John Kolbert (23 comments.) says:

    Never mind, I fixed it. I turned my permalink structure back into the default method (?p=blah), and then the PHP functions took over.

  29. Chad (2 comments.) says:

    Thanks for the this tutorial. It was so easy, even a card carrying Neanderthal like me was able to follow it. Now on to my question.

    After following your instructions on a fresh install of wordpress, I pointed my browser to the url included in the post but was met with an “error 404 Not Found” message.

    Can you help?

    Thanks,
    C

  30. Chad (2 comments.) says:

    Nevermind. I looked under “local host” in WAMPserver and then clicked “wordpress” under “Your Projects.” That took care of the install. I should’ve guessed that the url would not work when typed directly into my browser. I suppose it was looking for that url on the web as opposed to locally. Yes? Okay, well thanks again for a great resource! I’m looking forward to using this powerful tool for developing all my WP sites.
    C

  31. Jeffro2pt0 (164 comments.) says:

    @chad Glad everything worked out for you Chad.

  32. ayusli (4 comments.) says:

    I got my local blog working now, all thanks to John Kolbert.

  33. Mike - Twenty Steps (1 comments.) says:

    First off thank you so much for writing this tutorial. I’d been planning on doing this for ages but put it off because it seemed so complicated. With your tutorial I managed to get a local install set up in 10 minutes.

    One thing that I initially couldn’t work out was how to create an .htaccess file. Changing permalink structures and some WP plugins require you to make changes to your .htaccess file but the default WampServer install didn’t include one within the www directory.

    If anyone else has this problem all you need to do is left click on your WampServer icon, select Apache—Apache Modules and then click on rewrite_module. This will then create an .htaccess file in your www directory.

  34. Linda Carter (1 comments.) says:

    I almost had this licked. I was able to get my index page to come up locally, but it couldn’t find the stylesheet or the posts. I referred to this:

    “At this point, the folder structure within the WWW folder on your hard drive should mimic that of what you would see within the Public_HTML folder on your webhost.”

    I then rearranged all the files so that the www contents mimiced the root of my server. (I am not able to access public_html. The ftp info provided takes me straight to the root of the site.)

    Now I can’t get wamp to come up at all. It just loads and loads forever. I fear I deleted/stored over some of the wamp files. Should the index.php file in the root of www be a wamp file, or a wordpress file?

    I’m tempated to delete everything and start over, but I’m worried the wamp won’t uninstall fully and I’ll have more issues to contend with.

    Thanks

  35. Jeffro2pt0 (164 comments.) says:

    @Linda Linda, I have had to uninstall and reinstall Wamp a number of times because it’s easy to do and it’s the fastest way of starting over from scratch. I wouldn’t worry about it and would give it a try.

  36. Linda Carter says:

    I’m curious to see how things would work if I just did the fresh install of wordpress. There are only a few posts. I could bring them in manually, bring in the stylesheet and do the experiments I need to do.

  37. Monika says:

    Thank you for this tutorial. I was able to install WAMPS onto my hard drive and move all the wp folders into the www folder of WAMPS. It also guided me to input my username (which was populated with admin) and a pre-populated password. I’m not in my wordpress admin (had no trouble login in, but when I try to look at my site or a test post I just did, it shows the WAMP5 Homepage (http://localhost/?p=3)instead.

    How can I get to see my local WordPress instead?

  38. Johnathan says:

    What about enabling mod_rewrite , with a .htaccess file?

  39. Meltem says:

    I have downloaded WordPress 1.3.3 and unzip the files under root/wpmu folder. a) there is no install.php but index-install.php under the root/wpmu folder as well as under the wp-admin folder.
    b)when I run these files it gives me an error “Problem is wp-config.php – $base is set to BASE when it should be the path like “/” or “/blogs/”! please fix it!.
    c) when I made the changes (either $base = ‘/’ or ‘/blog/’ or ‘/wpmu/’) in the config file then it gives me “No WPMU site defined on this host.
    So, what now?
    PS: I have created the database using phpMyAdmin and I am not using WAMPS – Apache 2, PHP 5, and MySQL are running well. I have other apps running on the same server.

  40. brian (8 comments.) says:

    Jeff, thanks for the tutorial! wamp is *much* better than the xampp install i was using. deleted it entirely. WampServer for the win.

  41. Jeffro2pt0 (164 comments.) says:

    @Brian Thanks for the comments. Glad that Wamp is holding up for you.

  42. Chuck (1 comments.) says:

    Hi – great tutorial. Thank you. I didn’t read every comment (but I did read most of them) so hopefully this bit of info isn’t duplicated.

    1. I don’t think you mention creating the DB before doing the import. I learned the database needs to be created first.

    2. When installing WAMP make sure you get the mySQL addon for version 5.0.45. This is because the version included by default (5.0.51) has known issues with wordpress.

    Thanks again!

  43. Thomas says:

    I too am getting Monika’s problem. WAMP’s splashpage shows up whenever I try to “visit site” or view an entry. When I tried to go about fixing it, I now get to “index of /wordpress,” where /wordpress is the test directory I have sitting inside the www folder.

    Thanks for the great write-up, but this just has me frustrated. Any idea on why WordPress isn’t generating the main index?

  44. kris says:

    Works like a charm…Great explanation…wow! Hats off

  45. ArthurBTD says:

    Thank God you are here to help. I’m having similar problems as ayusli. I don’t believe my iis server is running. I don’t see it’s icon on my system tray or in the task manager, yet my browser pops up saying “#2003 – Can’t connect to MySQL server on ‘localhost’ (10061)”

    Please advise

  46. ArthurBTD says:

    NOTE: IF YOU USE A FIREWALL (like the ZoneAlarmPro I’m using), you will have to go into your firewall’s program control area and make sure “Apache HTTP server” has a check mark under “Access Internet”.

    It works for me now, but please advise if what I just did leaves my computer open to nasties.

  47. ArthurBTD says:

    Sorry for a third comment, but could you clarify something?

    “If you want to install WordPress into the ROOT directory as you would on a public web server, take all of the files and folders within the WordPress folder and move them into the WWW folder. WWW is the same as Public_HTML and is the folder which houses all of your web documents.”

    What do you mean by the “WWW” folder? Since we are working locally, couldn’t the wordpress folder we extracted to our desktop be the folder that houses all of our web documents? Or, each time we want to do a separate test (say for various clients per say), set up a separate folder for each client, copying the files over for each client? In other words, this WordPress extracted folder is acting like a central copy location that we can use over and over again without having to worry about bloat. Let me know. Thank you for your time.

  48. ArthurBTD says:

    4TH AND FINAL POST OF THE NIGHT, I swear!

    Ok so I figured out what you were saying. Under C:\wamp\ there was a www folder. I got scared to download all the files to this directory since there was already an index.php file there and one of the files that was with the wordpress extraction was also an index.php file. So, what I did was rename this pre-existing file indexoriginal.php, then copied all the files like you said into this root, typed the address for the install.php file into the browser and, voila, off and running. Many, many thanks.

  49. SA says:

    That was incredibly simple, thanks to you! Much appreciated -

  50. Peter Blake (1 comments.) says:

    Thanks for an excellent tutorial. I have stumbled at the final hurdle somehow. When I type http://localhost/wp-admin/install.php into the address bar I get NOT FOUND The requested URL /wp-admin/install.php was not found on this server.

    I have followed your instructions in part 1 and 2, and am at a loss as to why it won’t work. Wampserver works and WordPress is in a folder in
    the www folder of the wamp folder in C drive.

    Would you have any ideas why it won’t work please?

  51. ArthurBTD says:

    I’m tinkering with WordPress Locally. For some odd reason, my password is not working to log into my admin screen (i printed it out but it won’t work when I retype it). I didn’t add my email address when I installed Wamp, and I don’t know if email functionality is turned on. I try to email myself my lost password, but it won’t let me saying localhost has probably disabled mail.

    Could someone please tell me where in wamp this password is stored and how to change it so I can log in as admin and gain full access to my local blog again? Do I need to uninstall Wamp and WordPress and reinstall?

    I’m on a tight deadline here and would appreciate some comments soon.

  52. ArthurBTD says:

    Once again. Nevermind. I’ve fixed my own problem. I logged into phpmyadmin, clicked on the wordpress link on the left, clicked on the wp_users table link on the left, clicked the browse button on the top, clicked on the pencil icon next to admin, under user_pass I clicked on the drop down and chose MD5, typed a new password in the firld to the right of this, and clicked on Go on the bottom. Worked like a charm.

  53. Shane Swing (1 comments.) says:

    I created a VIDEO TUTORIAL based off of this information. Please check it out. http://www.youtube.com/watch?v=biQWyBcYSX4

  54. LeoTheMaster (1 comments.) says:

    really great tutorial, thx

  55. PIF (4 comments.) says:

    Part of a series on setting up a mac mini as a server: How to install MAMP on a mac – which comes with Apachie, also upgrading to latest versions of PHP and MYSQL. Site has lots of other video how tos.

    http://www.macminicolo.net/videos/ServerVideo9.mov

  56. Marc Alter says:

    Jeff,

    Thanks for the tutorial. I am fairly new to this stuff, but I have successfully followed your directions for migrating my WordPress from public to Localhost. I am up to the step where I am in PHPMyAdmin, clicked on Import and selected the database file that pertains to my WordPress install on my desktop. When I click on Go, the following error occurs:
    __________
    Error

    SQL query:


    — Table structure for table `wp_comments`

    DROP TABLE IF EXISTS `wp_comments` ;

    MySQL said: Documentation
    #1046 – No database selected
    __________________

    Am I supposed to be creating a new database first in PHPMyAdmin and then importing my WordPress install database into that? Any idea why I received this error?

    Thanks very much for your help.

    • Jeff Chandler (295 comments.) says:

      As Brian already answered, you have to create an empty database first and then select it so that PHPMyAdmin knows where to import the data to.

  57. Brian Meagher (2 comments.) says:

    @Marc – yes, the database has to exist in order to import.

  58. Marc Alter says:

    Thanks Brian and Jeff. One follow-up question. I completed all of the steps including changing “siteurl” and “home” to “http://localhost” for my respective database. I have never opened my .htaccess file. When I try to access and browse my blog on my local machine by entering in “http://localhost/name of folder/wp-login.php,” I get a pop-up box that says the following:
    ______________
    Title: Opening wp-login.php

    You have chosen to open
    wp-login.php
    which is a: PHP file
    from http://localhost

    What should Firefox do with this file?
    Open with Firefox (default) – drop down menu with other options
    Save File
    OK, Cancel
    ______________
    I believe this should not be happening. Even so, when I select “Open with” Firefox (default) and click on OK, a page in Firefox opens up with the address “file:///C:/Users/Marc/AppData/Local/Temp/wp-login-1.php” and the page has a lot of text and states errors all over the place. Any ideas?? Really appreciate the help. I know I’m almost there.

  59. Billy says:

    I got this error when importing the database:

    “Error

    SQL query:


    — Database: `(database name here)`

    — ——————————————————–

    — Table structure for table `wp_comments`

    DROP TABLE IF EXISTS `wp_comments` ;

    MySQL said:
    #1046 – No database selected “

  60. Tim Murray says:

    I’ve been looking to do this for a while, thanks for the walkthrough.

    I still have one problem. I customized my permalinks to category/postname and whenever I try to navigate it locally, it doesn’t work.

    If I change it back to the default ?p=111 everything is fine.

    Any ideas?

    Thanks

  61. antonio says:

    Hi, Im running WordPress locally using Wamp. I would liek to know how to get frinedly url as my page name (I don’t use WprdPress for bloggingm so I mainly work woth pages).

    I have tried to edit the permalinks bu it doesn’t work. I get always the same issue which is a 404:

    Not Found

    The requested URL /wordpress/archives/date/2009/09 was not found on this server

    Any idea what should I do in terms of domain setting in order to get these pages working?

    Thanks in advance.

  62. hyperninja (1 comments.) says:

    AWESOME POST!!!! Thank you so much for this :)

  63. Lynne says:

    I have done everything right…I think…
    but when I try to run the install I get a page that says “Error establishing a database connection”

    I am sure the config file is correct…but for some reason it can’t find the db…

    Looking for help please…

  64. Kathy Purdy (2 comments.) says:

    I am having the same problem as Lynne: error establishing a database connection. Any ideas on how to troubleshoot?

    • Kathy Purdy (2 comments.) says:

      I imported my database from my live site, and tried to use the original user and password in the wp-config file, after setting up a new user with phpmyadmin. That gave me the database connection error. When I changed the user to root and the password to none (two single quotes side by side, no space), then it worked.

  65. Susan says:

    Thank you for this posting as it was very helpful once I figured what to edit in the .HTACCESS file. Before editing the .htaccess file, my home page on localhost was perfect, but any other link would lead to a 404 error page -“Object not found! The requested URL was not found on this server.” So I’d like to help others with this problem.

    I created a public wordpress site as a subdomain, which we’ll call “www.PublicSiteName.com/WordpressSiteName”. I wanted to duplicate the WordPressSiteName subdomain on my localhost, the path of which we’ll call “localhost/LocalSiteName”.

    It’s very important to change the RELATIVE PATH NAMES in .HTACCESS file, so that wherever “WordPressSiteName” appears, you would have to replace it with “LocalSiteName”.
    EX: “…OnRewriteBase /WordpressSiteName/…” CHANGES TO “…OnRewriteBase /LocalSiteName/…”


Tweetbacks

  1. wptavern (wptavern) (3 comments.) says:

    Install WordPress Locally On a Windows based machine – http://tinyurl.com/2xqflt and http://tinyurl.com/ckkvhb #wcdfw09

  2. pbelyeu (Paula Belyeu) (2 comments.) says:

    RT @wptavern: Install WordPress Locally On a Windows based machine – http://tinyurl.com/2xqflt and http://tinyurl.com/ckkvhb #wcdfw09

  3. weblogtooltips (WLTC Tips) (3 comments.) says:

    RT @wptavern: Install WordPress Locally On a Windows based machine – http://tinyurl.com/2xqflt and http://tinyurl.com/ckkvhb #wcdfw09


Trackbacks/Pingbacks

  1. […] News 1 ?C?mo instalar WordPress localmente?: parte 1 y parte 2. Y ya se puede ver la pinta que tendr? el nuevo panel de administraci?n. Guardado por Antonio […]

  2. […] Install WordPress Locally – Part 2 Of 2Welcome to part two of a two part series of articles that will guide you through the process of installing a fresh copy of WordPress or your public WordPress blog to your local machine. […]

  3. […] Note: If you haven’t already installed a local version of WordPress this post possibly isn’t for you. I suggest reading these first: Installing WordPress Locally Part 1 – Installing WordPress Locally Part 2 […]

  4. […] WordPress Locally Part 1 Install WordPress Locally – Part 2 Of 2 I go over some of the details that made this article tough to write. We discuss our experiences […]

  5. […] a nuestra copia local. Lo dan explicado en dos partes: instalación del servidor y copia de un blog a una copia local. Más cosas sobre: apache, Tecnología, Ubuntu, WordPress Tecnología, Ubuntu, […]

  6. […] getting it to work links and all as a local installation, despite using several tutorials I found here and I think, there. My site still had some php errors which I could not resolve. I have put that on […]

  7. […] The problem was that creating such environment implied using software and administration tools like XAMPP and PhpMyAdmin which i am not familiar with although i found a very concise and helpful article explaining the important steps. It’s a little outdated, for instance the public_html directory is the same as the htdocs in XAMPP. For people who have experience with apache and such it’s easy but i haven’t practiced a lot of system administration aside from making regular backups. The site is Weblogtoolscolection.com. […]

  8. […] Actualización enero 2008: en el blog de wordpress, explican (en inglés) cómo hacer esto mismo en un windows en lugar de ubuntu y con algunos consejos extras sobre cómo importar un blog que está “en producción” a nuestra copia local. Lo dan explicado en dos partes: instalación del servidor y copia de un blog a una copia local. […]

Obviously Powered by WordPress. © 2003-2013

page counter
css.php