D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] recovering mysql from trashed install

 

On 10/10/13 11:48, Tremayne, Steve wrote:
Is the "unbootable" problem hardware or software related?

If it's software related, I'm guessing that making the server bootable again would 
be more effective (effort vs results) - then you'd be able to get at your data again 
- and do a backup ;o)

If it's hardware, another option - depending on your available resources, would be 
to put the hard-drive in to something else, boot and chroot as Simon mentioned.


-----Original Message-----
From: list-bounces@xxxxxxxxxxxxx [mailto:list-bounces@xxxxxxxxxxxxx] On Behalf Of Tom
Sent: 10 October 2013 09:06
To: list@xxxxxxxxxxxxx
Subject: Re: [LUG] recovering mysql from trashed install

On 10/10/13 00:08, Simon Waters wrote:
On 09/10/13 22:16, Tom wrote:
I made an install unbootable and would like to try and use the old
msql database on it. Can I just copy a file over and then point my
new mysql install at it?
Back it up. Then boot from CD, and chroot and start MYSQL, and dump
the database would be my first attempt.

Yes if you install the same version on the same architecture you could
probably recover the files from where MySQL puts them and make it
work, but messy and horrid and probably overkill.


The server is not functioning - so I cant backup or dump it on the server. I was 
hoping I could just copy a file or files to the new server and somehow use them but 
everyone says dump it first...
I'd put in some 40,000 records since the last backup and I cant reproduce them (the 
source is no longer online) and I'd like to re-access them Tom te tom te tom

Its unbootable due to accidentally installing a few nonstandard libraries (such as libc!!) making it completely unbootable and as far as I'm concerned not worth repairing - its a mint12 and I need stuff that's a bit newer for some of the apps I need to run. I've installed xubu13.04 and copied the database files across chowned then and am running again.
Tom te tom te tom

--
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq