HarryCom Posted September 15, 2013 Share Posted September 15, 2013 (edited) Hello, I have a site almost ready but I did also various tests, what tables could be resetted to start clean? I think for example to: truncate table ps_connections; truncate table ps_connections_page; truncate table ps_connections_source; Also ps_cart? ps_log? ps_search_word? I'm afraid to reset things that create problems at the shop. Thank you! Edited September 15, 2013 by HarryCom (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted September 15, 2013 Share Posted September 15, 2013 you can truncate all of these tables (you don't have to worry that something will not work well) but when you remove datas from these tables - you will lose a lot of valuable informations Link to comment Share on other sites More sharing options...
HarryCom Posted September 16, 2013 Author Share Posted September 16, 2013 you can truncate all of these tables (you don't have to worry that something will not work well) but when you remove datas from these tables - you will lose a lot of valuable informations Thanks velia, yes, it is normal that I will lose the information in these tables, but that's what I want, reset the statistics with truncate table ps_connections; truncate table ps_connections_page; truncate table ps_connections_source; Reset carts ps_cart Reset the log ps_log Reset the search words ps_search_word Without having problems with the products entered. They are the final steps that I would like to do before go online. Since many tables are connected to each other, especially with the ID, I would not want that with a truncate on a table I'm going to disconnect the connection with another table, I hope I explained well. Usually, which tables do you reset? Thank you! Link to comment Share on other sites More sharing options...
vekia Posted September 16, 2013 Share Posted September 16, 2013 i usually truncate: - ps_cart - ps_connections_* - ps_log - ps_guest 1 Link to comment Share on other sites More sharing options...
HarryCom Posted September 16, 2013 Author Share Posted September 16, 2013 i usually truncate: - ps_cart - ps_connections_* - ps_log - ps_guest Thanks! Link to comment Share on other sites More sharing options...
Totti Posted September 16, 2013 Share Posted September 16, 2013 Maybe you could implement your own module Link to comment Share on other sites More sharing options...
vekia Posted September 16, 2013 Share Posted September 16, 2013 nice idea Totti it will be available for free 1 Link to comment Share on other sites More sharing options...
Totti Posted September 16, 2013 Share Posted September 16, 2013 Good ! Link to comment Share on other sites More sharing options...
vekia Posted September 16, 2013 Share Posted September 16, 2013 done! absolutely free: database cleanup module Link to comment Share on other sites More sharing options...
bnadauld Posted December 17, 2020 Share Posted December 17, 2020 (edited) what about: ps_condition_advice - can it be truncated? Edited December 17, 2020 by bnadauld (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now