我在安装了 nginx、mysql 和 unicorn 的 Ubuntu 12.10 服务器上工作。Mysql 出现问题并且已停止工作。
记录消息来自/var/log/mysql/error.log
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x30000
mysqld(my_print_stacktrace+0x33)[0xb725de53]
mysqld(handle_fatal_signal+0x48c)[0xb710255c]
[0xb6dd0400]
mysqld(+0x5e4d72)[0xb73d7d72]
mysqld(+0x5cfc3b)[0xb73c2c3b]
mysqld(+0x5d15ba)[0xb73c45ba]
mysqld(+0x57107d)[0xb736407d]
mysqld(+0x59aa9d)[0xb738da9d]
mysqld(+0x52b0b0)[0xb731e0b0]
/lib/i386-linux-gnu/libpthread.so.0(+0x6d4c)[0xb6db2d4c]
/lib/i386-linux-gnu/libc.so.6(clone+0x5e)[0xb6b56d3e]
任何帮助都值得赞赏，提前致谢:)
答案1
我通过启用innodb_force_recovery = 6来启动mysql my.conf。由于mysql服务已启动，我创建了一个转储文件，在本地运行并成功恢复了丢失的数据。