Empty a database

More
13 years 1 month ago #293 by Support Team
If you need to reset a database to empty (no products but keeping the configuration settings), then take the following and paste it into a PHPMyAdmin sql window and you should be good to go.
DELETE FROM `address_book`; 

DELETE FROM `banners`; 

DELETE FROM `banners_history`; 

DELETE FROM `categories`; 

DELETE FROM `categories_description`; 

DELETE FROM `counter`; 

DELETE FROM `customers`; 

DELETE FROM `customers_basket`; 

DELETE FROM `customers_info`; 

DELETE FROM `manufacturers`; 

DELETE FROM `manufacturers_info`; 

DELETE FROM `orders`; 

DELETE FROM `orders_products`; 

DELETE FROM `orders_status_history`; 

DELETE FROM `orders_total`; 

DELETE FROM `products`; 

DELETE FROM `products_attributes`; 

DELETE FROM `products_attributes_download`; 

DELETE FROM `products_description`; 

DELETE FROM `products_notifications`; 

DELETE FROM `products_options`; 

DELETE FROM `products_options_values`; 

DELETE FROM `products_options_values_to_products_options`; 

DELETE FROM `products_to_categories`; 

DELETE FROM `reviews`; 

DELETE FROM `reviews_description`; 

DELETE FROM `sessions`; 

DELETE FROM `specials`; 

DELETE FROM `whos_online`; 



ALTER TABLE banners AUTO_INCREMENT = 1; 

ALTER TABLE banners_history AUTO_INCREMENT = 1; 

ALTER TABLE categories AUTO_INCREMENT = 1; 

ALTER TABLE customers AUTO_INCREMENT = 1; 

ALTER TABLE customers_basket AUTO_INCREMENT = 1; 

ALTER TABLE customers_basket_attributes AUTO_INCREMENT = 1; 

ALTER TABLE manufacturers AUTO_INCREMENT = 1; 

ALTER TABLE manufacturers_info AUTO_INCREMENT = 1; 

ALTER TABLE orders AUTO_INCREMENT = 1; 

ALTER TABLE orders_products AUTO_INCREMENT = 1; 

ALTER TABLE orders_status_history AUTO_INCREMENT = 1; 

ALTER TABLE orders_total AUTO_INCREMENT = 1; 

ALTER TABLE products AUTO_INCREMENT = 1; 

ALTER TABLE products_attributes AUTO_INCREMENT = 1; 

ALTER TABLE products_description AUTO_INCREMENT = 1; 

ALTER TABLE products_options_values_to_products_options AUTO_INCREMENT = 1; 

ALTER TABLE reviews AUTO_INCREMENT = 1; 

ALTER TABLE specials AUTO_INCREMENT = 1;

Please Log in to join the conversation.

More
13 years 1 month ago #294 by Support Team
Replied by Support Team on topic Re: Empty a database
the lines that deal with orders.
DELETE FROM `orders`;
DELETE FROM `orders_products`;
DELETE FROM `orders_status_history`;
DELETE FROM `orders_total`;

ALTER TABLE orders AUTO_INCREMENT = 1;
ALTER TABLE orders_products AUTO_INCREMENT = 1;
ALTER TABLE orders_status_history AUTO_INCREMENT = 1;
ALTER TABLE orders_total AUTO_INCREMENT = 1;

Please Log in to join the conversation.

Time to create page: 0.228 seconds
Events Joomla
MarvikShop
Finnaly it's here:
 
No bridges, no look a likes!
This is the ultimate integration
between Oscommerce and Joomla!
Documentation
Site Showcase
Follow us

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries