Ultimate Guide to Multi Channel Sofwtare Book
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

mail_open
Reducing Magento installation size / archiving old order
Dave1
Member
April 17, 2018 - 11:15 am
Member Since: October 24, 2013
Forum Posts: 151
sp_UserOfflineSmall Offline

My magento install is a good couple of years old now but it’s started to get really large on the server’s disk. Files are 6 gb and database is 10gb. So 16gb together, but then a couple of backups mean that I’m near my disk limit.

– Not sure what the large files are (images on 5000 products maybe?)
– Expect the database is mainly orders and stuff related to orders as there are 100,000 of them

So… any ideas on how to track down exactly what’s taking up the disk space, and more importantly is there any decent stable extension (or ideally a way that doesn’t use an extention) which will help me archive the old stuff? I use M2E pro and a few moogento extensions which may or may not get in the way of any extensions.

Or should I just export and then delete old orders from the database?

Site runs OK so the other option it to buy more disk space and keep everything as it is.

Thoughts anyone?

Avatar
Dave Furness

Founder
April 26, 2018 - 5:06 pm
Member Since: July 19, 2013
Forum Posts: 4572
sp_UserOfflineSmall Offline

Not really my expertise here Dave but if it was me i’d be tempted to ask the hosting company what was taking up the most space on the server.

From there you would be better informed as to what action you could take.

Dave

Every expert was once a beginner

Dave1
Member
April 27, 2018 - 9:44 am
Member Since: October 24, 2013
Forum Posts: 151
sp_UserOfflineSmall Offline

Thanks Dave, I’m pretty sure what I need to tackle is the old orders. The database is growing each month and I’m pretty sure it’s that.

I guess what I’m really after is the best/safest way to back up and archive the old orders without breaking anything. If that’s even possible

Dave1
Member
April 27, 2018 - 9:50 am
Member Since: October 24, 2013
Forum Posts: 151
sp_UserOfflineSmall Offline

Thanks Dave. I’m pretty sure that my main problem is the old orders (and related customers invoices in the database, etc etc)

I can reduce the installation size by removing some images I don’t need, but this will only work once, and the database will keep growing.

So I guess my main question, is how have other people dealt with this? Does anyone have experience with archiving old orders (ie. removing them to a local PC and deleting from the server)

 

Why Should You Join UnderstandingE?

 
  • Access to over 500 step-by-step video tutorials
  • +20 video courses available
  • Magento, M2E Pro, Magmi, eBay, Amazon & Design all covered
  • Everything is in 100% Plain English
  • Learn how to build your own multi-channel software for eBay & Amazon
  • Access to the community forums, meet fellow business owners like yourself

Join Now with 2 Clicks

 

Join now for less that £1 per day you can gain access to over 400 step-by-step video tutorials & learn how to build your very own multi-channel software.

 

Forum Timezone: Europe/London

Most Users Ever Online: 1012

Currently Online:
22 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Jim @ Moogento: 688

Steve Froggatt: 514

Badeth - UE: 513

Jimbob: 453

Paul Cartwright: 414

Forum Stats:

Groups: 6

Forums: 37

Topics: 5183

Posts: 27396

Administrators: Matthew Ogborne: 4565, Dave Furness: 4572