retreiving mysql db from non booting HDD

powadha · 04-08-2006, 05:24 AM

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

leandean · 04-08-2006, 04:19 PM

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.

irvken · 04-10-2006, 05:24 AM

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)

leandean · 04-10-2006, 11:14 PM

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.