At 10:12 +1100 3/22/04, tait sanders wrote:
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
% perror 13
Error code 13: Permission denied
This typically indicates that the server doesn't have permission to write
to its own data directory. Make sure the data directory and its files
and subdirectories have their permissions set to allow full access to
the login account that you're using to run the server.
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?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]