I use MySQL AB released win32 binary package. i don't know if it used --skip-symlink option. And after I added an entry skip-symlink=false in my.cnf, I can't start mysqld unfortunately.
-Ares On 02 Jun 2003 14:15 CST you wrote: > >From the Manual: > By using DATA DIRECTORY="directory" or INDEX DIRECTORY="directory" you can > specify where the storage engine should put it's table and index files. Note > that the directory should be a full path to the directory (not relative path). > This only works for MyISAM tables in MySQL 4.0, when you are not using > the --skip-symlink option. > > Make sure that option is set correctly. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Ares Liu" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, 02 June, 2003 16:03 > Subject: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES > > > HI, ALL > > Under windows XP, mysql-4.0.12, when I create a table with special data and > index directories as follow: > > USE DATABASE test; > > CREAT TABLE IF NOT EXISTS test_table ( Vola INT NOT NULL, PRIMARY KEY (Vola)) > DATA DIRECTORY="D:/mySQLDBs/test/data" > INDEX DIRECTORY="D:/mySQLDBs/test/index"; > > It show test_table created successfully in mysql client. > But really, mysqld creats table test_table with three table files > test_table.frm, test_table.MYD, and test_table.MYI in D:\mySQLDBs directory. In > addition, I defined "datadir=d:/mySQLDBs" in my.cnf. > > Who can tell me why this happened? And how can I put the data file and index > file to where I want to allocate without links. > > -Ares > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
