LinuxQuestions.org
Help answer threads with 0 replies.
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 04-08-2006, 05:24 AM   #1
powadha
Member
 
Registered: Nov 2003
Distribution: Debian SID
Posts: 649

Rep: Reputation: 31
retreiving mysql db from non booting HDD


I've got a box that won't boot anymore, trying to find the solution using Knoppix failed since nothing is written to logs that explains the boot failure so that's a dead end.
I'm trying to get the mysql db's from that disk. Is it possible to just mount the drive using an other box and copy them (the drive can still be browsed normally using knoppix) to the new disk?
What would be the location of the db's and is it possible to load them into mysql on the newly installed box (same distro same versions)?

Regards

Last edited by powadha; 04-08-2006 at 06:41 AM.
 
Old 04-08-2006, 04:19 PM   #2
leandean
Member
 
Registered: Oct 2005
Location: Burley, WA
Distribution: Sabayon
Posts: 276

Rep: Reputation: Disabled
It's possible and fairly simple. Go to :

http://dev.mysql.com/doc/refman/4.1/en/index.html

and peruse section 2.10.3. Mysqldump and import.
 
Old 04-10-2006, 05:24 AM   #3
irvken
Member
 
Registered: Dec 2003
Location: uk
Distribution: Ubuntu/Debian/Android
Posts: 217

Rep: Reputation: 30
where does mysqldump put it's ouput amd in what format? I've run mysqldump --all-databses, but can't find the output files to copy off (assuming it's worked properly)
 
Old 04-10-2006, 11:14 PM   #4
leandean
Member
 
Registered: Oct 2005
Location: Burley, WA
Distribution: Sabayon
Posts: 276

Rep: Reputation: Disabled
You have to tell mysqldump the file name and location. For example:

$>mysqldump /tmp/'name of file'

The name is your choice. Most people give it a .sql extension for clarity.
 
  


Reply

Tags
database, locate, mysqldump, recovery


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
Grub - not booting my xp on hdd prabhatsoni Linux - General 10 10-10-2005 08:11 PM
retreiving a range of iterators with an stl container g_goblin Programming 1 09-01-2005 05:50 PM
Trouble booting on new hdd mjkmkk Linux - General 1 08-27-2004 06:23 AM
Booting from a USB HDD - HOW DO I m.westwood-hill Linux - General 2 05-01-2003 01:05 AM
Booting from a USB HDD - HOW DO I m.westwood-hill Linux - Software 0 04-30-2003 04:20 AM


All times are GMT -5. The time now is 05:34 PM.

Main Menu
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