Moving website and SQL database to a new host.

dl763 · 17 Nov 2009 at 08:24

Hi all,

We're moving our website which is written in PHP and has a SQL database. I've got the pages across and imported the database but something doesnt seem to work.

Should it be as simple as importing the database back into mySQL and amending the pages to suit the new database name and username/password?

Thanks in advance.

dl763 · 17 Nov 2009 at 09:47

The database name has changed but I've amended it, the user name and password are the same.

There are no errors, it's just not returning any data. The connection to the database is fine as the login (which checks data on a table) works fine.

I'm stumped tbh

I've run the query directly from mySQL and it returns what I'm expecting but it seems like the server doesnt know what to do with the results.

dl763 · 17 Nov 2009 at 10:54

Hi both,

The PHP version is the same, and the SQL version on new host is slightly newer (5.0.86) vs old host at 5.0.81.

The user name did change, but I've accounted for that. It looks like the problem is just occuring when it's trying to put the data from the query into the page.

Update: it works... I'd put a _ instead of a - in the username... grrrrr

Thanks for the help guys.

dl763 · 17 Nov 2009 at 11:23

Do you mean something like

or die ("Cannot get users");

?

I'm having to learn all this from scratch!

dl763 · 17 Nov 2009 at 12:42

Many thanks guys!

Much appreciated.