How to import all MYSQL INNODB database without using the export and import (dumb) function ?

Hi,

I would like to request an assistant.

It seems that our Windows Server 2003 server fail to boot.

We have resetup a fresh Windows Server 2003 and install MYSQL5 on another hard disk and attached the old disk to the same server.

We can boot the windows server 2003 finely with MYSQL database .

The problem is how to import all the MYSQL database in the Old Hard Disk to the new disk.

FYI, the mysql database in the old hard disk is using INNODB engine.

Appreciates if anybody can guide me on how to import or copy the database to the new hard disk without any data lost.

Thank you.
LVL 2
smksaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
niko86Connect With a Mentor Commented:
if you still got the innodb logfiles on the old harddisk, you could try recovering from these logfiles.
A pretty good HowTo: http://www.buildcms.com/cms_knowledgebase/how_to_recover_mysql_data_from_innodb
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.