mysql启动提示以下出错信息:
110118 09:37:12 mysqld started
110118 9:37:13 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
InnoDB: File name /usr/local/mysql/var-ccms-all/ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
110118 09:37:13 mysqld ended
解决方法:
1.mysql数据库目录位于
[root@SHF_CCMSBAK_ALL var-ccms-all]# pwd
/var/lib/mysql/var-ccms-all
2.但数据库配置为以下:
[mysqld2]
port = 3307
socket = /tmp/mysql-ccms-all.sock
pid-file = /var/lib/mysql/var-ccms-all/mysql.pid
datadir = /var/lib/mysql/var-ccms-all
auto_increment_offset = 2
auto_increment_increment = 2
relay-log=/usr/local/mysql/var-ccms-all/relay-binlog
relay-log-index=/usr/local/mysql/var-ccms-all/relay-log-index
relay-log-info-file=/usr/local/mysql/var-ccms-all/relay-log.info
innodb_data_home_dir = /usr/local/mysql/var-ccms-all/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var-ccms-all/
innodb_log_arch_dir = /usr/local/mysql/var-ccms-all/
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 512M
innodb_data数据目录与数据库根目录不一致,造成目录读取权限有问题,不能成功创建文件,所以启动数据库失败!!
修改成一致后,问题解决,成功启动!
评论