I'm wondering what is the best practice to lighten up the database, particularly the order table.
I've got about 6 years of orders and would like to lighten it up by only keeping the last 3 years and archiving the rest.
I know first and foremost download a back up copy and store it safely.
But should I just then, delete previous orders rows in phpmyadmin and that it? or is there a better method?
Thanks
One of those Extensions may solve your Problem:
https://www.opencart.com/index.php?rout ... n_id=28516
https://www.opencart.com/index.php?rout ... n_id=27309
https://www.opencart.com/index.php?rout ... n_id=40368
https://www.opencart.com/index.php?rout ... n_id=22905
https://www.opencart.com/index.php?rout ... n_id=16049
https://www.opencart.com/index.php?rout ... n_id=13504
https://www.opencart.com/index.php?rout ... n_id=28516
https://www.opencart.com/index.php?rout ... n_id=27309
https://www.opencart.com/index.php?rout ... n_id=40368
https://www.opencart.com/index.php?rout ... n_id=22905
https://www.opencart.com/index.php?rout ... n_id=16049
https://www.opencart.com/index.php?rout ... n_id=13504
I am no longer active at the Forum. Please do NOT send me Personal Mails,
they will no longer be replied to.
My Github OC Site: https://github.com/IP-CAM
4'550 + FREE OC Extensions, on the World's largest Github OC Repository Archive Site.
For anyone that searches the forum,
I ended up doing the following:
1. Backup my database
2. Went into phpmyadmin
3. ran the following sql command :
DELETE from `order` where date_added < '2018-01-01'
This deleted orders older from January 1 2018.
I ended up doing the following:
1. Backup my database
2. Went into phpmyadmin
3. ran the following sql command :
DELETE from `order` where date_added < '2018-01-01'
This deleted orders older from January 1 2018.
Exporting (backup) old entries and deleting them is not really what you have written: archive.
Such would be for me to move older entries to an extra table and to be able to call old(er) entries when I need them.
You only are deleting them, but have to reimport them again when you need some ..
Completely different!
Such would be for me to move older entries to an extra table and to be able to call old(er) entries when I need them.
You only are deleting them, but have to reimport them again when you need some ..
Completely different!
Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.
Who is online
Users browsing this forum: No registered users and 16 guests
