MySQLBackup.dll issues (C# .NET)

Jay50's profile image Jay50 posted 9 years ago in General Permalink
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

Please login to leave a reply, or register at first.