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

• Submitted: 11 Feb 2006 3:55
• Modified: 13 Feb 2006 3:10
• Reporter: Jared S (Silver Quality Contributor)
• Status: Can't repeat
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.1.7
• OS: Windows (WinXP)
• CPU Architecture: Any

[11 Feb 2006 3:55] Jared S

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'

[12 Feb 2006 9:37] Valeriy Kravchuk

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.

[13 Feb 2006 2:59] Jared S

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

[13 Feb 2006 3:10] Jared S

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.