Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: daveoliver on March 07, 2004, 09:56:28 AM

Title: Moving a phpwebsite from a live machine to a test machine
Post by: daveoliver on March 07, 2004, 09:56:28 AM

Hi,

I am trying to move a live website from my live server to my test server.

I have used Backup to Workstation to copy the information bay and renamed and restored it onto my test server.

I have then used phpMyAdmin to export the mysql database out and then copied this onto my test server and from the command prompt ran mysql -u user -p password < Filename.sql

replacing user password and filename with the correct information.

I do not receive any errors until I try to access the website and I get Unable to select database

Anyone help me out here please.....

Thanks

Dave

Title: Moving a phpwebsite from a live machine to a test machine
Post by: genzil on March 07, 2004, 05:06:24 PM

it looks like your php web site is having trouble acessing the database, make sure you changed any config files that your php web site uses.

Title: Moving a phpwebsite from a live machine to a test machine
Post by: daveoliver on March 07, 2004, 08:26:44 PM

Hi,

Yes, well When I created the mysql database I checked the config.php file in the html directory to make sure that I used the correct database name, user and password.

Then I imported the mysql tables and then tried to open the site, which is where I get the unable to select database error.

My next option is to drop the database, recreate it and see if I can setup a new phpwebsite without importing the tables, to see if there are any errors there.

D