----- Original Message ----- From: "David & Angela Ehmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 11:00 PM Subject: mysqldump ERROR 1064
> Hi > > I am having problems generating the mysqldump file. I have tried a range of > options and carefully studied several tutorials I have on using this > command. Each time I get the following errror. > > ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p > adrienne netno_db >sql.dump' at line 1. > > I appear to have other problems with some commands. For example if I type; > > mysqladmin --help > > at the command line I get the 1064 ERROR > > Appreciate any suggestions about what may be the problem here > > David > It looks like you're trying to run the mysqldump and mysqladmin commands from within the mysql client rather than from the shell's command line. Quit out of the mysql client and try running them from the command line. And when you specify the -p password on the command line, do not include a space between the -p and the password. Try instead: mysqldump -u root -padrienne netno_db >sql.dump Best regards, Bruce --------------------------------------------------------------------- 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
