Aceicol Posted June 11, 2004 Share Posted June 11, 2004 Hi I have copied one of our sites over to another site (we would like all the same features) and I have also copied over the database so that things such as affiliates worked correctly. However I would like to know how to delete all the products from the db. Also the Customers and order's from the previous db. Thanks in Advance. Ace Link to comment Share on other sites More sharing options...
emanresu Posted June 11, 2004 Share Posted June 11, 2004 We access Mysql admin use the 'empty table' option on the main & related tables. Its not advised but it works - mainly because the way OSC is put together. Over to the DB experts.. Citizen of US Minor Outlying Islands Link to comment Share on other sites More sharing options...
Acheron Posted June 11, 2004 Share Posted June 11, 2004 Its not advised but it works Won't hurt as long as you delete all references in all tables. i.e. Don't delete an Order ID from 'orders' and leave the same ID in 'orers_totals.' ;) Just empty all orders tables, customer tables, and product tables in MyPHPAdmin. Will take all of 2 seconds. :) Link to comment Share on other sites More sharing options...
AlanR Posted June 11, 2004 Share Posted June 11, 2004 http://www.oscommerce.com/forums/index.php?showtopic=45037&st=0& Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management) 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.