VPS侦探论坛

 找回密码
 注册
查看: 5523|回复: 2

[Oracle] 数据库迁移提示启动失败,已经查找过常见问题和搜索相关帖子,但没效果

[复制链接]
发表于 2015-12-17 23:00:40 | 显示全部楼层 |阅读模式

设置了权限 所有者 修改了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
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
发表于 2015-12-18 11:32:09 | 显示全部楼层

回复 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过去,也可能之前丢数据了,你看看原数据库目录
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
 楼主| 发表于 2015-12-29 09:43:22 | 显示全部楼层

回复 2# 的帖子


谢谢,的确是少了东西,没有完全拷过来~
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-12-22 16:44 , Processed in 0.025521 second(s), 16 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表