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:j...@newcenturydata.com] > Sent: Friday, June 15, 2012 10:19 AM > To: mysql@lists.mysql.com > Subject: mysqldump not escaping single quotes in field data > > My backups from a mysqldump process are useless, because the dump files > are not escaping single quotes in the data in the fields. > > So, O'Brien kills it - instead of spitting out 'O\'Brien' > it spits out > 'O'Brien' > > I don't see anywhere in the documentation about mysqldump where you can > tweak this kind of thing. > > We're using MySQL 5.0.70 enterprise on Ubuntu 8.04.1. > > 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. > > Thanks, > > Jim McNeely > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
