Error 1046 on changing host/domain

[Guest]

Hi,

 

I'm trying to move my installation of OSCommerce from http://www.rentalsrl.tk to http://negozio.rentalsrl.com

 

What I did:

 

1. FTP'd everything to my local machine

2. backed up database from phpmyadmin

3. FTP'd everything up on the new server

4. created new db and inserted database backup

 

What I get now is a 1046 error. Settings in configure.php look fine. I don't want to run the install script as the db is already populated and the osc installation is customised.

 

I have read in another post that the configure.php file '...gets written by the server during installation...".

 

Q: What variables does the server write?

Q2: What should be contained in the fields configuration_key and configuration_value?

 

If anyone out there has successfully moved an installation changing domain name, passwords and db name then please, pretty please, smiley please :) shed some light!

 

Thanks as always,

Danny

[Christian Lescuyer]

Quite easy: there are two configure.php files with the database information. Edit them with a text editor, and change the lines at the end to fit your new setup.

  define('DB_SERVER', 'localhost');

 define('DB_SERVER_USERNAME', 'oscommerce');

 define('DB_SERVER_PASSWORD', '********');

 define('DB_DATABASE', 'oscommerce');

[Guest]

Yup, that was it:

 

error 1046 solution: change configure.php in both catalog and admin directory.

 

Thanks. :D