First, mysqldump is a command in and of itself so it does NOT execute from within the mysql command line tool. Next, expand your command entry a bit to include your userid and password, for example:
mysqldump -uuserid -ppassword --add-drop-table mtweblog > BckUpmtweblog.sql -----Original Message----- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 4:50 PM To: mysql Subject: mysqldump error hi all, I'm a newbie to mysql. have os10.3.2 running mysql v4.0.17 am trying to dump a database called 'mtweblog' into a sql file called 'BckUpmtweblog.sql'. when i do 'mysqldump mtweblog > BckUpmtweblog.sql' from CLI it gives "Error: 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) when trying to connect". when i log into mysql and do 'mysqldump --opt mtweblog > BckUpmtweblog.sql;' it gives "Error: 1064: You have an error in your SQL syntax....." can anyone help me to dump this databse? ta tait tait sanders computer technician sir robert webster bldg trc unsw 02 9385 6802 0415 556 303 [EMAIL PROTECTED]