How to copy live wordpress to localhost for development

  • geroido

    (@geroido)


    11 years, 1 month ago

    Hi
    I recently got the job of maintaining a wordpress site created by someone else. i want to take an exact copy of the real site and put it on my xampp localhost platform on my PC. I’ve FTP-ed the wordpress files into the httpdocs folder on xampp and made an sql dump of the database which I recreated on mysql in xampp. There is a problem though as when I try to launch the site on localhost I get an ‘error connecting to the database’ message.
    now I know that the default database username on mysql xampp is ‘root’ and the default password is blank. I have changed this in the config.php files in the wordpress files and in fact I changed it in every file I could find the old username and passsword details from the live install e.g. wp config.php. However I’m still getting the same error. The site does not load at all and I just get this error.

    Can anyone tell me how to take the files and sql dump from the live server and put them on my xampp server on my PC so I can develop this site further.? Any help would be appreciated. What am I missing?

Viewing 2 replies - 1 through 2 (of 2 total)
  • 2ninerniner2

    (@2ninerniner2)

    11 years, 1 month ago

    You will have the change the 2 fields in the wp_options table in the database to the new “location” (generally http://localhost/wp-install-foldername/)

    – option_id # 3 = siteurl
    – option_id # 39 = home

    Cheers!
    Lyle

    Thread Starter geroido

    (@geroido)

    11 years, 1 month ago

    Hi Lyle
    Thanks for the reply
    Will I have to change any database connection details in the config docs and which ones. By default on install, xampp creates a username of ‘root’ and a blank password for mysql. Will these match with the actual database connection details from the live site install files that I copied down.

    Can you just confirm this and what is the config doc that make the database connection?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to copy live wordpress to localhost for development’ is closed to new replies.