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
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