Did you know LQ has a Linux Hardware Compatibility List?
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


LinkBack Search this Thread
Old 06-12-2006, 11:14 PM   #1
Senior Member
Registered: May 2004
Location: Australia
Distribution: Gentoo
Posts: 3,544
Blog Entries: 4

Rep: Reputation: 56
Extracting MySQL data from raw files

Hey all,

I recovered the hard disk from a just-out-of-use server here and I need to get at some data from the MySQL database that was running on it but I only have the files. All the files have the old machines hostname in their name so I'm presuming that means I can't just copy /var/lib/mysql from the disk to my machine and reload MySQL.

I'm after the postfix database, so I copied /var/lib/mysql/postfix to my machine, restarted mysqld and the database exists now, I can't see any tables or data inside it. I Googled and found a few non-free Windows apps that do the job but if there is another way I'm all for it. Both databases were running on MySQL 5.0.22 and both had InnoDB compiled out which makes things a tad simpler I think.

Thanks in advance for any suggestions
Old 06-12-2006, 11:22 PM   #2
Senior Member
Registered: May 2004
Location: Australia
Distribution: Gentoo
Posts: 3,544
Blog Entries: 4

Original Poster
Rep: Reputation: 56
Seems I was searching the wrong terms. As soon as I tried "recover" instead of "read" I got a good hit. Answer is not just copying /var/lib/mysql/<dbname> but also /var/lib/mysql/mysql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Raw data telnet bh5687 Linux - Newbie 1 03-23-2006 08:56 AM
Where to place mysql data files TaaDow Linux - Newbie 2 01-04-2006 11:46 PM
Capturing raw mouse data pld Linux - Software 4 04-11-2004 08:13 PM
Raw Packet Data vanibhat Linux - Security 1 08-01-2003 07:42 AM
Extracting data from broken drive darin3200 Linux - Software 1 07-12-2003 01:34 PM

All times are GMT -5. The time now is 03:51 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration