Re: mysqldump error

[tait sanders]

thanks  - i ran the command below and it worked. and now I'm trying to 
import using:
'mysql -u root -p mtweblog < Bckupmtweblog.sql' on CLI on different 
machine and am getting "Error 1 at line 11: Can't create/write to 
file'./mtweblog/mt_author.frm' Errorcode 13".

any suggestions here?

tait

On 22/03/2004, at 10:15 AM, [EMAIL PROTECTED] wrote:

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?


tait sanders
computer technician
sir robert webster bldg
trc
unsw
02 9385 6802
0415 556 303
[EMAIL PROTECTED]