Import MySQL DAtabase from Data Files

I've g开发者_如何学Pythonot the MySQL data files from an old server which has now crashed so I can not login to the server to do mysqldump etc. I am now trying to load the data on a new server. The only option I have is to copy/paste the data files that I have. But when I do so, some of the database tables throw this error "Table does not exist" when I can see it in my Navicat Window. The problem is only with some of the tables, not all.

My question is, how can I fix this error ? Or is there another way to import the data from data files?

---

The best piece of advice that comes to my mind is running a myisamchk on the respective table(s), paying special attention to the repair options.

Be sure to make backups of the data files beforehand.

Additional thoughts:

• Make sure you have restarted the database server after adding the data files.

• Are you sure you are addressing the correct table(s)? Note that on most Linux filesystems, the table name is case sensitive (as it's reflected by a file in the filesystem). So tablename != Tablename