How would I pull the MySQL database data off a old hard drive that is just mounted to a newly installed OS?

Long story short. Hard drive had some data corruption, removed. New hard drive installed, old hard drive mounted to new system.

Now I need to find out how to get the mySQL data assuming it's not corrupted and put it on the new system.

Thanks for any help!

Is your old server harddisk also installed with PHPMyadmin? If so, you can easily EXPORT the database to a zip or gzip or bzip'd file, and move it to another harddisk.

Even easier would be if you could do this remotely from the good harddisk!

It had phpmadadmin installed on the server before the crash and it's installed on there now.

The thing is though, I'm not sure if I access phpmyadmin it will access the "data" on the old hard drive. Only the new.

The old hard drive (one with corrupted files) is mounted/attached to the new hard drive (operating system) so I can browse the physical files directly. Although nothing is running from it. IE: Its just a secondary hard drive mounted to the system.

I think I will have to find the physical data that's stored on the hard drive itself and physically copy/move the data over to another location so I can pull/extract/convert it to use with the new stuff.

AFAIK mysql doesnt save a "file" for every database you create. The only ways i know of to backup are either by phpmyadmin or by mysql command line, but then the server would have to be running.

Perhaps someone else knows of a way here, but i'm sorry, i can't help u further on this problem then . Googling didn't bring any other ways either.


-------------

Nevermind.. this is the solution:

http://stackoverflow.com/questions/4...physical-files

Dont feel like retyping their work! So here's the link, so they get the credit for their answer . I didn't know this either.

Yea I'm googling right now trying to figure out the solution. The hard drive is physically in the new system, but it's not the primary hard drive. Maybe I can trick phpmyadmin into thinking the "old" hard drive is it's primary location and pulling the data from there, but I wouldn't even know where to start.

The data has to be stored somewhere, might not be a regular file but it at least has to be some kind of encrypted file of some sort I would think.

Oh thanks!!! Didn't see the edit!!

Hmm, Ok so I moved those files over to the new location. Loaded up Phpmyadmin and I can see the databases... but everything is empty. No tables, no data, nothing. All it says is the database name (0)

Ahh I fixed it. The file ownership was wrong.

ye, the follow-up posts are like a walkthrough! Glad to hear it works now .