maridb10 出错 InnoDB: read can't be opened in .\ibdata1 mode 解决

 

虚拟机拷贝后， maridb10 服务无法启动出现如下错误

140621 12:42:26 [Note] InnoDB: The InnoDB memory heap is disabled
140621 12:42:26 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
140621 12:42:26 [Note] InnoDB: Compressed tables use zlib 1.2.3
140621 12:42:26 [Note] InnoDB: CPU does not support crc32 instructions
140621 12:42:26 [Note] InnoDB: Initializing buffer pool, size = 128.0M
140621 12:42:26 [Note] InnoDB: Completed initialization of buffer pool
140621 12:42:26 [ERROR] InnoDB: read can't be opened in .\ibdata1 mode
140621 12:42:26 [ERROR] InnoDB: The system tablespace must be writable!
140621 12:42:26 [ERROR] Plugin 'InnoDB' init function returned error.
140621 12:42:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140621 12:42:26 [ERROR] mysqld.exe: File 'd:\mariadb-10.0.6-win32\db\aria_log_control' not found (Errcode: 13 "Permission denied")
140621 12:42:26 [ERROR] mysqld.exe: Got error 'Can't open file' when trying to use aria control file 'd:\mariadb-10.0.6-win32\db\aria_log_control'
140621 12:42:26 [ERROR] Plugin 'Aria' init function returned error.
140621 12:42:26 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
140621 12:42:26 [Note] Plugin 'FEEDBACK' is disabled.
140621 12:42:26 [ERROR] Unknown/unsupported storage engine: InnoDB
140621 12:42:26 [ERROR] Aborting

使用mysqld remove ,然后重新添加 mysqld --install mysql --defaults-file="d:\mariadb-10.0.6-win32\db\my.ini" 仍然出错
删除 ..\db\ib_logfile  同样出错

使用 mysql_install_db.exe --datadir=d:\mariadb-10.0.6-win32\db --service=mydb --password=infosea 

解决问题

 

D:\mariadb-10.0.6-win32\bin>net start mysql
The mysql service is starting...
The mysql service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

D:\mariadb-10.0.6-win32\bin>del ..\db\ib_logfile0

D:\mariadb-10.0.6-win32\bin>del ..\db\ib_logfile1

D:\mariadb-10.0.6-win32\bin>net start mysql
The mysql service is starting...
The mysql service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

D:\mariadb-10.0.6-win32\bin>mysql_install_db.exe --datadir=d:\mariadb-10.0.6-win
32\db --service=mydb --password=infosea
Running bootstrap
Removing default user
Setting root password
Creating my.ini file
Registering service 'mydb'
Creation of the database was successfull
D:\mariadb-10.0.6-win32\bin>net start mydb
The mydb service is starting.
The mydb service was started successfully.

D:\mariadb-10.0.6-win32\bin>