I've created an overnight process (C# .net v3.5) to backup our live database using MySQLBackup.dll 2.0.5.0 and finally have it working.
In the event of something going wrong, I was thinking of using HeidiSQL to import the backup, however this causes issue and was hoping someone could help.
If I try to import the backup using "Import > Load SQL file", and I run the file without loading in to editor, I get the following error:
SQL Error (1153): Got a packet bigger than 'max_allowed_packet' bytes.
If I decide to load the file in to the editor, I get a warning:
This file contains NUL characters. They have been converted to ASCII spaces (SP).
I'm not 100% sure what this means, but can't risk data corruption with live data.
I should add, that if I create a backup manually with HeidiSQL then import, everything seems to work fine.
Can anyone advise what I should be doing in this situation?
Thanks