Re: DATA/INDEX DIRECTORY on Windows

[Ronald Rudy]

Jon Stephens Wrote:
-------------------------------------------------------
> Perhaps it's the space characters? Try using
> directory paths that don't include spaces. If that
> solves the problem, please file a bug.


Still a problem:

mysql> create table testp
    -> (
    ->   id int primary key auto_increment,
    ->   value varchar(255)
    -> )
    -> partition by hash(id)
    -> (
    ->   partition p0
    ->     data directory = 'D:/partitiontest/data/testdb'
    ->     index directory = 'E:/partitiontest/indexes/testdb'
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql> insert into testp (value) values ('xyz');
ERROR 1017 (HY000): Can't find file: 'testp' (errno: 2)