On Thu, 2006-08-31 at 23:34 +0200, Hans du Plooy wrote: > On Thu, 2006-08-31 at 08:06 -0500, Mumia W. wrote: > > > mysqldump -u root [EMAIL PROTECTED] web8_db1 > > >> /home/backup/web8_db1.sql > > > > > > This fails. But I can log in with mysql -u root -p and then type the > > > password in, and that works. > > > > > > How do I get mysqldump to deal to deal with the funny characters? > [snip] > > Put single quotes around the password. > > That's the first thing I tried - I tried escape characters too - no joy.
OK, I don't know why there's a difference, but defining a variable, PASSWORD="[EMAIL PROTECTED]" and then calling: mysqldump -u root -p$PASSWORD web8_db1 > wherever.sql solved it. Thanks Hans -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
