List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:September 11 2009 1:31am
Subject:RE: DB/table problem
View as plain text  
Hi Todd,

I didn't mention xtrabackup because I have no experience with it =)  I know the other
methods work, and honestly, for most mysql users just starting out, it's easier to use
mysqldump.  It's simple, and it's easy to get help with, and it works across storage
engines.

Regards,
Gavin Towey

-----Original Message-----
From: tlyons@stripped [mailto:tlyons@stripped] On Behalf Of Todd Lyons
Sent: Thursday, September 10, 2009 3:44 PM
To: Gavin Towey
Cc: mysql@stripped
Subject: Re: DB/table problem

On Thu, Sep 10, 2009 at 2:49 PM, Gavin Towey <gtowey@stripped> wrote:
> When using innodb, your data is stored in the data/ibdata* files.  Copying the
> database directory is not a valid backup.
>
> In the future, I would suggest using mysqldump.  However if you want to make a
> file-system copy backup with innodb you need to 1. Shutdown the server 2. Copy
> *everything* in the data directory 3. Store a copy of your my.ini with the backup as well.
> 4. Restart mysql

Do you exclude xtrabackup as a potential solution because he's using
Windows (it doesn't build on Windows) or because you have some issue
or problem with xtrabackup?  I'm not aware of any show-stopper bugs.
I'm just curious, because it works well for us.  The backup is online
with the only lock held occuring while it's copying over the *.frm and
*.MY* files, which is not very much for us.
--
Regards...      Todd

The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies
of the original message.
Thread
DB/table problemNéstor10 Sep
  • RE: DB/table problemGavin Towey10 Sep
    • Re: DB/table problemTodd Lyons11 Sep
      • RE: DB/table problemGavin Towey11 Sep
    • Re: DB/table problemNéstor11 Sep
      • RE: DB/table problemGavin Towey11 Sep