Solved

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

Posted on 2009-04-12
1
757 Views
Last Modified: 2013-12-12
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.
0
Comment
Question by:smksa
1 Comment
 
LVL 5

Accepted Solution

by:
niko86 earned 500 total points
ID: 24125668
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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now