2
回答
Mysql启动后丢表
百度AI开发者大赛带你边学边开发,赢100万奖金,加群:418589053   

由于非正常的关掉了MYSQL的进程,后来起来后发现有些表看不到了,然后到数据库的对应目录看发现对应的frm,ibd文件都还在,查看了mysql的异常日志报了以下错误,网上找了各种方法都没办法找回表,这个有谁碰到过吗,急啊

2015-07-01 09:26:16 2590 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-01 09:26:16 2590 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2015-07-01 09:26:16 2590 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-01 09:26:16 2590 [Note] InnoDB: CPU does not support crc32 instructions
2015-07-01 09:26:16 2590 [Note] InnoDB: Using Linux native AIO
2015-07-01 09:26:16 2590 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-07-01 09:26:16 2590 [Note] InnoDB: Completed initialization of buffer pool
2015-07-01 09:26:16 2590 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-01 09:26:16 2590 [Note] InnoDB: 128 rollback segment(s) are active.
2015-07-01 09:26:16 2590 [Note] InnoDB: 1.2.10 started; log sequence number 563213533
2015-07-01 09:26:16 2590 [Note] Server hostname (bind-address): '*'; port: 3306
2015-07-01 09:26:16 2590 [Note] IPv6 is not available.
2015-07-01 09:26:16 2590 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
2015-07-01 09:26:16 2590 [Note] Server socket created on IP: '0.0.0.0'.
2015-07-01 09:26:16 2590 [Note] Event Scheduler: Loaded 2 events
2015-07-01 09:26:16 2590 [Note] /usr/sbin/mysqld: ready for connections.

举报
youarepp
发帖于3年前 2回/151阅
顶部