Ares Liu <[EMAIL PROTECTED]> wrote: > > 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.
DATA DIRECTORY and INDEX DIRECTORY is ignored on Windows. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]