MySQLDump - adding data directories at random

[Paul O'Connor]

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