Bug #3628 Better syntax errors handling in Administrator Restore Backup
Submitted: 2 May 2004 10:13 Modified: 5 Sep 2006 6:43
Reporter: Alexander Keremidarski Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S4 (Feature request)
Version: OS:
Assigned to: Mike Lischke CPU Architecture:Any

[2 May 2004 10:13] Alexander Keremidarski 
Description:
When restoring backups with Administrator any syntax error in backup file produces an uninformative error message in Administrator and restore process stops.

ERROR 1065 at line 5: Query was empty

a) MySQL Administrator should say which line the error was encountered in

b) There should be an option to skip over all syntax errors similar to
mysql --force < backup.sql

How to repeat:
Restore backup with syntax error.
[1 Sep 2005 23:08] Mark McAulay 
Even in version 1.1.2 September 2005, errors during a restore are displayed within the bounds of the dialog box and truncated if they are wider. The error should wrap or the dialog box be made bigger to accomodate the error message.
[5 Sep 2006 6:43] Mike Lischke 
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/