From owner-freebsd-questions@FreeBSD.ORG  Thu Oct  2 19:05:13 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 D7AE61065687
	for <questions@freebsd.org>; Thu,  2 Oct 2008 19:05:13 +0000 (UTC)
	(envelope-from bmettee@pchotshots.com)
Received: from mail.pchotshots.com (mail.pchotshots.com [12.172.123.237])
	by mx1.freebsd.org (Postfix) with SMTP id 8A5C28FC08
	for <questions@freebsd.org>; Thu,  2 Oct 2008 19:05:13 +0000 (UTC)
	(envelope-from bmettee@pchotshots.com)
Received: (qmail 99569 invoked by uid 89); 2 Oct 2008 18:38:50 -0000
Received: from unknown (HELO dev2.pchotshots.com) (bmettee@12.172.123.228)
	by mail.pchotshots.com with ESMTPA; 2 Oct 2008 18:38:50 -0000
Message-Id: <4.3.2.7.2.20081002143717.0377a950@mail.pchotshots.com>
X-Sender: bmettee@pchotshots.com@mail.pchotshots.com
X-Mailer: QUALCOMM Windows Eudora Version 4.3.2
Date: Thu, 02 Oct 2008 14:38:32 -0400
To: questions@freebsd.org
From: Brad Mettee <bmettee@pchotshots.com>
In-Reply-To: <48E51421.2040407@FreeBSD.org>
References: <48E500EC.9010100@gmail.com>
 <48E500EC.9010100@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
Cc: 
Subject: Re: Mysqldump password issue
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 02 Oct 2008 19:05:13 -0000

Shouldn't there be a space between -p and the password? Like this:

         mysqldump -u user -p passwd --all-databases > backup.sql

At 02:34 PM 10/2/2008, you wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA512
>
>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
>
>Same MySQL version here, but running CURRENT. Everything works fine..
>
>|
>| Thank you
>|
>|
>
>
>- --
>Pietro Cerutti
>gahr@FreeBSD.org
>
>PGP Public Key:
>http://gahr.ch/pgp
>
>-----BEGIN PGP SIGNATURE-----
>Version: GnuPG v2.0.9 (FreeBSD)
>
>iEYEAREKAAYFAkjlFCAACgkQwMJqmJVx947dzgCgmOM46RQWS+lTEHXHd/wXkZUX
>Uz8AoJEkwynwlaH9rMjRxgp7Xvja82M1
>=On8Y
>-----END PGP SIGNATURE-----
>_______________________________________________
>freebsd-questions@freebsd.org mailing list
>http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"


         Brad Mettee
         PC HotShots, Inc.
         Baltimore, MD
         (410) 426-7617

      -> Let us bring out the *Power* of your PCs. <-
-> Custom Business Software Solutions since 1991 <-

visit http://www.pchotshots.com for information about our company.