Hello,
I followed exactly all the instructions posted by Road Runner here https://www.drupal.org/node/2365719#comment-10344687 on how to create a duplicate of production for testing. However, when I visit my test site, all I get is the typical Welcome to your new Drupal website! page after a new installation, I don't get a duplicate of my production site at all. Has anyone followed this steps before and done it successfully? Has anyone had this issue and solved it? Any and every help would be very much appreciated.
Thanks!

Comments

babipanghang’s picture

Have you tried clearing all drupal and browser caches (CTRL+F5)?

Did i answer your question on the forums? I love to hear a reply wether or not it worked for you!
Jaap - Acquia certified drupal site builder

ricardodrupal’s picture

babipanghang, thanks for your comment. I just did that, but still no solution. Could it be the settings.php file? Is there anything else that I may need to change or add on the settings.php file besides what Roadrunner mentions? Like Roadrunner instructs, I just copied my sites directory over to replace the testsite/sites directory created by fresh install, and then I changed settings.php in testsite/sites/default directory to point to my new database. BTW, my testsite directory is right on the root directory, what I changed in the database section of the settings.php file under testsite/sites/default is just the two lines below the "Database URL format" portion, see next:

* Database URL format:
* $db_url = 'mysql://username:password@localhost/databasename';
* $db_url = 'mysqli://username:password@localhost/databasename';
* $db_url = 'pgsql://username:password@localhost/databasename';
*/
$db_url = 'mysqli://usernewdatase:passwordnewdatabase@localhost/newdatabasename';
$db_prefix = 'newdatabaseprefix';

Other than these I have not changed anything else, everything else in my settings.php file from remains the same since I made the backup copy of all my production site from the server onto my computer. Now, the one thing I notice is that the format of my database starts with mysql, but the format in the new settings.php created by the fresh Drupal is mysqli, and I just replaced the values (username, password, and databasename), not the whole line. Does this matter?

Thanks!

Sam Moore’s picture

Did you take any steps to copy your production database to the new testing DB? Without doing that, you'll just see a fresh Drupal site.

ricardodrupal’s picture

Thanks Sam for your comment. Yes, as Roadrunner indicates, Using PhpAdmin I create a new empty database, then I opened my production database, click on the operations tab, went to "Copy database to", filled in name field with my new database name, checked "Copy structure and data", checked on "Auto increment", and clicked on Go. I checked the new database and it is not empty, I see there is exactly all the data from the production database.

Sam Moore’s picture

If you have drush installed, you can do drush status from within the new site's default directory, to verify that it's connecting to the DB you think it is.
Also don't forget to flush your cache.

ricardodrupal’s picture

Sam, I have installed Drush. How do I do drush status that my test site is connected to the new database? Also, what do you mean when you say "flush your cache"? Thanks!

Sam Moore’s picture

In an ssh session, navigate to the folder where your site's settings.php is (usually sites/default, unless you have a multi-site setup).
Type drush status - it will return what it can find out about your site's setup. Pay particular attention to what database it says it's using, and ensure that that's the one you used to replicate your production database.

To clear cache, you can do drush cc all (You can also do it from the admin interface in your site).