-----BEGIN PGP SIGNED MESSAGE-----
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.
Thank you Matthew, you were right. My password contains special
characters. It works now with '-ppasswd' or with --password='passwd'
310280 Arad - Romania
mobile <+40 740 089 315>
email <[EMAIL PROTECTED]>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
email@example.com mailing list
To unsubscribe, send any mail to "[EMAIL PROTECTED]"