Re: mysqldump and special characters in the password



On 08/31/2006 06:04 AM, Hans du Plooy wrote:
Hi guys,

I'm setting up a script to backup the mysql databases on a web server.

For example:

mysqldump -u root --password=p@$$w0rd 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?

Thanks
Hans


Put single quotes around the password.


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx



Relevant Pages

  • Re: mysqldump and special characters in the password [solved]
    ... But I can log in with mysql -u root -p and then type the ... How do I get mysqldump to deal to deal with the funny characters? ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • RE: Cannot Login
    ... My web server (running Lenny) is ... and delete the password for root. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: mysqldump and special characters in the password
    ... But I can log in with mysql -u root -p and then type the ... How do I get mysqldump to deal to deal with the funny characters? ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: looks like ive dug my hole too deep, plz help quick.
    ... You have only those two files in root? ... This should make for a very nice web server. ... >> Do you Yahoo!? ... To unsubscribe, ...
    (freebsd-questions)
  • Re: mysql Etch -> Etch
    ... You can get the mysqldump from the Machine A and then restore this ... dump in new MySQL installation @ Machine B. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ... Trouble? ...
    (Debian-User)