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 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