List:General Discussion« Previous MessageNext Message »
From:george larson Date:September 10 2010 2:01pm
Subject:Re: hard disk crash: how to discover the db?
View as plain text  

Uwe Brauer wrote:
>>>>>> On Thu, 09 Sep 2010 18:02:09 -0400, George Larson
> <george.g.larson@stripped> wrote:
>
>    > We do nightly backups at work just by taring the mysql directory.  In
>    > my environment, that is /var/lib/mysql.
>
>    > Like this:
>
>    > service mysql stop
>    > cd /var/lib/mysql
>    > rm -rf *
>    > tar zxvf file.tar
>    > rm -rf ib_logfile*
>    > chown -R mysql.mysql
>    > service mysql start
>
>    > Something similar might work for you.  Somebody with more MySQL
>    > expertise than me can probably help you customize the process to your
>    > environment.
>
> Ok thanks. What I am afraid of is that in on of these OS,
> their might be some other configuration files, which might
> be located apart from the main directory say in /etc and
> then I should copy them as well.
>
> Would it be necessary in Linux to generate the db and its
> users first?
>
> Uwe Brauer 
>
The only one I know of, for my environment, is /etc/my.cnf.  I believe
that it can be located elsewhere but you could just use 'find' to find
it.  I've broken my dev. MySQL many, many times and that's the only file
I know about outside of my data directory.  :)

I don't have any good ideas about discerning precisely what version of
MySQL was running, though.
Thread
hard disk crash: how to discover the db?Uwe Brauer9 Sep
Re: hard disk crash: how to discover the db?andrew.2.moore9 Sep
  • Re: hard disk crash: how to discover the db?Uwe Brauer9 Sep
    • Re: hard disk crash: how to discover the db?George Larson10 Sep
      • Re: hard disk crash: how to discover the db?Mike McMullin10 Sep
        • Re: hard disk crash: how to discover the db?Uwe Brauer10 Sep
          • Re: hard disk crash: how to discover the db?Mike McMullin10 Sep
      • Re: hard disk crash: how to discover the db?Joerg Bruehe10 Sep
        • Re: hard disk crash: how to discover the db?Johan De Meersman10 Sep
        • Re: hard disk crash: how to discover the db?Uwe Brauer10 Sep
      • Re: hard disk crash: how to discover the db?Uwe Brauer10 Sep
      • Re: hard disk crash: how to discover the db?Steve Staples10 Sep
        • Re: hard disk crash: how to discover the db?george larson10 Sep
        • Re: hard disk crash: how to discover the db?Johnny Withers10 Sep
      • no success (was: hard disk crash: how to discover the db?)Uwe Brauer13 Sep
        • RE: no success (was: hard disk crash: how to discover the db?)Gavin Towey14 Sep
Re: hard disk crash: how to discover the db?george larson10 Sep
  • Re: hard disk crash: how to discover the db?Uwe Brauer10 Sep
  • Re: hard disk crash: how to discover the db?MySQL)10 Sep
    • Re: hard disk crash: how to discover the db?george larson10 Sep
      • Re: hard disk crash: how to discover the db?Johnny Withers10 Sep
Re:hard disk crash: how to discover the db?kapil verma11 Sep