I have copied the /var/lib/mysql/mydbname db to a new machine from a crashed server (booted using a live cd) but now I cannot access the tables within the db...
All the tables only have a .frm extension, so I am assuming they are InnoDB.
They appear in a SHOW TABLES statement, but I cannot SELECT from them.
REPAIR / OPTIMIZE / ANALYZE all give;
+---------------+-------+----------+-------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------+-------+----------+-------------------------------------+
| mydbname.xyz | check | Error | Table 'mydbname.xyz' doesn't exist |
| mydbname.xyz | check | error | Corrupt |
+---------------+-------+----------+-------------------------------------+
myisamchk wont touch them (obviously)...
I am feeling slightly optionless atm.
Thanks in advance.