Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 3 Oct 2008 11:29:52 +0300
From:      Ivailo Tanusheff <i.tanusheff@procreditbank.bg>
To:        Andrei Brezan <andrei693@gmail.com>
Cc:        questions@freebsd.org, owner-freebsd-questions@freebsd.org
Subject:   Re: Mysqldump password issue
Message-ID:  <OF99519288.1C66FA6F-ONC22574D7.002E4A44-C22574D7.002EAEDA@procreditbank.bg>
In-Reply-To: <48E500EC.9010100@gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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 <andrei693@gmail.com> 
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 <andrei@bsoft-company.ro>
www <http://www.bsoft-company.ro/>;
_______________________________________________
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"




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?OF99519288.1C66FA6F-ONC22574D7.002E4A44-C22574D7.002EAEDA>