From owner-freebsd-questions@FreeBSD.ORG Fri Oct 3 08:56:37 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 B41A81065693 for ; Fri, 3 Oct 2008 08:56:37 +0000 (UTC) (envelope-from i.tanusheff@procreditbank.bg) Received: from mail.procreditbank.bg (mail.procreditbank.bg [193.26.216.3]) by mx1.freebsd.org (Postfix) with SMTP id 0DC458FC19 for ; Fri, 3 Oct 2008 08:56:36 +0000 (UTC) (envelope-from i.tanusheff@procreditbank.bg) Received: (qmail 13310 invoked from network); 3 Oct 2008 11:48:56 +0300 Received: from unknown (HELO domino.procreditbank.bg) (10.0.0.15) by 192.168.1.3 with SMTP; 3 Oct 2008 11:48:56 +0300 In-Reply-To: <48E500EC.9010100@gmail.com> To: Andrei Brezan MIME-Version: 1.0 X-Mailer: Lotus Notes Release 7.0.3 September 26, 2007 From: Ivailo Tanusheff Message-ID: Date: Fri, 3 Oct 2008 11:29:52 +0300 X-MIMETrack: Serialize by Router on DOMINO/BULGARIA/PROCREDITBANK(Release 7.0.2FP2|May 14, 2007) at 03.10.2008 11:29:57, Serialize complete at 03.10.2008 11:29:57 Content-Type: text/plain; charset="US-ASCII" X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: questions@freebsd.org, owner-freebsd-questions@freebsd.org 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: Fri, 03 Oct 2008 08:56:37 -0000 Hi, I suspect your password contains some illegal character for the comand line syntax. Change the password to 123 for example and test it with: mysqldump -u user -p123 --all-databases > backup.sql I suspect it will work OK, so you have to do one of the: - change password for something that does not contain any illegal in the meaning of shell scripting characters; - use quota on password line, i.e. mysqldump -u user -p'passwd' --all-databases > backup.sql Regards, Ivailo Tanusheff Deputy Head of IT Department ProCredit Bank (Bulgaria) AD Andrei Brezan Sent by: owner-freebsd-questions@freebsd.org 02.10.2008 20:49 To questions@freebsd.org cc Subject Mysqldump password issue 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 Thank you -- Andrei Brezan 310280 Arad - Romania mobile <+40 740 089 315> email www _______________________________________________ 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"