By accident, I have deleted the
ibdata1 file in the MySQL directory because MySQL wasn't functioning correctly.
After reading so many forums, I found a post that recommended deleting the 3 files
ibdata1 from the MySQL directory to let InnoDB load again and MySQL come up. And this what I have did.
But now when InnoDB loads as engine the tables disappear.
After I do a graceful restart, InnoDB disappears totally from the server (
"have_innodb | No"). But I can see all tables again for databases using InnoDB.
What I'm looking for is a way to load all the tables correctly than ask ibdata to state them as InnoDB then let the InnoDB engine function correctly.