zencart数据库清理 让你的网站跑的更快

注意 并不是适合每个人的ZENCART网店 使用这些SQL 命令之前 请一定要备份你的 数据库

zencart数据库清理垃圾数据命令：
清除管理日志
delete from `email_archive`;   
 delete from `admin_activity_log`;  

    delete from  `customers_searches`;
delete from `search_log`;
      delete from `coupon_email_track`;
          delete from     `coupon_redeem_track`;
 delete from  `meta_tags_products_description`;  
     delete from  `paypal`;   去掉PAYPAL IPN
        
       delete from    `subscribers`;

下面的谨慎使用

   delete from orders_status_history ;    delete from  orders_total;
delete from orders;  delete from orders_products ;
delete from paypal; delete from paypal_payment_status_history ; delete from paypal_session ;

delete from productss ;  delete from  reviews ;
delete from customers ; delete from customers_basket ;  delete from customers_info ;  delete from address_book ; delete from customers_origin;
 delete from banners_history ;   delete from categories_discount_quantity ;

转载于:https://www.cnblogs.com/waimaole/archive/2012/09/20/2695887.html