MySQL Bugs: #30719: MySQL Daemon crashes when executing backup from MySQL Administrator

Bug #30719	MySQL Daemon crashes when executing backup from MySQL Administrator
Submitted:	30 Aug 2007 11:56	Modified:	4 Sep 2007 9:23
Reporter:	Joseph Bonello	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.21	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	administrator, Instance

Description:
When executing backup from the MySQL administrator, instance crashes.

Upgraded from MySQL 5.1.16

Administrator version: 1.2.12

Left everything default

Reverted back to 5.1.16, it works perfectly.

How to repeat:
Upgrade from 5.1.16 on Windows XP

Run administrator and run a saved backup.

Thank you for the report.

There is no mention about MySQL Instance Manager in the description (http://dev.mysql.com/doc/refman/5.1/en/instance-manager.html). So I thougth category has been choosed by mistake and changed it. If I was wrong please provide information which role MySQL Instance Manager plays in the problem.

Also please provide your error log file and backup file which crashes MySQL server.

Where can I get the log files/crash files?

Thanks and Regards
Joseph

Please, read http://dev.mysql.com/doc/refman/5.1/en/error-log.html. 

Error log is usually a file <hostname>.err in the data directory.

The error occurs on 5.1.21 only, after the database was upgraded. I tried uninstalling 5.1.16 first and then re-installing 5.1.21, but when I went to the Administrator to take a backup (not restore!), the mysql instance failed. The administrator application did not crash, only the server.

Thanks for your help.

Regards
Joseph

Thank you for the feedback.

In your error log many errors showing you have not run mysql_upgrade script. Please run it and try again.

If you still get errors please provide the backup file.

Yes, running the upgrade script solved the problem. Thanks for your help.