Help please - migrating from 3.x to 4.5

[aspira]

Hi,

Following a system crash we are migrating from v3.x to 4.5. We're running under Windows using MySQL & Apache.

If the system hadn't crashed we would have exported the data as a .csv file and then imported it or even just repointed 4.5 to the existing database.

However, now I'm not sure where the data is kept (We restored our directories from tape). It looks like most of the data is in a file called ibdata1 but inside the MySQL directory is a lot of files with the following extensions: .frm .myd and .myi files.

Using Navicat I can't see a way of importing any of this data.

Any help much appreciated.


- Stephen

[kpit]

Have you tryied to open the data directory with MySQL. From there you can run a mysqldump to get your data out in SQL form to execute in your new MySQL server.