>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]
