Bug #9950 Can't restore DB backed up with mySQL Administrator 1.0.20

• Submitted: 16 Apr 2005 6:50
• Modified: 17 May 2005 3:19
• Reporter: [ name withheld ]
• Status: No Feedback
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.0.20
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any

[16 Apr 2005 6:50] [ name withheld ]

Description:
When I try to restore or analyze the backup I created using mySQL Administrator in mySQL Administrator, I get a dialog that suggests success even though it didn't do anything. The dialog says:

------

Backup File: C:\tree\mySQL\backups\searchfox_1m.sql
Total Number of Bytes: 2344223219
Number of Bytes processed: 0

The analyze operation was finished successfully.   <Close>

------

This occures 100% of the time. I backed up the DB using default options for myASM tables of which I have 2

How to repeat:
1) Backup DB
2) Restore DB

[17 Apr 2005 0:00] Jorge del Conde

Hi,

Could it be possible for you to upload the backup file so that we can test it out ?

Thanks a lot

[17 Apr 2005 3:19] [ name withheld ]

The file is 335MB compressed... If you let me know where I can upload it to I would be happy to do so.

TIm

[17 May 2005 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[28 Jun 2005 9:20] Nikki Solo

I am also having some trouble restoring my backup file using MySQL Administrator. I did a backup (UTF8) of my database (2GB) from one server and then tried to restore on another server but the restore interface just pops up a windows that says 'The Analyze operation was finished succesfully' but the Number of bytes processed is 0 and the progress bar is also at 0. I just copied the backup file over the LAN without zipping or tarring it. Anyone knows what give?

Version 1.0.20