Nuke Resources » Forums » phpMyAdmin » How do I access old InnoDB tables from prev mysql install

bongobongo · Resource Seeker

Hi.

My previous computer crashed so I had to buy another one.

My previous mysql tables are now visible (from explorer) via an external SATA disk.

I copied the old mysql data directories (tables) from my external disk
to my new mysql data dir.

When I start phpmyadmin i can see the databases listed to the left.

When I select a table I can see all the tables listed.

But when I click on a table I get this message:

******************************************
Error

SQL query:
SHOW INDEX FROM `block` ;

MySQL said:
#1146 - Table 'gallery.block' doesn't exist
***********************************************

If I create a new table then everything works just fine.

So I guess the problem is because I just copied the directories with the old databases from my external disk and pasted those into my new mysql data directory.

I cannot dump my tables from my external disk so.....
how do I be able to get access to my old tables?

bongobongo · Resource Seeker

I found that I can access the MyISAM tables.

They work as they should.

It is only when clicking on an InnoDB table I get the problem.

So I guess there is some problem when copying InnoDB tables from one location/machine to another that might cause the problem.

The path to the datadir are the same on the new computer as it was on the previous one.

Anyone with a suggestion on how to fix this?

bongobongo · Resource Seeker

I just had to change the data-dir line in my.ini to point to my external data-dir.

Then I could export the databases and tables using phpmyadmin

Change back to my new data-dir in my.ini

and import the files...