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]
