Errorcode 13 indicates that there is a permissions error of some sort. I'd double check that the mysql user/group own the data directories on the new machine. I've also found that setting up the new database on the new server helps before loading data to it. For example: mysqldump -uuser -ppassword --no-data mtweblog > mtweblog.ddl mysql -uuser -ppassword < mtweblog.ddl mysql -uuser -ppassword < bkupmtweblog.sql
-----Original Message----- From: tait sanders [mailto:[EMAIL PROTECTED] Sent: Sunday, March 21, 2004 5:13 PM To: [EMAIL PROTECTED] Cc: mysql Subject: Re: mysqldump error 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]
