MySQL Forums
Forum List  »  General

Re: Escape database name when using mysqldump
Posted by: Scott Nemes
Date: January 23, 2013 10:41AM

This is an odd case, but the below seems to work from my testing:

Test database name: testing'quotes"test

mysqldump "testing'quotes\"test" > ~/test.sql

The idea is that if you use double quotes around the database name, then you must escape only the double quotes within the database name, and leave the single quotes as-is, or vice versa.

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Options: ReplyQuote


Subject
Written By
Posted
Re: Escape database name when using mysqldump
January 23, 2013 10:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.