Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

After a server reboot I noticed that phpMyAdmin was not showing my innodb tables, just the myisam.

I logged into mysql server directly and while show tables is showing the innodb tables, when I use 'show table status from mydb' the inndb tables are not there.

Any reason why they're suddenly not showing? The did before the reboot.

Also, they show in 'show tables' but trying to do a select says they don't exist.

share|improve this question
    
Can you copy paste the outputs? either here or post it on pastebin and link it here. –  Anand Jeyahar Apr 26 '11 at 21:05
    
egads...made a typo in my innodb_data_home_dir that only appeared when the reboot happened. facepalm –  Ian Apr 26 '11 at 22:05
add comment

1 Answer

up vote 0 down vote accepted

The first query you should run is SHOW ENGINES;

If the Support Column for InnoDB says DISABLED, then mysqld.log should tell what disabled it.

SHOW TABLES most likely traverses only INFORMATION_SCHEMA.TABLES

Once you try to ascertain info about InnoDB tables which requires hitting the ibdata1 file for metadata, it croaks and cannot find any InnoDB tables. I remember one time asking for too much InnoDB Buffer Pool and I did not have enough memory. Percona binaries are more blunt in this because mysqld simply won't start. That's a whole lot better than starting MySQL in a half-baked state.

Next time InnoDB seems to be on the fritz, run SHOW ENGINES right away and check the error log !!!

share|improve this answer
add comment

Your Answer

 
discard

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

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