mysql版本:5.1.34
操作系统:centos5-64
mysql安装目录:/datamkdir -p /disk0/data
mkdir -p /disk0/idx
chown -R mysql.mysql /disk0CREATE TABLE ts (id INT, purchased DATE)
PARTITION BY list(YEAR(purchased))
(PARTITION p0 VALUES in (1990)
DATA DIRECTORY = '/disk0/data'
INDEX DIRECTORY = '/disk0/idx'
)
这样是成功的.
=========================================================
mkdir -p /data/disk0/data
mkdir -p /data/disk0/idx
chown -R mysql.mysql /data/disk0CREATE TABLE ts (id INT, purchased DATE)
PARTITION BY list(YEAR(purchased))
(PARTITION p0 VALUES in (1990)
DATA DIRECTORY = '/data/disk0/data'
INDEX DIRECTORY = '/data/disk0/idx'
)
始终不成功:
Error Code : 1210
Incorrect arguments to DATA DIRECTORY
(0 ms taken)这是为什么呢?难道就是不能指定在安装目录下吗?大家帮我一起看看好吗?先谢谢了.
操作系统:centos5-64
mysql安装目录:/datamkdir -p /disk0/data
mkdir -p /disk0/idx
chown -R mysql.mysql /disk0CREATE TABLE ts (id INT, purchased DATE)
PARTITION BY list(YEAR(purchased))
(PARTITION p0 VALUES in (1990)
DATA DIRECTORY = '/disk0/data'
INDEX DIRECTORY = '/disk0/idx'
)
这样是成功的.
=========================================================
mkdir -p /data/disk0/data
mkdir -p /data/disk0/idx
chown -R mysql.mysql /data/disk0CREATE TABLE ts (id INT, purchased DATE)
PARTITION BY list(YEAR(purchased))
(PARTITION p0 VALUES in (1990)
DATA DIRECTORY = '/data/disk0/data'
INDEX DIRECTORY = '/data/disk0/idx'
)
始终不成功:
Error Code : 1210
Incorrect arguments to DATA DIRECTORY
(0 ms taken)这是为什么呢?难道就是不能指定在安装目录下吗?大家帮我一起看看好吗?先谢谢了.
解决方案 »
- mysql问题--mysqld-nt.exe错误
- 一个查询,有没有好的想法
- 这个存储过程错在哪里??
- 求助#1064 - You have an error in your SQL syntax; check the manual that correspond
- 关于实现mysql监控平台的一问题
- linux下postgresql-8.3.8-1-linux-x64.bin安装求教
- 怎样快速获得mysql 表大小问题
- mysql auto_increment 字段怎样回到 1 的状态。
- 请教一个关于异常的问题
- 请问如何使用VBA直接操作远程Linux主机上的Mysql数据库?
- 一道sql查询语句问题,想了老半天了,能人来看下!
- 任务计划中,插入的数据异常
Beginning with MySQL 5.1.24, you cannot use path names that contain the MySQL data directory with DATA DIRECTORY or INDEX DIRECTORY. This includes partitioned tables and individual table partitions. 非常遗憾的是中文版的帮助文档中没有翻这一句。