Hello All,
The other day my server running MySQL 3.23.58 got hacked into and we
are migrating to another one. I backed up my databases using two
methods a) Mysqldump and b) copy the DATA folder on my server.
Now, I am trying to restore these databases on my local machine
(running MySQL 4.0.22-debug and Apache 2.0 on IIS 6.0). I have tried
importing the SQL files (mysqldump) and copying the .frm, .myd and .myi
files into the existing DATA folder on my local machine.
In both cases, the database is created and I can see the table
structure. But when I click on most of the tables, I get the following
error:
#1016 - Can't open file: '<table_name>.InnoDB'. (errno: 1)
Can anyone pls throw some light on this issue? Any suggestion will be
greatly appreciated.
- V