Am trying to get a database up and running after having a hard disk crash, got the data recovered.

mysql can only start with the innodb_force_recovery set as 5 or 6.

When started I can get a table listing from the schema, but attempting to select any data from tables fails with 'mysqld got signal 11 ' So cannot do a mysqldump in order to get the database re-created.

Any help appreciated, running version MySQL version 5.5.35

Here is the output from the log file when running innodb_force_recovery=6:







It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 2323726 K bytes of memory Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f7869ded2c0 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 = 7f78625b8e60 thread_stack 0x30000

















/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x10f)[0x7f7862a8ca8f] /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1e81)[0x7f7862a8e9e1]





Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

Query (7f7768004b80): is an invalid pointer

Connection ID (thread ID): 5


The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 140224 10:21:33 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.

140224 10:21:33 [Note] Plugin 'FEDERATED' is disabled.

140224 10:21:33 InnoDB: The InnoDB memory heap is disabled

140224 10:21:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins

140224 10:21:33 InnoDB: Compressed tables use zlib

140224 10:21:33 InnoDB: Initializing buffer pool, size = 2.9G

140224 10:21:33 InnoDB: Completed initialization of buffer pool

140224 10:21:33 InnoDB: highest supported file format is Barracuda.

InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on

InnoDB: Skipping log redo

140224 10:21:33 InnoDB: Waiting for the background threads to start

140224 10:21:34 InnoDB: 5.5.35 started; log sequence number 0

140224 10:21:34 InnoDB: !!! innodb_force_recovery is set to 6 !!!

140224 10:21:34 [Note] Server hostname (bind-address): ''; port: 3306

140224 10:21:34 [Note] - '' resolves to '';

140224 10:21:34 [Note] Server socket created on IP: ''.

140224 10:21:34 [Warning] 'user' entry 'xx@xxx' ignored in --skip-name-resolve mode.

140224 10:21:34 [Warning] 'user' entry 'xx@xxx' ignored in --skip-name-resolve mode.

140224 10:21:34 [Warning] 'proxies_priv' entry '@ xx@xxx' ignored in --skip-name-resolve mode.

140224 10:21:34 [Note] Event Scheduler: Loaded 0 events

140224 10:21:34 [Note] /usr/sbin/mysqld: ready for connections.

Version: '5.5.35-0ubuntu0.12.04.2-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)


1 Answer 1


Dump as many tables with mysqldump as it allows:

  mysqldump --skip-lock-tables <database> <table> > <database>.<table>.sql

The remaining tables recover with Data Recovery Tool for InnoDB . Basically you need to fetch records from the tables so you can reload them into a fresh InnoDB instance

Not the answer you're looking for? Browse other questions tagged or ask your own question.