A new DB

[indice]

Dear Os_Commerce guru,

 

I like to copy the DB for a new shop, is possible to copy the original in a new name like test1?

 

All the product are same i do this because we must change the price in the other shop.

 

Afther i change also my 2 configure.

 

This are the new line: (in the two configure files)

 

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'andyfree_test');

define('DB_SERVER_PASSWORD', 'amicideltest');

define('DB_DATABASE', '[test2');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

and this is the original:

 

// define our database connection

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'andyfree_test');

define('DB_SERVER_PASSWORD', 'amicideltest');

define('DB_DATABASE', 'andyfree_test');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

 

I change andyfree_test DB in test2, we like to use same data but in an other shop?

 

for example one shop is on:

 

www.mystore.com/A/catalog

 

and the other is on

 

www.mystore.com/B/catalog

 

I hope you understand all, do not esitate to ask me more informations if you find some problem for answer.

 

Many thx

M

[Guest]

You should be able to backup your current database through

Admin-->Tools-->Backup on your current site

 

Copy this file to your new site

and Restore your Database through

Admin-->Tools-->Backup

 

As long as your configuration files point to the correct places this should work

 

Alan

[ka0osk]

You should be able to backup your current database through

Admin-->Tools-->Backup on your current site

 

Copy this file to your new site

and Restore your Database through

Admin-->Tools-->Backup

 

As long as your configuration files point to the correct places this should work

 

Alan

 

Am I correct in that the ADMIN section requires a config table to operate?

 

I get:

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

as part of an error when I try this!

 

Here is the whole screen:

 

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

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

.... isnt there some other set up required to do the restore?

 

 

John ka0osk

[ka0osk]

Am I correct in that the ADMIN section requires a config table to operate?

 

I get:

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

as part of an error when I try this!

 

Here is the whole screen:

 

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

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

.... isnt there some other set up required to do the restore?

John ka0osk

 

Okay I am replying to my own post... I managed to run the DB install script... I think its oscommerce.sql from the install dir and got that going, and restored just fine, modified my config.php files... and for some reason it acts like it is still reading the old config files! I hardcoded the db name, pwd etc into database.php and I can hit stuff okay, but it is not getting the db names and site name etc from the configs... is there some other file I need to change besides the config.php's??

 

John ka0osk