i transferred databases from my old vps to new vps. All mysql databases work fine except one. PHPmyadmin doesn't show all tables of that database, although /var/lib/myql/dbname contains all files of database. i tried to repair db: myisamchk -r /var/lib/mysql/dbname/*.MYI but shows error for lot of tables myisamchk: error: 140 when opening MyISAM-table '/var/lib/mysql/dbname/tablename.MYI'
Hi. Try running the database in recovery mode and copy all the data into new tables. It will be helpful for you to know that there are 6 different levels of recovery mode. May be you need try different levels to run the database successfully.