Date: Sun, 5 Oct 2008 18:22:42 +0200 From: Mel <fbsd.questions@rachie.is-a-geek.net> To: freebsd-questions@freebsd.org Cc: Andrei Brezan <andrei693@gmail.com> Subject: Re: Mysqldump password issue Message-ID: <200810051822.42644.fbsd.questions@rachie.is-a-geek.net> In-Reply-To: <48E51A66.7050507@infracaninophile.co.uk> References: <48E500EC.9010100@gmail.com> <48E51A66.7050507@infracaninophile.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
On Thursday 02 October 2008 21:00:54 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:
>
> * ? [ < > & ; ! | $
Since I'm writing a parser currently that unescapes make(1)'s :Q modifier, I
can tell you:
\ ( ) # ~ { } ] " '
belong in the same gnashing category.
--
Mel
Problem with today's modular software: they start with the modules
and never get to the software part.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200810051822.42644.fbsd.questions>