MySQL Bugs: #17337: MySQL Administrator is unable to restore its backup

Bug #17337	MySQL Administrator is unable to restore its backup
Submitted:	13 Feb 2006 3:33	Modified:	15 Feb 2006 9:52
Reporter:	Jared S (Silver Quality Contributor)	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.1.8	OS:	Windows (XP PRO)
Assigned to:		CPU Architecture:	Any

Description:
Basically on MySQL server 5.0.18 the SQL code below will not run unless Enable statements are removed or if the \' is changed to ''

/*!40000 ALTER TABLE `table1` DISABLE KEYS */;
INSERT INTO `table1` (`id`,`description`) VALUES 
 (1,'Baily\'s Ice Cream');
/*!40000 ALTER TABLE `table1` ENABLE KEYS */;

How to repeat:
Create blank table with fields(id, description)

insert values (1, Joe's)

Backup using Administrator (ensure disable keys is checked)

Open using QA and watch it fail.

If you use Adminstrator to restore then ensure you drop original database because Administrator does not throw error.

Suggested fix:
SQL non query text parser needs to be able to insert \' in conjunction with enable keys statements

Thank you for a problem report. Please, send the SHOW CREATE TABLE `table1` results (or upload your backup). Check the same statements in mysql command line client, if you think it is a server bug. If it is MySQL Administrator's bug, from your point of view, inform about the version used.

Hi,

I want to change my problem.  MySQL Administrator doesn't back up *Anything*.

MySQL Administrator 5.1.1.8
----------------------------

To reproduce problem, 1. Create schema with table,  2. Backup, 3. Drop using QA, 4. Restore using Administrator

Guess I should stick to Released versions :(

Jared

Duplicate of bug #17333, almost surely.