rotoxtc Posted June 15, 2009 Share Posted June 15, 2009 The database for my store has gotten so large the backup file is now almost 160MB. Since I'm about to change server, I've been trying to restore the database locally, but it goes into timeout. I also tried the "Database backup manager" contribution, to no avail. Is there any way to restore the database dividing it in smaller chunks? And how should I divide it? Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 15, 2009 Share Posted June 15, 2009 The database for my store has gotten so large the backup file is now almost 160MB. Since I'm about to change server, I've been trying to restore the database locally, but it goes into timeout. I also tried the "Database backup manager" contribution, to no avail. Is there any way to restore the database dividing it in smaller chunks? And how should I divide it? I guess your hosting provider does not give you the option of directly backing up your database through some panel? The Database backup manager gives you the option of backing up the database table by table (or in groups, some will be quite small). In the readme there are two small programs mentioned that were used for the backup and restoring routines and maybe work better. Any idea why the Database backup manager failed? Link to comment Share on other sites More sharing options...
rotoxtc Posted June 15, 2009 Author Share Posted June 15, 2009 :lol: Any idea why the Database backup manager failed? Nevermind, I tried it one more time to copy the error message and this time it worked :) Thanks, if it hadn't been for you I would never have tried again :lol: Link to comment Share on other sites More sharing options...
graysonhobby Posted June 15, 2009 Share Posted June 15, 2009 This is the error message I receive when trying to back up. This just started [TEP STOP] 2006 - MySQL server has gone away select count(*) as total from sessions where sesskey = 'bfce09da140c3cce878b' Also when diong a backup from my hosting company, my DB backup sql size is 5mb. When dong a back up thru the the Oscommerce tools its stops around 80mb? Why such the large difference? Link to comment Share on other sites More sharing options...
Jan Zonjee Posted June 15, 2009 Share Posted June 15, 2009 This is the error message I receive when trying to back up. This just started [TEP STOP] 2006 - MySQL server has gone away select count(*) as total from sessions where sesskey = 'bfce09da140c3cce878b' Also when diong a backup from my hosting company, my DB backup sql size is 5mb. When dong a back up thru the the Oscommerce tools its stops around 80mb? Why such the large difference? I have seen that error before but it has little or nothing to do with doing a backup. The standard osC database manager will surely make a larger backup than mysqldump because with the osC backup there is an insert line for every row in a table whereas mysqldump will have several rows in an "insert line". But 5 MB versus 80 MB is a ridiculous difference. 30% Is a more normal figure. Perhaps the backup of your provider is compressed (gz?). You could try the Database backup manager contribution and make a gzipped file? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.