Contacts ALL GONE after Moving Existing Installation to New Server [SOLVED]

[Pamela]

I followed this guide to move my existing WordPress + CiviCRM installation from a remote server to my local XAMPP server. All seems to have went well except for the fact that all my CiviCRM data is missing. I can still see the data in the actual MySQL database, but other than the actual MySQL database, it practically looks like a fresh install of CiviCRM. I don't see any of my settings or any of the ~2000 individuals or ~8000 organizations.

Is there some setting I need to alter to fix this?

I thought I may have missed a step in the aforementioned guide, but I attempted deleting the database and files and doing it all from scratch again three times to no avail, and am still getting the same results.

I am using the latest stable version of WordPress (4.0.1) and CiviCRM (4.5.4).

Thanks.

[Hershel]

Can you confirm that the install points to the DB with the data?

[Pamela]

Thanks!

 

I was going to quickly answer you and say, "yes, I'm sure," but I decided to manually check to be certain, and turns out... you were right! I somehow had the wrong two databases set in my ".../wp-content/plugins/civicrm/civicrm.settings.php" file!

More specifically, for anyone else that may ever stumble upon this in the future, line 65 where the WordPress database name is defined:

Code: [Select]

define( 'CIVICRM_UF_DSN'           , 'mysql://databaseUsername:databasePassword@localhost/databaseName?new_link=true' );
and line 88 where the CiviCRM database name is defined:

Code: [Select]

define( 'CIVICRM_DSN'          , 'mysql://databaseUsername:databasePassword@localhost/databaseName?new_link=true' );
You have solved two days of headache for me. Thanks again!

P.S. I'm not sure if there is any way to mark this thread as solved, but if so, this issue is now certainly solved for me.