mysqldump showing DATA DIRECTORY= after create table

[Chris Parker]

Hello,

This is an intermittent issue that sometimes adds DATA DIRECTORY / INDEX DIRECTORY after CHARSET on the CREATE TABLE in my mysqldump.

this mysqldump runs once a day then the file is taken and loaded on another server. It breaks because of the DATA DIRECTORY/INDEX DIRECTORY -

/usr/local/mysql/bin/mysqldump -u$USER -p$PASSWORD -e -q -d dbname > test.sql

It usually occurs with the table below, but sometimes it happens on other tables.

--
-- Table structure for table `siteclosings`
--

DROP TABLE IF EXISTS `siteclosings`;
CREATE TABLE `siteclosings` (
`siteid` int(11) NOT NULL default '0',
`geoid` int(11) NOT NULL default '0',
`dateOfClosure` date NOT NULL default '0000-00-00',
`reason` char(100) default NULL,
`recordid` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 DATA DIRECTORY='./dbname/' INDEX DIRECTORY='./dbname/';
A couple of questions -
Does anyone know of any flags I can set to make so DATA DIRECTORY and INDEX DIRECTORY not appear? (I've looked through all of them and haven't found anything that could work)
And does anyone know why this is occuring.


4.1.14-standard, Mac OS 10.4.2

Thank you