LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices



Reply
 
Search this Thread
Old 06-13-2006, 12:14 AM   #1
cs-cam
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-13-2006, 12:22 AM   #2
cs-cam
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
 
  


Reply


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


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


All times are GMT -5. The time now is 08:18 AM.

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