Guest Posted January 31, 2007 Posted January 31, 2007 I'm overhauling a client's site who's running a heavily modified (and slow as can be) older version of OSC, containing over 2400 products. I've set up the latest OSC milestone (2.2, 060817) on my staging server, and have been carefully installing select contrib's manually. My question is this: I need to restore her database into the new install, but with ONLY the stock database tables (to retain product info, manufacturers, categories, etc). Her old OSC was mucked up with FAR too many mods, the DB is a mess. So, is there a list of stock tables anywhere that I can see? Or... any insight on how you would handle this?
wheeloftime Posted January 31, 2007 Posted January 31, 2007 I'm overhauling a client's site who's running a heavily modified (and slow as can be) older version of OSC, containing over 2400 products. I've set up the latest OSC milestone (2.2, 060817) on my staging server, and have been carefully installing select contrib's manually. My question is this: I need to restore her database into the new install, but with ONLY the stock database tables (to retain product info, manufacturers, categories, etc). Her old OSC was mucked up with FAR too many mods, the DB is a mess. So, is there a list of stock tables anywhere that I can see? Or... any insight on how you would handle this? One option would be to take the latest download package in which you will find a PDF document which shows the stock database structure. A more practical option would be to simply install a fresh osCommerce and look through phpMyAdmin, or whatever database utility, which tables and fields there are. Last but not least you could look at the oscommerce.sql file you will find inside the install directory of the download package. HTH
Guest Posted January 31, 2007 Posted January 31, 2007 One option would be to take the latest download package in which you will find a PDF document which shows the stock database structure. A more practical option would be to simply install a fresh osCommerce and look through phpMyAdmin, or whatever database utility, which tables and fields there are. Last but not least you could look at the oscommerce.sql file you will find inside the install directory of the download package. HTH Thanks Howard, I'll check the PDF :)
Recommended Posts
Archived
This topic is now archived and is closed to further replies.