Where is Falcon!!!! (Sorry) the only way to have a really consistent binary backup is to shut down the server. the best way to shut down a server is to have a slave dedicated to backups that you can shutdown any time.
if you have only the content of the database folders under [datadir] it is not enough, you need the full [datadir] to 'dream' to restore your db, unless you only use MyISAM tables, then you are more lucky. The bottom line is: Don't Dream, Prove it. Or it will become a nightmare sooner or later. Ciao! Claudio 2010/4/20 Gavin Towey <gto...@ffn.com> > More good ideas from Andrew! > > Just a note though, I noticed someone added replication to a slave as a > backup option. I really discourage that. Replication makes no guarantees > that the data on your slave is the same as the data on your master. Unless > you're also checking consistency, a slave should be treated as a somewhat > unreliable copy of your data. > > Regards, > Gavin Towey > > -----Original Message----- > From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com] > Sent: Tuesday, April 20, 2010 2:08 AM > To: li...@netrogenic.com > Cc: mysql@lists.mysql.com > Subject: RE: better way to backup 50 Gig db? > > I would also recommend looking into some 3rd party tools. > > http://www.percona.com/docs/wiki/percona-xtrabackup:start - Backup Innodb, > MyISAM and XtraDB engines. > http://www.maatkit.org/ - Packed with useful features inc a parallel > dump/import. > > There's some great features in both products. I will leave you to do your > own research into the tools as knowing their features will benefit you. > > Best wishes > > Andy > ________________________________________ > From: ext Jay Ess [li...@netrogenic.com] > Sent: 20 April 2010 09:06 > Cc: mysql@lists.mysql.com > Subject: Re: better way to backup 50 Gig db? > > Gavin Towey wrote: > > What Shawn said is important. > > > > Better options: > > 1. Use InnoDB, and then you can make a consistent backup with `mysqldump > --single-transaction > backup.sql` and keep your db server actively > responding to requests at the same time. > > > > 2. Use something like LVM to create filesytem snapshots which allow you > to backup your database, while only keeping a read lock on the db for a > second or so. > > > 3. Set up replication and backup the replicated data using any of the > above method. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=andrew.2.mo...@nokia.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com > > > This message contains confidential information and is intended only for the > individual named. If you are not the named addressee, you are notified that > reviewing, disseminating, disclosing, copying or distributing this e-mail is > strictly prohibited. Please notify the sender immediately by e-mail if you > have received this e-mail by mistake and delete this e-mail from your > system. E-mail transmission cannot be guaranteed to be secure or error-free > as information could be intercepted, corrupted, lost, destroyed, arrive late > or incomplete, or contain viruses. The sender therefore does not accept > liability for any loss or damage caused by viruses or errors or omissions in > the contents of this message, which arise as a result of e-mail > transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA > 94089, USA, FriendFinder.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com > > -- Claudio
