From owner-freebsd-questions@FreeBSD.ORG Thu Oct 2 20:16:07 2008 Return-Path: Delivered-To: questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 5A446106568C for ; Thu, 2 Oct 2008 20:16:07 +0000 (UTC) (envelope-from andrei693@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by mx1.freebsd.org (Postfix) with ESMTP id D72768FC16 for ; Thu, 2 Oct 2008 20:16:06 +0000 (UTC) (envelope-from andrei693@gmail.com) Received: by ug-out-1314.google.com with SMTP id m2so1106237uge.39 for ; Thu, 02 Oct 2008 13:16:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from :user-agent:mime-version:to:subject:references:in-reply-to :x-enigmail-version:content-type:content-transfer-encoding; bh=qZ3KuRTc6lXbVCAcaaU0zFkc9ZuwBH1bYWEDcVCLj4c=; b=lSd7aGrhLh/NRnoG+0Vv//hkb9PwjQjHKQD55MQ9QQZ1gmIKFYCiY4i5UHwk40xo42 Ynv/LrAq6vQXx7QRXm2LJYXzNxQ7SHagO9dVXYR7F6LDpVBvQuzoP877Z6Gx9A7ehUFW WjTuy1dA7FijA3Wdx6gSz5LM2sFMcOXrHcA/A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject:references :in-reply-to:x-enigmail-version:content-type :content-transfer-encoding; b=IfWpsaTFuIWwaTn8U/SWi5b1cBr92NOSZurDg/ENSalDq5A83I9zWM3xjPKA2jqvzV Ca4i1YpR6hqPxqERWJa/q3XhmHCxxAhOd6llJBoVlP5Z2Nj/VAGL+/HktKNGKxhkZXjU DDENfer8BItCcOkyjW6deOklphVqKcQ1YQ9mE= Received: by 10.103.239.5 with SMTP id q5mr51802mur.58.1222978564720; Thu, 02 Oct 2008 13:16:04 -0700 (PDT) Received: from ?192.168.0.194? ([86.120.24.220]) by mx.google.com with ESMTPS id i5sm8570971mue.11.2008.10.02.13.16.03 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 02 Oct 2008 13:16:03 -0700 (PDT) Message-ID: <48E52C0C.8030300@gmail.com> Date: Thu, 02 Oct 2008 23:16:12 +0300 From: Andrei Brezan User-Agent: Thunderbird 2.0.0.17 (Windows/20080914) MIME-Version: 1.0 To: questions@freebsd.org References: <48E500EC.9010100@gmail.com> <48E51A66.7050507@infracaninophile.co.uk> In-Reply-To: <48E51A66.7050507@infracaninophile.co.uk> X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: 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: Thu, 02 Oct 2008 20:16:07 -0000 -----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 www -----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-----