Bug #5142 Restore of Backup fails. ERROR WHILE RETRIEVING BACKUP CONTENT
Submitted: 22 Aug 2004 16:19 Modified: 30 Aug 2004 12:36
Reporter: Volker von Minckwitz Email Updates:
Status: Closed Impact on me:
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.0.9 OS:Windows (Windows 2000 and Windows XP)
Assigned to: Bugs System CPU Architecture:Any

[22 Aug 2004 16:19] Volker von Minckwitz
Backup created for a database with more than 200.000 rows. Backup file size is about 35 MB. Trying to restore the backup fails. As well the Analyze Backup File Content function within restore fails.

The error occured first with the Beta version 1.0.6. Therefore I installed the release version 1.0.9 and retested. Same behaviour.


Other databases on the same systems (identical installations, one on W2K, one on Windows XP) work fine, but are smaller. 

How to repeat:
Take the generated backup file and either do "Analyze Backup File Content" or "Start Restore" in "Restore" of MySQL Administrator.
[24 Aug 2004 11:51] Andreas Götz
same issue for me. file could be supplied.
[24 Aug 2004 19:35] Jorge del Conde
Verified with a 900MB backup file
[25 Aug 2004 8:30] Volker von Minckwitz
I can provide the 35 MB Backup File which makes the error reproduce. In ZIP format I assume that the file migth shrink down to about 2 MB. Just tell me where to send it to, because for submissions the size limit is 200 KB.
[25 Aug 2004 11:23] Ulrich Bayer
Yes please supply me with the sql-file in question. Just send it to ubayer@mysql.com (Zip preferably :) or put it somewhere where I can download it - whatever is easier for you.
The new Mysql Administrator 1.0.10 gives more concrete error/warning messages normally. Moreover please tell me how the sql-file was created. By Mysql Administrator? If so which version? (There was a bug regarding the backup of binary data in older versions.)
[25 Aug 2004 11:43] Volker von Minckwitz
I can provide you with a backup file of an already enhanced database, which got added columns. Therefore the backup is now 48 MB. However this backup does have the same problem. The original backup file could only be sent tonight as I have just right now no access to it. But this should not matter, because the error reproduces with the new one as well.

The backup was always created with MySQL Administrator. Firstly it showed with Adminitrator 1.0.6. I installed meanwhile 1.0.9 and it reproduces even there. (This was stated already in my original comment).

New backup file will be sent zipped to your email address.
[25 Aug 2004 17:11] Rodrigo Valdivieso

I'm getting the same problem but i Think it's caused by special Characters like ',à,è,ñ... do you have some special characters in your backup file?

Thanks a lot,
(Sorry, I don't speak English.)
[25 Aug 2004 17:20] Volker von Minckwitz

yes, as the database is used for storing log-records from apache logfiles, it might contain special characters.

Possibly your hint helps Ullrich to identify and solve the problem.


[30 Aug 2004 12:36] Ulrich Bayer
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at