|
安装完mysql后,想把mysql的datadir改为其他目录,但是更改后不能启动,如何解决?
- cp -R -p /var/lib/mysql /database/mysql
复制代码
修改/etc/conf.d/mysqld
- MYSQLD_ROOT="/database/mysql"
复制代码
修改/etc/my.cnf
- datadir = /database/mysql
复制代码
启动mysqld
- [root@yanyan ~]# /etc/rc.d/mysqld start
- :: Starting MySQL [FAIL]
复制代码
/database/mysql/yanyan.err
- 080317 09:21:58 mysqld started
- 080317 9:21:58 InnoDB: Started; log sequence number 0 43665
- 080317 9:21:58 [ERROR] bdb: /database/mysql: Permission denied
- 080317 9:21:58 [ERROR] bdb: /root/mysql/log.0000000001: Permission denied
- 080317 9:21:58 [ERROR] bdb: PANIC: Permission denied
- 080317 9:21:58 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
- 080317 9:21:58 [ERROR] bdb: fatal region error detected; run recovery
- 080317 9:21:58 [ERROR] bdb: /database/mysql: Permission denied
- 080317 9:21:58 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/database/mysql/yanyan.pid' (Errcode: 13)
- 080317 9:21:58 [ERROR] Can't start server: can't create PID file: Permission denied
- 080317 09:21:58 mysqld ended
复制代码
默认的目录可以启动,换个目录后就不能启动了,复制文件夹时加了个-p参数,权限和源目录一样的,但出错信息又说没有权限。请问怎么回事? |
|