Empty Database

USE WITH CAUTION !!! NO RESTORE !!!

Emptying the database will remove ALL data in your database from the following tables:

  • products
  • products
  • product_price
  • product_mf_xref
  • product_attribute
  • product_relations
  • category
  • category_xref
  • product_attribute_sku
  • product_category_xref
  • product_discount
  • product_type
  • product_type_parameter
  • product_product_type_xref

All but the first manufacturer is removed:

  • manufacturer

The following tables are completely deleted:

  • product_type_x

The x represents the number of the table. This number relates to the product types that are in the system. Since the product types table is completely emptied, these tables are removed. Uploading new product types will recreate the tables.

Procedure:

  1. Choose “Maintenance” from the control panel
  2. Select “Empty database”
  3. Click “Continue”
  4. The database is now emptied and the results are shown on the output screen
 
csvimproved/explained/empty_database.txt · Last modified: 2008/03/02 07:41 by rolandd
 
Recent changes RSS feed Creative Commons License Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki