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.
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.
In Database
Share this post:
Responses (5)
-
Accepted Answer
-
Accepted Answer
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. -
Accepted Answer
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! -
Accepted Answer
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »