Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Easy Way To Clear Database?


Mort-lemur

Recommended Posts

Hi,

 

I have a heavily modified store with many changes made to the database structure due to contributions.

 

I now need to create a clone store and copying and modding the php files is no problem.

 

But my question is...is there an easy way to clear a backup of the database of all customers, all orders, most viewed products etc etc?

 

Many Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

Heather,

 

 

use phpmyadmin and truncate the address_book, counter, customers, customers_info, orders, orders_products, orders_total and reviews tables.

 

 

 

 

 

 

 

Chris

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...