-----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 <[EMAIL PROTECTED]> 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----- _______________________________________________ email@example.com mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"