MySQL Forums
Forum List  »  Backup

mysqldump showing DATA DIRECTORY= after create table
Posted by: Chris Parker
Date: September 13, 2005 01:46PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump showing DATA DIRECTORY= after create table
3709
September 13, 2005 01:46PM


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.