Problem Creating Dev Environment

  • Resolved jnickles

    (@jnickles)


    14 years, 5 months ago

    I have created a local dev environment on my Windows machine using the basic method described in this article.

    I get WP 3.0 up and running as a new installation. I can open the new WP site and it works fine. I then go to phpMyAdmin and restore my production WP database from a backup sql script created using the backup plugin. The restore succeeds and I can see data in the tables when I browse them in phpMyAdmin.

    However, after the restore, I can no longer access WordPress. I get an error saying it cannot connect to the database. Why would the restore cause this to happen? I’d greatly appreciate any help.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Have you double checked the wp-config.php file to make sure the database settings are accurate? If needed just give the database a new username and password and plug that into the config file.

    Thread Starter jnickles

    (@jnickles)

    I figured it out. In Step 4 in the article I referred to above, the author said to delete the line from the sql script that set the siteurl in wp_options before restoring. This is incorrect because the sql script drops the existing wp_options table before it restores a new one. This leaves wp_options without a siteurl setting. I just edited the siteurl in the sql script before I restored and this fixed it!

    i am having the same problem. when i do the restore (i amended the line about siteurl as you described above) and i am still returning nothing. i would greatly appreciate any help you can give me. thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Problem Creating Dev Environment’ is closed to new replies.