Created
October 6, 2023 09:28
-
-
Save frkosk/7aff4c1c3ac384b42d2a765adda9a950 to your computer and use it in GitHub Desktop.
Cleaning Prestashop database
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Delete connections statistics report: Execute SQL Query */ | |
| TRUNCATE TABLE ps_connections; | |
| TRUNCATE TABLE ps_connections_source; | |
| TRUNCATE TABLE ps_connections_page; | |
| TRUNCATE TABLE ps_guest; | |
| /* Delete Prestashop Logs: Execute SQL Query */ | |
| TRUNCATE TABLE ps_log; | |
| /* Delete Prestashop Referrer statistics report: Execute SQL Query */ | |
| TRUNCATE TABLE ps_referrer; | |
| TRUNCATE TABLE ps_referrer_shop; | |
| TRUNCATE TABLE ps_referrer_cache; | |
| /* Delete page not found statistics report: Execute SQL Query */ | |
| TRUNCATE TABLE ps_pagenotfound; | |
| /* Delete Prestashop Email logs report: Execute SQL Query */ | |
| TRUNCATE TABLE ps_mail; | |
| /* Delete Prestashop old search stats report: Execute SQL Query */ | |
| TRUNCATE TABLE ps_statssearch; | |
| /* Delete Smarty Cache Database: Execute SQL Query */ | |
| TRUNCATE TABLE ps_smarty_cache; | |
| TRUNCATE TABLE ps_smarty_last_flush; | |
| TRUNCATE TABLE ps_smarty_lazy_cache; | |
| /* Login with your FTP account or hosting account, delete all files in PRESTASHOP_ROOT/img/tmp */ |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment