Database Size Issues

Hi All



Running CS-Cart 3.01 with MySQL database



Setup n config.local.php: $config['db_type'] = 'mysqli';



The database has blown out to a ridiculous size: 2.2 GB (database has been optimised)



We only have a few customers and 900 products.



The offending table in MySQL database is cscart_cache. (2GB)



Does anybody know if I can safely empty the table?



EG: with SQL query TRUNCATE cscart_cache



I know people have said you can empty the stored sessions, but that table is not really the concern.



Much appreciated if someone can shed some light.

If you use several store-fronts and want to clear cache for all stores, please run the following query



TRUNCATE cscart_cache;




If you want to clear cache only for one store, please use:



DELETE FROM cscart_cache WHERE company_id = XXX;




where xxx is the ID of the store

Awesome - thank you!



Just wondering if it would be safer to delete the actual rows in the cscart_cache table through phpMyAdmin. I know this will be a lot slower. Any opinions?



Thanks in advance

[quote name='emilio' timestamp='1422608882' post='203902']

Awesome - thank you!



Just wondering if it would be safer to delete the actual rows in the cscart_cache table through phpMyAdmin. I know this will be a lot slower. Any opinions?



Thanks in advance

[/quote]



Sure, you can use phpMyAdmin. I have corrected my post