我把另一块硬盘挂载到/mnt/c上,想把数据直接存储在这块硬盘上。然后修改my.cnf中的innodb_data_home_dir=/mnt/c,结果service mysql start 就失败了;我也试过把/var/lib/mysql下面的所有文件转移到/mnt/c下面,但是仍然无法启动。而如果不修改innodb_data_home_dir,mysql就可以启动,请问该怎么样解决这个问题?谢谢!!
...全文
4284打赏收藏
修改了innodb_data_home_dir后,mysql无法启动,请问该怎样解决?
我把另一块硬盘挂载到/mnt/c上,想把数据直接存储在这块硬盘上。然后修改my.cnf中的innodb_data_home_dir=/mnt/c,结果service mysql start 就失败了;我也试过把/var/lib/mysql下面的所有文件转移到/mnt/c下面,但是仍然无法启动。而如果不修改innodb_data_home_dir,mysql就可以启动,请问该怎么样解决这个问题?谢谢!!
看日志是这样的
061108 22:56:48 mysqld started
061108 22:56:48 [Warning] Asked for 196608 thread stack, but got 126976
061108 22:56:48 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name /home/happia/innodb/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
061108 22:56:48 mysqld ended