Moving website (inc. SQL) between two servers.

[unrealrocks]

I've had a blog for years now running on a system called B2Evolution. It's been running on a machine at my house since I put it up (about two and a half years ago) although I want to move it to a proper server now.

I copied across the htdocs folder, and then did an SQL dump from mysql, then imported the file into mysql on the new server.

I updated the username and passwords inside B2Evo, and when I try to access it I get a

MySQL error!

Error establishing a database connection!
Are you sure you have typed the correct user/password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?

I presume this is something built into B2Evo as the sql server doesn't have any activity when I try to access the page.

Any help would be muchly appreciated

The machine I used to run it on was running WindowsXP, mySQL 4.0.21-nt, and Apache 1.3 (not sure exacly which version). The machine its moving to runs Windows 2003, mySQL 4.1, and Apache 1.3 (IIRC).

[Iain]

your home database will be localhost or a local IP. You may have updated the username and pass but did you make sure the database hostname was set ?

[unrealrocks]

Well the whole thing is moving to another machine so it's still localhost as its on the same machine. Cheers for the idea though.

[aidanjt]

Did you create the same username/password on the new MySQL server?.. thats a common mistake that people make. Thats what B2Evo is pointing to at least.

[unrealrocks]

The username and password is different although I changed it in the configuration file of B2Evo, does it still need to be the same as it was installed like that?

[aidanjt]

There's a MySQL error somewhere, maybe mysql-nt isn't listening in on 127.0.0.1, try the IP address of the NIC on that server, and/or make sure that mysql has started in the first place. you could try running this test script:

<?php
$host="localhost"
$user="root"
$pass="pass"
$dbase="b2evo"

$link = mysql_connect($host,$user,$pass);
  if(!$link) {
    die("Error! Unable to connect to MySQL server at: ".$host);
}
echo "<p>Connected to MySQL Server: $host </p>\n";

$db_selected = mysql_select_db($dbase,$link);
if(!$db_selected) {
  die("Error! Could not select MySQL database: $dbase");
}
echo "<p>Selected MySQL database: $dbase";
?>

Experiment with the variables up top and see if PHP is having problems with MySQL

[Iain]

Also try installing query browser and opening up a connection

http://dev.mysql.com/downloads/query-browser/1.1.html

[unrealrocks]

Well after a bit of fiddling with usernames and passwords it now will talk to the database, the blog choosing page comes up (which shows its talking to the database, and there isn't an SQL error anymore) ... but now I get an 'Error 500' from Apache when I try to access any of the blogs, will go through the logs in a min but apart from being 'An internal error' what exacly does error 500 mean? lol

[unrealrocks]

OK - just had a look in the apache logs ...

[Tue Jan 31 01:07:52 2006] [error] [client 210.55.248.134] Premature end of script headers: c:/apache/php/php.exe

This error seems to happen alot (like 2MB of error log with pretty much just this error in). Dunno if this helps?

[unrealrocks]

Tried updating to the latest version of Apache - same problem.

[GDVS]

Does this help?

http://forums.b2evolution.net/viewto...0212888ed81022

[aidanjt]

[Tue Jan 31 01:07:52 2006] [error] [client 210.55.248.134] Premature end of script headers: c:/apache/php/php.exe

You should reallyyyy use the SAPI php module on apache, its much more stable, mature, and secure than the CLI PHP binary. Its a pita to be honest, it might even fix your problem.