Jump to content
14steve14

Clear order comments from database

Recommended Posts

I am thinking that I would like to remove some of the very early data from my database before transferring it all to a new version of the shop using Phoenix. First question I suppose Is it really worth doing? Would there be any gain from deleting all this old data.

Current database backup size is 389,909,542 bytes.

The store has been online for over 10 years now and I have never removed any old orders or data from that far back. I do remove inactive customers and their address details using the inactive customers addon. I also notice that the order comments table is full of comments from PayPal, Stripe, my delivery tracking information and of course the comments left by customers. Is it worth removing some of this data?

If it is worth removing all this old data is there a great one off addon that will remove it all , or will it be lots of different addons or even just something to remove it in mysql.


REMEMBER BACKUP, BACKUP AND BACKUP

Get the latest Responsive osCommerce CE (community edition) here

It's very easy to over complicate what are simple things in life

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×