From owner-freebsd-questions@FreeBSD.ORG Sun Oct 5 16:22:47 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1B7B51065686 for ; Sun, 5 Oct 2008 16:22:47 +0000 (UTC) (envelope-from fbsd.questions@rachie.is-a-geek.net) Received: from mail.rachie.is-a-geek.net (rachie.is-a-geek.net [66.230.99.27]) by mx1.freebsd.org (Postfix) with ESMTP id DE33F8FC08 for ; Sun, 5 Oct 2008 16:22:46 +0000 (UTC) (envelope-from fbsd.questions@rachie.is-a-geek.net) Received: from localhost (mail.rachie.is-a-geek.net [192.168.2.101]) by mail.rachie.is-a-geek.net (Postfix) with ESMTP id 9074BAFBC01; Sun, 5 Oct 2008 08:22:45 -0800 (AKDT) From: Mel To: freebsd-questions@freebsd.org Date: Sun, 5 Oct 2008 18:22:42 +0200 User-Agent: KMail/1.9.7 References: <48E500EC.9010100@gmail.com> <48E51A66.7050507@infracaninophile.co.uk> In-Reply-To: <48E51A66.7050507@infracaninophile.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-6" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200810051822.42644.fbsd.questions@rachie.is-a-geek.net> Cc: Andrei Brezan Subject: Re: Mysqldump password issue X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 05 Oct 2008 16:22:47 -0000 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.