RE: mysqldump question (very basic)
Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? thanks = It returns help whenever it doesn't understand what you're asking it to do (or if your command is incomplete.) The following line works to backup a remote database to a local PC - Running the same version of MySQL both places, and a user is setup on the MySQL server that allows remote read (IP-restricted in my case, but I have a fixed IP): c:/mysql/bin/mysqldump -h www.mydomain.com -u UserID -pPassword --add-drop-table MyDBName c:/ServerDumps/MyDBName.sql I run a batch job with one of these for every database every day. Hope that gets you started! Jay Fesco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump question (very basic)
Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? thanks = __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump question (very basic)
At 12:11 PM -0700 9/10/01, Gene Gurevich wrote: Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? If you're really entering the option as -databases, try --databases. Otherwise, check whether your version of MySQL is older than 3.23.12, which is when this option was added. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php