Sql database backup exceeds limit
-
- New to forums
- Posts: 14
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Wed Jan 21, 2015 2:32 am
Sql database backup exceeds limit
So my website database got corrupted. Backup system wont work due to inno-db. Best part i got a downloaded copy of the sql but 105Mb single .sql which exceeds the 100Mb. .zip .gzip .bzip2 compression to shrink .sql file has failed everytime during the importing of the file attempts. Anyone got any ideas or help on how to fix my issue?
- Vanderburg
- Former staff
- Posts: 1253
- Joined: Sat Nov 13, 2010 7:27 am
- Location: Dallas, TX
Re: Sql database backup exceeds limit
You could import the .sql file manually through the command line, using SSH to your webhosting, or you can upload the .sql file to the webhosting and use this utility: http://www.ozerov.de/bigdump/ to import it for you.
-
- New to forums
- Posts: 14
- Joined: Wed Jan 21, 2015 2:32 am
Re: Sql database backup exceeds limit
I'll try this right away. Should the backup be corrupt is it possible to request one of the backups that nfo does automatically even tho there's a couple inno-db tables in it. Also I thank you for the fast response.
- Vanderburg
- Former staff
- Posts: 1253
- Joined: Sat Nov 13, 2010 7:27 am
- Location: Dallas, TX
Re: Sql database backup exceeds limit
We wouldn't be able to provide the backup with the InnoDB tables in it, but it might be possible to remove the InnoDB tables from the backup to allow you to restore the non-innoDB tables.
-
- New to forums
- Posts: 14
- Joined: Wed Jan 21, 2015 2:32 am
Re: Sql database backup exceeds limit
Thank you for your help. After some tries i finally got the Database repaired.