Mysqldump password issue

[Andrei Brezan]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Matthew Seaman wrote:
> Andrei Brezan wrote:
>> Hello list,
>>
>> I wanna do a
>> mysqldump -u user -ppasswd --all-databases > backup.sql
>>
>> and all I get is
>> mysqldump: No match.
>>
>> This happens either i put --all-databases or I specify any of the
>> databases. I want to do a backup as user root, that's why I use
>> all-databases opt.
>>
>> If I use the command:
>> mysqldump -u root -p --all-databases >backup.sql
>> I get the password prompt, I type the passwd and everythig works great.
>> It seems that there is a problem with -p, i've tried --password with
>> same result.
>>
>> If anyone has any ideea please let me know about it.
>> I mention that i use Freebsd 7_0 and mysql 5.0.67
>>
> 
> My guess is that the password (which you've obviously elided) contains
> characters of syntactic significance to the shell.  Any of the following
> will lead to wailing and gnashing of teeth:
> 
>  * ? [ < > & ; ! | $
> 
> Probably others as well.  The general way to get round this is to
> put 'quote' marks around your password -- but this will only work if
> the password is a separate word on the command line -- ie. whitespace
> between it and any other tokens.  I believe that the '-p' flag to MySQL
> is a bit painful in that regard as it doesn't allow whitespace between
> itself and the password.  Hmmm... untested, but it should work if you
> just quote around the -p like so: '-ppassword'.
> 
> Alternatively, just change the password to one containing less
> troublesome characters: a-zA-Z0-9:@#~+=-_^%., I recommend use of
> 'apg' to generate randomised but strangely memorable passwords.  Oh,
> and simply making the password longer makes it much more secure even
> if you're limited to a relatively small alphabet.
> 
>     Cheers,
> 
>     Matthew
> 

Thank you Matthew, you were right. My password contains special
characters. It works now with '-ppasswd' or with --password='passwd'


- --
Andrei Brezan
310280 Arad - Romania
mobile <+40 740 089 315>
email <andrei at bsoft-company.ro>
www <http://www.bsoft-company.ro/>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkjlLAwACgkQUmw8msqk48YKugCfasoH9/cfo/xgss7wmuAIlnK6
xS8An0idODUSkUnwKLlRKYKqoCQ5Cy3P
=UQ5J
-----END PGP SIGNATURE-----