dsully Posted January 11, 2006 Posted January 11, 2006 What is the best way to take existing DB info for OsC and put it in another DB for OsC with the same tables?
kwalker Posted January 11, 2006 Posted January 11, 2006 Have you tried renaming the database in ..I believe it's 2 configure.php files, and then replace your old database with the new one? Or simply, gut out your old database and import your new database tables into the existing one. Kevin "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?
dsully Posted January 11, 2006 Author Posted January 11, 2006 Have you tried renaming the database in ..I believe it's 2 configure.php files, and then replace your old database with the new one? Or simply, gut out your old database and import your new database tables into the existing one. Kevin I did go into the config.php and simply change the database, and it worked perfectly. Except when you go to an account and go to check out, you make it to the checkout_payment screen, and it is blank. White screen. Do view source and only a few header tags shown. This is driving me crazy. I have tried to import date with phpMyadmin, with no luck yet. I am not SQL savey.
kwalker Posted January 11, 2006 Posted January 11, 2006 Did you install a new store, or you copied/pasted one store/files over the other? Kevin "What I didn't know yesterday, I know today & will remember tomorrow" (By Kwalker) What do you see when you open up the tep_database-pr2.2-CVS.pdf file that came with your osCommerce download?
dsully Posted January 11, 2006 Author Posted January 11, 2006 Did you install a new store, or you copied/pasted one store/files over the other? Kevin I have installed a new store and copied select files from the old store: index.php, stylesheets, in root. In the includes dir=application_top,bottom.php , header.php , footer.php, column_left,right.php, the images dir. In the languages dir=english.php and the english dir. With moving all these over using the DB OsC created, everything works fine. It is only when I change the DB in the config.php using the main DB is where this problem occurs.
Guest Posted January 11, 2006 Posted January 11, 2006 I did go into the config.php and simply change the database, and it worked perfectly. Except when you go to an account and go to check out, you make it to the checkout_payment screen, and it is blank. White screen. Do view source and only a few header tags shown. This is driving me crazy. I have tried to import date with phpMyadmin, with no luck yet. I am not SQL savey. I just tried something daring with mine. I backed up the original database, ftp'd the backup file to my desktop. Copied and pasted the contents of that backup into my replacement Mysql server query window. Let it do its stuff. Altered configure.php in catalog/includes to point to the new database location with new username/password and database name and it seems to be working a treat.... I did it to prove whether my hosters mysql server is running too slow.
Guest Posted January 11, 2006 Posted January 11, 2006 I just tried something daring with mine. I backed up the original database, ftp'd the backup file to my desktop. Copied and pasted the contents of that backup into my replacement Mysql server query window.Let it do its stuff. Altered configure.php in catalog/includes to point to the new database location with new username/password and database name and it seems to be working a treat.... I did it to prove whether my hosters mysql server is running too slow. Not forgetting the configure.php file in the admin bit too Doh!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.