MySQL Bugs: #11619: Restore analysing doesn't work

Bug #11619	Restore analysing doesn't work
Submitted:	28 Jun 2005 20:36	Modified:	29 Jun 2005 15:47
Reporter:	Stephane Savage	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.21	OS:	Windows (win xp)
Assigned to:		CPU Architecture:	Any

Description:
As mentionned in bug ID 6433 (release 1.0.13) restore analysis only works on small databases.  I tried it when my db was about 100 mb it worked fine, but now I backed up a db of about 350 mb and it simply doesn't work.  The analysis often stops before completing its process saying "the analyse operation finished succesfully".  If the process completes I don't even get my shema and tables so I can't select anything to restore.  This is a huge problem since I cannot even rely on this tool to shcedule my backups since I will not be able to restore them.  

This problem needs to be fixed as soon as possible, this is an administrative tool to facilitate some processes not to complicate them.

How to repeat:
I created and loaded my database with data, I back it up.  I drop all my tables and then I couldn't restore it.

Suggested fix:
Review the analysis process, there's a leak in the code there, I guess.

On smaller databases, I said it works fine, its not true I sometimes need to do about 4 analyse to get it to work.

Hi!

Thanks for your bug report.  This bug report is a duplicate of #6433  which has successfully been verified.

Thanks!