MySQL Forums
Forum List  »  Backup

MySQLDump - adding data directories at random
Posted by: Paul O'Connor
Date: January 04, 2006 11:36AM

Hello,

I'm running MySQL version 4.1.7 on w2k3.
I have a database with 100 or so tables in it and am using mysqldump to create backups.

All of the tables are of type MyISAM.
In the create statements generated by mysqldump there are 5 tables that sometimes (yes sometimes) have the create statement ending with:

ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='E:\Program Files\MySQL\MySQL Server 4.1\Data\dbname\' INDEX DIRECTORY='E:\Program Files\MySQL\MySQL Server 4.1\Data\dbname\';

the rest of the table creates end like this:

ENGINE=MyISAM DEFAULT CHARSET=latin1;

The syntax I use is pretty straight forward - mysqldump --opt dbname > path-to-backup.sql

The reason I even noticed this is because when I try to read in the file from the mysql client I get errors that correspond to the backslashes in the directory paths:

ERROR:
Unknown command '\P'.
ERROR:
Unknown command '\M'.
ERROR:
Unknown command '\M'.
ERROR:
Unknown command '\D'.

I've gone through the process of re-creating the affected tables from scratch (without the data and index directories in the create statement) and running mysqldump several times, and there were always at least 3 of the same 5 that come back with the data directories listed in the create statement.

Can anyone offer any suggestions as to what I can try to make sure the data directories don't get listed in the backups generated by mysqldump?

Thanks,
Paul

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQLDump - adding data directories at random
4642
January 04, 2006 11:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.