How to attach/restore MySQL database copy?

Question

I need to convert a MySql Database to SQL server. I received the database in a zip file containing only *.frm, *.MYI and *.MYD. Im not familiar with MySQL. I downloaded and installed version 5.1 server and tools. I copied that folder containing the files to the folder where the other databases are located. Using MySql administrator, in CATALAGS-DATABASENAME->SCHEMA TABLES, I can see the tables listed. Some are in red and a message "incorrect key file for table 'xxxxxxxx', try to repair it. I already tried to repair some of the tables and a message stating the table is corrupt appears. I don't know if the client just copy the tables from the folder or used and "Detach"/"Backup" procedure. I'm familiar with SQL server and I know that if you just copy a MDF/LDF with out detaching it first, most likely will not work. Is this the case here?

Thanks in advance.

Answer 1

My question, which echoes yours, was recently answered at ServerFault, the sister web site of StackOverflow targeted at system admin questions versus actual programming questions. I understand that programmers also need to administer databases, but if we all direct our questions to the appropriate site, not only do we as the askers of questions benefit, but also others who may have the same question, but have never been involved in programming.

Plus, you get 100 free rep for associating your SO account with your SF account.

The answer to my question, and maybe yours, is over here: http://serverfault.com/questions/68146/how-can-i-attach-a-mysql-database

Answer 2

just copy it in the data folder and Ctrl+F5 .. and enjoy