I transfer the databases of my old vps to new vps.
All mysql databases work fine, except one. PHPmyadmin does not show all the tables in that database, although / var / lib / myql / dbname contains all the files in the database.
I tried to repair db:
myisamchk -r /var/lib/mysql/dbname/*.MYI but shows an error for many tables
myisamchk: error: 140 when opening the MyISAM table & # 039; /var/lib/mysql/dbname/tablename.MYI'