I had problem starting innodb and read somewhere that deleting ib_logfile0,ib_logfile1 files works. It worked and mysql started again and when I use "Show tables" it shows all tables of my database but when I run the
"Select * from db1.table1"
it says that table does not exists.
Would you help me ? the database file still exist at "/var/lib/mysql"
Best Answer
You just deleted datafiles for your DB. MySQL has structure of DBs and data in separated files. Your database left with structure files (so it know about databases and tables) but your data are gone. You have to restore your database from backup.
Good to know for next try - you should validate anything from the Internet with documentation of your software to avoid running destructive opperation and keep your data safe.