10

I'm completely lost as to how or why this error is displaying when I go to browse the table data.

The one thing I did notice was that the Storage Engine has been switched to MyISAM with InnoDB saying it has been disabled.

I'm waiting to hear back from the hosting company but is there something I can explore until I hear back from them?

The sql should have been backed up on the server but when I download it, the file is empty.

Any tips on accessing this data is very much appreciated.

warr0032
  • 135
  • 1
  • 1
  • 7

3 Answers3

4

Sounds like your host may have disabled InnoDB, which will make any existing InnoDB tables unusable. They may also have accidentally destroyed the InnoDB data file.

Either way, there's nothing you can do yourself to recover it.

  • Duskwuff - you were absolutely correct. That's exactly what happened. Thankfully the data wasn't destroyed once they enabled InnoDB. – warr0032 Mar 18 '12 at 19:59
  • Phew! Now it's time to find a web host that won't do horrific things like that. :) –  Mar 18 '12 at 21:09
  • Mostly this happens when mysqld was killed by the kernel's out of memory killer, and after immediate restart there will be not enough free memory to launch the InnoDB engine. Solution: restart mysqld with enough free memory and run `mysqlcheck -r` on all that tables. – hek2mgl Sep 11 '14 at 11:03
1

Come to /etc/my.cnf an change config to

max_connections = 2500
query_cache_limit = 2M
query_cache_size = 150M
tmp_table_size = 200M
max_heap_table_size = 300M
key_buffer_size = 300M
tmpdir = /dev/shm

Run command: service mysqld restart

check again, Good luck

user3523326
  • 11
  • 1
0

Just try to restart mysql. It helped me fix the problem

Sudheesh.M.S
  • 498
  • 1
  • 7
  • 13