How to import all MYSQL INNODB database without using the export and import (dumb) function ?
Posted on 2009-04-12
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.