thomaswhiteeagle Posted July 31, 2006 Share Posted July 31, 2006 This may already be posted if so please direct me I cannot find it anywhere. I have two stores. Both sell the same items at the same price but must have different oscommerce since they are otherwise individual. One is set up with OSC and functioning. The other I have set up the database (mysql) and osc but have not programmed the catalog yet. I would like to be able to transfer the entire db catalog from the functioning version to the other one intact- all of the catalog images are already loaded as I transferred them direct from the other site. I have myphpadmin and have tried it that way but probably dont know wht I am doing. Can anyone help me please?? Link to comment Share on other sites More sharing options...
bill110 Posted August 1, 2006 Share Posted August 1, 2006 This may already be posted if so please direct me I cannot find it anywhere. I have two stores. Both sell the same items at the same price but must have different oscommerce since they are otherwise individual. One is set up with OSC and functioning. The other I have set up the database (mysql) and osc but have not programmed the catalog yet. I would like to be able to transfer the entire db catalog from the functioning version to the other one intact- all of the catalog images are already loaded as I transferred them direct from the other site. I have myphpadmin and have tried it that way but probably dont know wht I am doing.Can anyone help me please?? Make a backup of the functioning database in admin. then use an FTP program to get a copy of this backup. (catalog/admin/backups) rename it to the name of the database you want to transfer it to. ie: db_mystore-20060729233128.sql to db_mynewstore-20060729233128.sql upload this to the other site into the catalog/admin/backups folder. then go to admin of that site and do a restore from backup using the uploaded file My Contributions Stylesheet With Descriptions Glassy Grey Boxtops Our Products Meta Tags On The Fly Password Protect Admin "No matter where you go....There you are" - Buccaroo Bonsai Link to comment Share on other sites More sharing options...
thomaswhiteeagle Posted August 1, 2006 Author Share Posted August 1, 2006 Make a backup of the functioning database in admin. then use an FTP program to get a copy of this backup.(catalog/admin/backups) rename it to the name of the database you want to transfer it to. ie: db_mystore-20060729233128.sql to db_mynewstore-20060729233128.sql upload this to the other site into the catalog/admin/backups folder. then go to admin of that site and do a restore from backup using the uploaded file Great! Wo would'a thought.. hmm. Thank you, thank you Bill. I really appreciate the answer. One problem, wouldn't you know it. Now I get this error on the site where I transferred the DB: The sessions directory does not exist: /var/www/vhosts/xxxxxxxx/httpdocs/wholesale/tmp. Sessions will not work until this directory is created. (Where xxxx is the url of the site I transferred from)-Now I tried to figure this out myself but I looked in sessions.php and can't make hide nor hair of it with respect to where to alter anything to reflect that the directory is on the new url?? Link to comment Share on other sites More sharing options...
thomaswhiteeagle Posted August 1, 2006 Author Share Posted August 1, 2006 Actually I answered my own question- its in the session section of the admin panel needed to be changed. Thanks again for the help it is very much appreciated!! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.