0

My Ubuntu computer HD crashed, so I cant boot up anymore, I'm trying to recover my data from the hard drive by booting up using the live CD.

I can access the crashed internal hard drive by mounting it from the live CD/USB.

I have a database I want to recover, but I can't start the MySQL server since I boot from the live CD, MySQL server wont start, so I can't use the regular MySQL command line commands to do anything.

I created the database and was using it with WordPress. I spent over four months entering all this data then the computer crashed, I know I should have backed it up.

I don't even know which files are the database files, which file extensions to search for, or where the files are located on the Ubuntu.

Does anybody know where the data base files are located, and which files to copy in order to get it back after I re-install Ubuntu?

halfer
  • 19,824
  • 17
  • 99
  • 186
N S
  • 303
  • 4
  • 17

2 Answers2

2

Mount the slave drive. Shutdown MySQL. Copy over the content from the old /var/lib/mysql* over to the live disk. Start MySQL.

Reference :

http://ubuntuforums.org/showthread.php?t=873819&s=6ca65627adaf56a925874f898eca1c18&p=5483647#post5483647

Harsh Bafna
  • 2,094
  • 1
  • 11
  • 21
0

Well, since you can't run mysql and won't be able to use mysqldump, you're left with copy-pasting raw data files.

There are good answers here

How to recover MySQL database from .myd, .myi, .frm files

Community
  • 1
  • 1
Link
  • 311
  • 1
  • 6
  • I have mysql executable located in /usr/bin but there is no mysqld in there – N S Jul 30 '15 at 03:56
  • I dont even know what command to issue in order to copy the database to another USB drive, do you know how to do that? – N S Jul 30 '15 at 03:58
  • I tried mysqldump, but it needs the mysql server to be running, and I cant run the server because I booted off the live CD – N S Jul 30 '15 at 04:09
  • Here's what you should be looking at. http://stackoverflow.com/questions/879176/how-to-recover-mysql-db-from-myd-myi-frm-files – Link Jul 30 '15 at 04:22