Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MyISAM database copy

Status
Not open for further replies.

Protonman

Programmer
Joined
Apr 1, 2005
Messages
6
Location
CH
Hello,

I have just tried to copy my database (MyISAM) to another computer also running the same operating system as my computer. What I have copied and pasted is the enitire database folder in the 'data' folder of MySQL. I can select the db and 'show tables' works, but if I try to run "SELECT * FROM 'table'" e.g., an error msg pops out saying:

Can't open file: 'table.idb' (errno: 1)

This, although my tables are MyISAM with .frm, .MYI and .MYD files intact. Can someone tell me how I can change MySQL to interpret those files as a MyISAM and not as a InnoDB database?

Many thanks in advance

Protonman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top