D&C GLug - Home Page

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

Re: [LUG] recovering mysql from trashed install

 

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

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

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