Hi
My database getting bloated by lots of unnecessary data. I wonder is it safe to delete the data from customer_ip table. it is 3.5m now. and could someone please advice how to remove the session data safely without crashing the site.
thank you in advance
suku
It's a good idea, but you obviously have to be careful to only remove the right stuff!
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Yes that's safe. Make a backup of the table (you can download it if you're trying to save space on the server) and then delete away.
You can keep recent entries with a query similar to this:
That would delete everything from 04-18 and older. You can change the criteria to anything you want (for example just 2021 would delete everything from 2020 and older).
You can keep recent entries with a query similar to this:
Code: Select all
delete FROM `oc_customer_ip` WHERE `date_added` < '2021-04-19'
Who is online
Users browsing this forum: No registered users and 20 guests