How do you totally empty the mysql catalog without deleting

[mymikl]

customer data or other data, I just want to start my catalog fresh without tedious deletion of all products. And once I have my prodcuts reloaded, if there is only sub cat, how do I get the first page to display by default?
thanks
MrMikl

[oblongpeg]

You can use the TRUNCATE syntax to remove all data inserted into a table.

Have a look at

http://dev.mysql.com/doc/refman/5.0/en/truncate.html

to get an idea of what has to be done.

If this seems to be beyond you, I would suggest a couple of bandaids and start thumping that delete button.

[mymikl]

has anyone posted a MYSQL schema on the whole store or even just the catalog. The above reply is correct, but you must get rid of data in the child tables before you can get rid of the data in the parent tables. The MYSQL Truncate command doesnt mention how it deals with parent-child relationships.

Would a regulare OSCOMMERENCE book work here or not, if it had the schema?

If you would like a suggestion for OSCmax, it would be a contribution or a built in feature to empty the catalog. Its really a matter of using the DELETE * FROM [TABLENAME] in my sql. Everyone I spoke to seems to think MYSQL is too touchy, so use the catalog funcion to delete items one by one.

anyway, thats my 2 cents worth. Thanks MrMikl

[michael_s]

Write it and I will add it to the codebase...