mysql - how do I load data from a different configuration...

Posted by Ronedog on Stack Overflow See other posts from Stack Overflow or by Ronedog
Published on 2010-03-31T20:05:12Z Indexed on 2010/03/31 20:23 UTC
Read the original article Hit count: 299

Filed under:
|

I'm not sure if this will make sense, but I'll give it a shot.

My hard drive went down and I had to reinstall the os along with all my webserver configuration,etc. I kept a backup of the mysql database, but it doesn't contain all the tables...I added a couple tables after my last backup.

I have access to the hard drive and the directory where the mysql data files are stored from the failed hard drive, but I don't know how to retrieve the data into my new mysql database. Is it even possible to get the raw data files from mysql and load them into a different instance? I'd even be happy if there was some way for phpmyadmin to show the data files, then I could dump out to a backup txt file, and reload them into my new configuration.

Any help will be appreciated. thanks.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about phpmyadmin