I have mysql 5.5. I am able to use mysqldump to export data with quotes and the dump had escape character as seen below
LOCK TABLES `ananda` WRITE; /*!40000 ALTER TABLE `ananda` DISABLE KEYS */; INSERT INTO `ananda` VALUES (1,'ananda'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3,'thims'),(2,'aditi'),(3,'thims'),(5,'O\'Brien'); /*!40000 ALTER TABLE `ananda` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; Import it back to database Database changed mysql> drop table ananda; Query OK, 0 rows affected (0.00 sec) mysql --database test < test.dmp mysql> select * from ananda; +------+---------+ | id | name | +------+---------+ | 1 | ananda | | 2 | aditi | | 3 | thims | | 2 | aditi | | 3 | thims | | 2 | aditi | | 3 | thims | | 2 | aditi | | 3 | thims | | 2 | aditi | | 3 | thims | | 5 | O'Brien | +------+---------+ May be u want to upgrade you database On Fri, Jun 15, 2012 at 10:48 PM, James W. McNeely <j...@newcenturydata.com>wrote: > 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 > >
