mysql 迁移数据目录 5.6

原先一台数据库未安装Innodb引擎，今天动态增加他，发现innodb加载不了，报错Plugin 'InnoDB' registration as a STORAGE ENGINE failed，从详细日志里面发现创建log file创建失败。详细日志如下：

1 2 3 4 5 6 7

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，后来卸掉了，但是logfile文件没有删除，导致从新加载的时候出现这个问题。解决方法很简单

rm -rf ib_logfile*

然后重新动态加载一次innodb即可，如果不行，那么重启一下mysql.

 

/bin/sh /usr/bin/mysqld_safe --datadir=/mnt/install/mysql/data/mysql --pid-file=/mnt/install/mysql/data/mysql/iZ25eto049qZ.pid --socket=/mnt/install/mysql/data/mysql/mysql.sock --explicit_defaults_for_timestamp &


mysql  迁移数据 cp -arp/var/lib/mysql /home/data/mysql/   
说明
1、关闭mysql 服务 service mysql stop，迁移目录 cp -arp/var/lib/mysq /home/data/mysql/
2、修改/usr/my.cnf

datadir =/mnt/install/mysql/data/mysql
socket =/mnt/install/mysql/data/mysql/mysql.sock
3、修改 vim /etc/init.d/mysql   修改项
datadir=/mnt/install/mysql/data/mysql
3、service mysql start

如果要用本地 进入 mysql -u root -p --socket=/mnt/install/mysql/data/mysql/mysql.sock


#安装新库
/usr/local/mysql/scripts/mysql_install_db -–defaults-file=/data/mysql/my.cnf --basedir=/usr/local/mysql --datadir=/data/mysql/data --user=mysql