my MySQL server just crashed and I cannot restart/recover it. I've tried:
/etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
mysqld --verbose --innodb_force_recovery=4 120528 18:44:28 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead. 120528 18:44:28 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 120528 18:44:28 [Note] Plugin 'FEDERATED' is disabled. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 120528 18:44:29 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... Killed
both (as you can see) without success.
I've checked log files at
/var/log/mysql.log but they are all empty. I don't have any other ideas. Any suggestions?