From: Rick James
Date: June 15 2012 10:06pm
Subject: RE: mysqldump not escaping single quotes in field data
List-Archive: http://lists.mysql.com/mysql/227684
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB1487607F82@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Are you using an abnormal CHARACTER SET or COLLATION?
SHOW CREATE TABLE
Show us the args to mysqldump.

> -----Original Message-----
> From: James W. McNeely [mailto:jim@stripped]
> Sent: Friday, June 15, 2012 10:19 AM
> To: mysql@stripped
> Subject: mysqldump not escaping single quotes in field data
>=20
> My backups from a mysqldump process are useless, because the dump files
> are not escaping single quotes in the data in the fields.
>=20
> So, O'Brien kills it - instead of spitting out 'O\'Brien'
> it spits out
> 'O'Brien'
>=20
> I don't see anywhere in the documentation about mysqldump where you can
> tweak this kind of thing.
>=20
> We're using MySQL 5.0.70 enterprise on Ubuntu 8.04.1.
>=20
> I tried to enter this into the Oracle support center but all of the
> navigational and SR tabs are gone. Maybe our accounting dept. forgot to
> pay the bill or something.
>=20
> Thanks,
>=20
> Jim McNeely
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql