I just moved my site onto the server and put it under /drupal_test directory. I now have got an error in the browser, but there is no errors in the apache error log:
PDOException: SQLSTATE[HY000]  Unknown MySQL server host 'http://www.mydomain.com' (1) in lock_may_be_available() (line 167 of /var/www/drupal_test/includes/lock.inc).
I have searched around online, many suggests that this is a problem with settings.php, but I can't see any problem with my settings:
$databases = array ( 'default' => array ( 'default' => array ( 'database' => 'websitedb', 'username' => 'websitedbusername', 'password' => 'thepassword', 'host' => 'http://www.mydomain.com', 'port' => '', 'driver' => 'mysql', 'prefix' => '', ), ), );
I tried to use the ip address as the host, I got an error like this:
PDOException: SQLSTATE[HY000]  Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in lock_may_be_available() (line 167 of /var/www/drupal_test/includes/lock.inc).
Also, my current site www.mydomain.com works fine.
Any help will be very much appreciated! Thanks!