Posted by dlist925 on December 12, 2012 at 2:15pm
Hello all,
I have been having trouble moving my Drupal site from ServersFree.com free hosting to 1&1 paid hosting. I migrated my site data (public-html folder), my MySQL database, and updatated settings.php with the new database server info. However, when I load up my website (naturalstonenecklaces.com), I get the following error:
PDOException: SQLSTATE[HY000] [2005] Unknown MySQL server host 'mysql.serversfree.com' (1) in lock_may_be_available() (line 167 of /homepages/11/d445826877/htdocs/includes/lock.inc).
Help would be much appreciated,
Dakota
Comments
You said you updated
You said you updated settings.php but that error is from trying to connect with your old db. Are you using the default/ folder or a sites/xyz.com/ folder? If the latter you may want to verify that you are reaching the site folder-check to see if there is a settings.php in the default/ folder that's really being called.
Also- the settings.php are write protected by default...sometimes you think you changed it but in reality you didn't because you didn't change the permissions first.
If those appear to check out, another way is to re-install drupal on the new host, verify you are reaching the generic 'starter' site, then via phpMyAdmin or similar tool, drop all tables in that database and restore your saved db backup to it.
If you do that and all is well until you restore you may have a module that's not using the settings.php file but has it's own connection string somewhere. A quick db scan/search for the string 'serversfree' should tell you that. This last is unlikely, but possible.
I'm unique, just like everybody else.
If I helped, please pay it forward, backward or sidelong.