Salvaging MySQL Database...

[Kareeser]

Hey guys..

So my server ended up dying for no reason. I think the hard drive died.

In any case, if it's only a booting error or something, then technically I can still recover the files on it.

Would it be possible to recreate my database this way? If so, where in the HD would I go about recovering these files?

Thanks!

[EzyStvy]

Bit of a guess here...The raw data files will probably be in a folder called DATA. Possibly under a folder called MYSQL. (C:\program files\mysql\data)

They will probably be .MDF and .LDF file types.

Once you get the machine back up n running, am also guessing you will have to run an "attach" command from a command prompt to attach them to the sqlmgr....

[mairving]

Is it Windows of Linux?

[Kareeser]

Thanks, Ezy, Mariving,

It's a Windows Machine.

Theoretically, however, if the replacement machine (or rather, replacement hard drive) is Linux, would there be any problems?