Need some advice, want to copy my database

[Goanna]

I have a fully loaded installation of oscommerce that has at least 60-70 contributions installed. Some little, some big. It is an active store with alot of client information, products, etc.

 

I would like to create another store that has all the same features, but I dont want to import the client data or products, etc. to the new store.

 

I tried exporting the database using structure only mode, but when I do so, the store does not function. It gives me error messages. But if I copy structure and data, it works perfectly.

 

Is there a simple way to delete all clients, sessions, etc so I can start new, short of going into the osc admin or phpmyadmin and deleting them one by one?

 

Any help would be greatly appreciated. Thanks.

[Goanna]

(forgot to subscribe to email notification on the first post. Please ignore this one).

[ozcsys]

I have a fully loaded installation of oscommerce that has at least 60-70 contributions installed. Some little, some big. It is an active store with alot of client information, products, etc.

 

I would like to create another store that has all the same features, but I dont want to import the client data or products, etc. to the new store.

 

I tried exporting the database using structure only mode, but when I do so, the store does not function. It gives me error messages. But if I copy structure and data, it works perfectly.

 

Is there a simple way to delete all clients, sessions, etc so I can start new, short of going into the osc admin or phpmyadmin and deleting them one by one?

 

Any help would be greatly appreciated. Thanks.

I would copy the complete store and then use phpmyadmin to empty the customer and product data.

[Goanna]

I am not fully familiar with MySQL though.

 

What codes would I need to type to recreate the tables containing data?

 

I think Customers, Orders, Sessions, Order Histroy, etc would all need to be reset. Are there any others that should be cleaned out?

[Stuart]

phpmyadmin has an "empty" function which simply empties a table ...

[Goanna]

wow, that makes things alot easier, lol. Thanks!

[Stuart]

No Problem Billy

[Guest]

u can also use mysqldump --add-drop-table --opt databasename > databackupname.sql;