ken0306 Posted May 29, 2011 Share Posted May 29, 2011 My database for the shopping cart currently is over 15MB with .gz file. So, even I change my server's timeout, it still take a long time to restore it. So, is there any software or add-on allow me to break the backup data in couple of small files ? Thank you ken Link to comment Share on other sites More sharing options...
NodsDorf Posted May 29, 2011 Share Posted May 29, 2011 BigDump Staggered Database importer. I used it several times moving database between host. Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 29, 2011 Share Posted May 29, 2011 My database for the shopping cart currently is over 15MB with .gz file. So, even I change my server's timeout, it still take a long time to restore it. So, is there any software or add-on allow me to break the backup data in couple of small files ? Check with your host to see if they offer shell access. You can upload/download a database that size in less than a minute using the shell. You may also want to install the Database Optimizer contribution (see My Addons). Large databases usually have a lot of old entries that needlessly bloat the database. That contribution will remove them on a regular basis. Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
ken0306 Posted June 3, 2011 Author Share Posted June 3, 2011 Check with your host to see if they offer shell access. You can upload/download a database that size in less than a minute using the shell. You may also want to install the Database Optimizer contribution (see My Addons). Large databases usually have a lot of old entries that needlessly bloat the database. That contribution will remove them on a regular basis. thank you, that works perfect. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.