List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:June 16 2012 7:59pm
Subject:Re: mysqldump not escaping single quotes in field data
View as plain text  
 mysqldump --databases test --tables ananda > test.dmp
mysql> show create table ananda\G;
*************************** 1. row ***************************
       Table: ananda
Create Table: CREATE TABLE `ananda` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)


On Sat, Jun 16, 2012 at 3:36 AM, Rick James <rjames@stripped> wrote:

> 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
> >
> > 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
>
>

Thread
mysqldump not escaping single quotes in field dataJames W. McNeely15 Jun
  • Re: mysqldump not escaping single quotes in field dataAnanda Kumar15 Jun
  • RE: mysqldump not escaping single quotes in field dataRick James15 Jun
    • Re: mysqldump not escaping single quotes in field dataAnanda Kumar16 Jun