Forums

kbricked
kbricked
Offline
Resolved
0 votes
The current machine I use for a ClearOS install has been reinstalled on a different HDD and has changed locations.

My previous installation of ClearOS on a different HDD is now in my Windows Machine that I can access when I boot into Linux.

I forgot to export the MySQL database prior to moving the machine...

Is there anyway to recover a MySQL database from a non live ClearOS system, or will I need to boot up again into the same machine {possible, just a pain} in order to export the current database? Its over a years worth of blogging... not that it matters much in the big picture but I'd like to get the site back up and running.

Maybe I can image the ClearOS install into a VM?

I've some goggling to do however if someone more knowledgeable than I has any experience with this any help would be fantastic.
Thursday, June 03 2010, 10:04 PM
Share this post:
Responses (5)
  • Accepted Answer

    kbricked
    kbricked
    Offline
    Thursday, June 03 2010, 10:06 PM - #Permalink
    Resolved
    0 votes
    Doh!

    Maybe someone can move this thread to the database forum?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, June 03 2010, 10:24 PM - #Permalink
    Resolved
    0 votes
    Moved :)

    The best method would have been to use mysqldump and dump the database when it was still operational. However I guess you can still copy the databse over from /var/lib/mysql/tablename and drop it into your new install. You've nothing to lose if it doesn't work out? just make sure all the permissions (ownership and group = mysql) are correct, you probably want to stop the new service first, and overwrite any existing files in /var/lib/mysql.
    The reply is currently minimized Show
  • Accepted Answer

    kbricked
    kbricked
    Offline
    Thursday, June 03 2010, 10:39 PM - #Permalink
    Resolved
    0 votes
    Thanks Tim. I'll give it a shot. Worse case scenario I'll switch out HDDs for a while and export the database.

    As to nothing to lose...well; thats subjective! :) It has a certain sentimental value to me; can't say its really valuable to many other people unless they're looking for cracker jack ways of computing... and most people aren't!
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, June 03 2010, 10:50 PM - #Permalink
    Resolved
    0 votes
    Sorry I just meant that by copying the date out of the old HD into the new one there is no risk to the original data if it doesn't work, assuming you have nothing in the new mysql database already :)
    The reply is currently minimized Show
  • Accepted Answer

    kbricked
    kbricked
    Offline
    Thursday, June 03 2010, 11:21 PM - #Permalink
    Resolved
    0 votes
    Oh, oops. :laugh: Who needs logic? :whistle:
    The reply is currently minimized Show
Your Reply