Database RESTORE

Anon

Win2k

I have made a COPY of the database files in the data directory.

I moved them to another server - same directory.

When I access with Mascon (my gui program)I can see the tables, but when I try to access it says it cannot find the file table.myd.

What do I need to do to get mysql to recognize this database

[deleted]

Firstly, you should't copy database by copying datafiles. This is a mysql trick that once again proves how crap mysql is.
Use mysqldump to create a proper backup of your data, and restore that backup on your target machine.

As for your current problem, did you stop the source mysql server before you copied the files, and did you stop the target server before you added the files? If not, try again but stop the servers before you copy/insert the files.

A forum, a FAQ, email notification, what else do you need?