Important: Always make a full database backup before deleting or emptying any tables!
Common Large Tables You Can Usually Empty (Truncate) Safely
These tables are related to statistics, visitor tracking, or logs. Clearing them will not affect product catalog, orders, or carts:
-
ps_connections
,ps_connections_source
,ps_connections_page
Visitor statistics and browsing sessions. -
ps_guest
Stores information about guest visitors, not customers. -
ps_statssearch
Stores data about what people search for in your shop. -
ps_log
System log table—error and event records. -
ps_mail
Log of sent emails (safe to empty, but you lose mail history). -
ps_smarty_cache
,ps_smarty_last_flush
Smarty cache data (PrestaShop will rebuild as needed).
To empty (truncate) a table in phpMyAdmin:
-
Select your database, check the table, then choose "Empty" (not "Drop").
-
This will delete all rows, but keep the table structure.