List:General Discussion« Previous MessageNext Message »
From:Uwe Brauer Date:September 10 2010 1:56pm
Subject:Re: hard disk crash: how to discover the db?
View as plain text  
>>>>> 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 

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