LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   retreiving mysql db from non booting HDD (https://www.linuxquestions.org/questions/linux-software-2/retreiving-mysql-db-from-non-booting-hdd-432971/)

powadha 04-08-2006 05:24 AM

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

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.


All times are GMT -5. The time now is 09:37 PM.