hello for all
first i'm using MySQL server 4.1
the problem is:
i backup my database by only copy the "data" folder that is in
"c:\Program files\MYSQL\MySQL Server 4.1\"
the folder contains:
Then i format my machine. after that, i install the OS (WIN XP Prof) and every things. in addation, i copy the folder "data" to the same path that is above. and i try to see my tables, but i can't
a message come and say:
"#1016 - Can't open file: 'order_detail.ibd' (errno: 1)"
in the logfile i see:
050511 10:43:04 InnoDB error:
Cannot find table bill/order_detail from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
Look from section 15.1 of
http://www.innodb.com/ibman.html
how you can resolve the problem.
050511 10:43:04 [ERROR] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Can't open file: 'order_detail.ibd' (errno: 1)
050511 10:43:04 InnoDB error:
Cannot find table bill/room from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
Look from section 15.1 of
http://www.innodb.com/ibman.html
how you can resolve the problem."
I wish you to solve my problem ....:)