VPS侦探论坛

标题: 数据库迁移提示启动失败，已经查找过常见问题和搜索相关帖子，但没效果 [打印本页]

作者: helloLC 时间: 2015-12-17 23:00
标题: 数据库迁移提示启动失败，已经查找过常见问题和搜索相关帖子，但没效果
设置了权限所有者修改了my.cnf  里的datadir、 innodb_data_home_dir、 innodb_log_group_home_dir
启动提示  Starting MySQL.....The server quit without updating PID fil[FAILED]
错误日志：
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 [ERROR] 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:52  InnoDB: Waiting for the background threads to start
151217 22:04:53 InnoDB: 1.1.8 started; log sequence number 1595675
151217 22:04:53 [Note] Recovering after a crash using mysql-bin
151217 22:04:53 [Note] Starting crash recovery...
151217 22:04:53 [Note] Crash recovery finished.
151217 22:04:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151217 22:04:53 [Note] - '0.0.0.0' resolves to '0.0.0.0';
151217 22:04:53 [Note] Server socket created on IP: '0.0.0.0'.
151217 22:04:53 [ERROR] 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

作者: licess 时间: 2015-12-18 11:32
标题: 回复 1# 的帖子
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
可能是文件没有完全cp过去，也可能之前丢数据了，你看看原数据库目录

作者: helloLC 时间: 2015-12-29 09:43
标题: 回复 2# 的帖子
谢谢，的确是少了东西，没有完全拷过来~

欢迎光临 VPS侦探论坛 (https://bbs.lnmp.com/)