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 <[email protected]> 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:[email protected]]
> > Sent: Friday, June 15, 2012 10:19 AM
> > To: [email protected]
> > 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
>
>
