当我在mysql8.0中用分区和数据目录创建表时，发生了错误：错误1525(HY 000)：路径值不正确：'/var/lib/mysql/p1'

9udxz4iz 于 2023-03-22 发布在 Mysql

关注(0)|答案(1)|浏览(98)

CREATE TABLE employees1 (

    id INT NOT NULL auto_increment ,

    name varchar(128),

    primary key(id)

) ENGINE=INNODB  

    PARTITION BY LIST(id%10)(

    PARTITION p1 VALUES IN (0,1,2,3,4)

    INDEX DIRECTORY = '/var/lib/mysql/p1'

    DATA DIRECTORY = '/var/lib/mysql/p1',

    PARTITION p2 VALUES IN (5,6,7,8,9)

    INDEX DIRECTORY = '/var/lib/mysql/p2'

    DATA DIRECTORY = '/var/lib/mysql/p2'

);

正确的路径值是多少？

mysql

来源：https://stackoverflow.com/questions/75776608/when-i-create-table-in-mysql8-0-with-partition-and-data-directory-the-error-ha