mysqldump and special characters in the password



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


Relevant Pages

  • Re: New to linux but going to try it
    ... www root (apache I mean) in /var, or MySQL databases in /var. ... database files be in the same filesystem as the system logs? ...
    (alt.linux)
  • Strange error with Redhat 3 ES
    ... Just upgraded a web server from an old version of RedHat by complete ... rebuild, then copied the sites and the MySQL databases across etc. ...
    (RedHat)
  • Re: New to linux but going to try it
    ... www root (apache I mean) in /var, or MySQL databases in /var. ... can't figure it out/have never understood it. ...
    (alt.linux)