Hurmoth Posted June 25, 2008 Share Posted June 25, 2008 So I have a MySQL db with a ton of data in it (nothing that is extremely crucial mind you) and there was a power surge today and for whatever reason my data reverted to three weeks ago (everything since then has vanished). Any help would be appreciated it on how to retrieve that data or is it gone for good? (Using SuSE Linux Server 10 BTW). Link to comment Share on other sites More sharing options...
markwolfe Veteran Posted June 25, 2008 Veteran Share Posted June 25, 2008 I am not a server guy, but this link may be helpful to you. http://articles.techrepublic.com.com/5100-...11-5193721.html Link to comment Share on other sites More sharing options...
Hurmoth Posted June 25, 2008 Author Share Posted June 25, 2008 Thanks Mark :) I'll give that a shot. Link to comment Share on other sites More sharing options...
Hurmoth Posted June 25, 2008 Author Share Posted June 25, 2008 So I have no clue how it happened, but some how when the system came backup it moved the db directory from /usr/local/ to /etc/mysql/. When I did a search for the everything mysql (find / -name "mysql") I found that directory. But I'm clueless as to why it did that, but some of the db files were left in the original directory :blink: But I moved the files in /etc/mysql/ to the correct directory and everything is back. Weird. Link to comment Share on other sites More sharing options...
markwolfe Veteran Posted June 25, 2008 Veteran Share Posted June 25, 2008 That is strange... Glad you have your database back, though! (Y) Link to comment Share on other sites More sharing options...
Recommended Posts