Bug #17317 Backing up table with a field value that has a single quote

Description:
Backing up table with a field value that has single quote in.

e.g.  Baily's Ice Cream --> Baily/'s Ice Cream

Screws up the restore.

How to repeat:
Simply create table with id|description add 1 row (1,Baily's Ice Cream)

And backup

And restore (Errors - no UI on error)

Suggested fix:
Administrator NEEDS TO format a backup like this ..  'Baily''s Ice Cream'

Thank you for a problem report. Sorry, but I was not able to repeat with MySQL Administrator 1.1.7. It had saved this value as:

(1,'Baily\'s Ice Cream');

in backup file. And it was successfully and correctly restored then.

Hi

Can you please check that you droped the schema in (QA1.1.20) before performing restore.

Because, Administrator(1.1.8) will not inform you if the restore failed.

Thanks
Jared

Looking at it closer, If you take the backup file and put it into script page of QA.

You should see  \'  failing in conjunction with enable/disable keys

Hope this is enogh info.