备份数据库的data 然后在新的数据库中将新数据库的data设置为备份文件的data
重启MySQL 出现
InnoDB: If this error appears when you are creating an InnoDB database, InnoDB: the problem may be that during an earlier attempt you managed InnoDB: to create the InnoDB data files, but log file creation failed. InnoDB: If that is the case, please refer to InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html 131017 0:45:52 [ERROR] Plugin 'InnoDB' init function returned error. 131017 0:45:52 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed
需要重新加载innodb
需要进入data目录 删除 ib_logfile*文件