错误日志如下: 2017-11-27 21:54:45 8432 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2017-11-27 21:54:45 8432 [Note] InnoDB: The InnoDB memory heap is disabled 2017-11-27 21:54:45 8432 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2017-11-27 21:54:45 8432 [Note] InnoDB: Memory barrier is not used 2017-11-27 21:54:45 8432 [Note] InnoDB: Compressed tables use zlib 1.2.3 2017-11-27 21:54:45 8432 [Note] InnoDB: Not using CPU crc32 instructions 2017-11-27 21:54:45 8432 [Note] InnoDB: Initializing buffer pool, size = 64.0M 2017-11-27 21:54:45 8432 [Note] InnoDB: Completed initialization of buffer pool 2017-11-27 21:54:45 8432 [Note] InnoDB: Highest supported file format is Barracuda. 2017-11-27 21:54:45 8432 [Note] InnoDB: The log sequence numbers 1625886 and 1625886 in ibdata files do not match the log sequence number 1625916 in the ib_logfiles! 2017-11-27 21:54:45 8432 [Note] InnoDB: Database was not shutdown normally! 2017-11-27 21:54:45 8432 [Note] InnoDB: Starting crash recovery. 2017-11-27 21:54:45 8432 [Note] InnoDB: Reading tablespace information from the .ibd files... 2017-11-27 21:54:45 8432 [Note] InnoDB: Restoring possible half-written data pages 2017-11-27 21:54:45 8432 [Note] InnoDB: from the doublewrite buffer... 2017-11-27 21:54:45 8432 [Note] InnoDB: 128 rollback segment(s) are active. 2017-11-27 21:54:45 8432 [Note] InnoDB: Waiting for purge to start 2017-11-27 21:54:45 8432 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1625916 2017-11-27 21:54:46 5572 [Note] InnoDB: Dumping buffer pool(s) not yet started 2017-11-27 21:54:46 8432 [Note] Plugin 'FEEDBACK' is disabled. 2017-11-27 21:54:46 8432 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded 2017-11-27 21:54:46 8432 [Note] Recovering after a crash using tc.log 2017-11-27 21:54:46 8432 [Note] Starting crash recovery... 2017-11-27 21:54:46 8432 [Note] Crash recovery finished. 2017-11-27 21:54:46 8432 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2017-11-27 21:54:46 8432 [Note] Server socket created on IP: '::'. 2017-11-27 21:54:46 8432 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 已经验证: 3306端口使用cmd命令查看,为空白状态 用其他电脑测试正常启动会有以下状态, 电脑内存足够(内存八g),不存在内存占用不足; my.ini配置,官网下载,原装软件,没有修改过. 数据表缺失或出错;没有对数据库的数据做任何修改..都是空白的 本问题困扰我很长时间了,麻烦论坛里面大佬提提建议,有没有解决问题的思路.. |
|
板凳#
发布于:2017-11-28 07:26
核心的user表都丢了肯定无法启动,你对数据库升级过还是data目录下有副本形式备份文件夹?
|
|