Mysql启动后丢表

youarepp 发布于 2015/07/01 09:49
阅读 151
收藏 0

由于非正常的关掉了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.

加载中
0
Feng_Yu
Feng_Yu
这些都是正常信息,根本没有报错。先不要心慌,看到日志输出就以为是报错
0
y
youarepp
那这些表怎么找回来呢
返回顶部
顶部