数据库迁移提示启动失败，已经查找过常见问题和搜索相关帖子，但没效果
设置了权限 所有者 修改了my.cnf里的datadir、 innodb_data_home_dir、 innodb_log_group_home_dir启动提示Starting MySQL.....The server quit without updating PID fil
错误日志：
151217 22:04:52 mysqld_safe Starting mysqld daemon with databases from /wwq/mysql
/usr/local/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
151217 22:04:52 Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
151217 22:04:52 InnoDB: The InnoDB memory heap is disabled
151217 22:04:52 InnoDB: Mutexes and rw_locks use GCC atomic builtins
151217 22:04:52 InnoDB: Compressed tables use zlib 1.2.3
151217 22:04:52 InnoDB: Initializing buffer pool, size = 16.0M
151217 22:04:52 InnoDB: Completed initialization of buffer pool
151217 22:04:52 InnoDB: highest supported file format is Barracuda.
151217 22:04:52InnoDB: Waiting for the background threads to start
151217 22:04:53 InnoDB: 1.1.8 started; log sequence number 1595675
151217 22:04:53 Recovering after a crash using mysql-bin
151217 22:04:53 Starting crash recovery...
151217 22:04:53 Crash recovery finished.
151217 22:04:53 Server hostname (bind-address): '0.0.0.0'; port: 3306
151217 22:04:53 - '0.0.0.0' resolves to '0.0.0.0';
151217 22:04:53 Server socket created on IP: '0.0.0.0'.
151217 22:04:53 Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
151217 22:04:53 mysqld_safe mysqld from pid file /wwq/mysql/SZCLGYJ-5380.pid ended
回复 1# 的帖子
Can't open the mysql.plugin table. Please run mysql_upgrade to create it.Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
可能是文件没有完全cp过去，也可能之前丢数据了，你看看原数据库目录
回复 2# 的帖子
谢谢，的确是少了东西，没有完全拷过来~:handshake
页:
[1]