Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

MySql server can display all the tables with MyISAM engines but cannot able to display the tables with INNODB engines, but if I can make the tables with INNODB engines it can still show that tables, but it is unable to show already made tables with INNODB engines?

share|improve this question

Look at your .err log, as it's most likely some type of table space corruption.

The location of the log file is specified via two methods. The first is at run time with --log-error=filename, which would often be specified in your init file. More commonly, it would be specified in your my.cnf with log-error. Ultimately if left unset, it defaults to the data directory as your hostname.err.

Search the filesystem for a file with the extension of .err. Chances are, you'll find the log.

find / -name '*.err'
locate .err | egrep '.err$'
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.