Sometimes there could be an issue with huge DB which was created not with backup_migrate module but raw mysqldump command. The size of the DB could be over 2GB. Most of the data of this dump are cache tables and logs. Editing this file is not a good choice.
Current solution will remove INSERTS from the file. sed command come in handy here: