Error Message-1146 - Table 'dgriff.configuration' doesn't exist

[katman1971]

Hi

I changed hosts and I have a problem. I uploaded my oscommerce site to the new host but I'm getting this error message:

1146 - Table 'dgriff.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

I didn't make a backup of my database so I went ahead and created a new database with my new host (godaddy). I checked the settings in configure.php. Godaddy told me that my settings should look like this: $hostname='xxxxxxxxxxxxxxxxxx';

So I inputted the xxxxxxx info into this line of the configure.php (off course I have swapped the hostname for all the x's.

  define('DB_SERVER', 'xxxxxxxxxxxxx');

 

I also checked for configure files in the local folder...there's none there. And I asked godaddy but they know nothing about it. Now I'm stuck. Any suggestions would be a great help. thanks.

[Guest]

Jim,

 

Your new database has different table prefixes. You will need to import the old database into the new database.

 

Your configure.php for godaddy should look something like this:

 

define('DB_SERVER', 'dgriff.db.1236679.hostedresource.com');

define('DB_SERVER_USERNAME', 'dgriff');

define('DB_SERVER_PASSWORD', 'password here');

define('DB_DATABASE', 'dgriff');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

 

 

Chris

[katman1971]

Jim,

 

Your new database has different table prefixes. You will need to import the old database into the new database.

 

Your configure.php for godaddy should look something like this:

 

define('DB_SERVER', 'dgriff.db.1236679.hostedresource.com');

define('DB_SERVER_USERNAME', 'dgriff');

define('DB_SERVER_PASSWORD', 'password here');

define('DB_DATABASE', 'dgriff');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', 'mysql');

 

 

 

Chris

 

How should I import the old database into the new database? THanks

[Guest]

Jim,

 

If the new tables are exactly the same as your old, you can drop the existing tables, then IMPORT your SQL dump from your old database. If they are not, you will have to edit the SQL to make them identical.

 

 

 

Chris