Re: [TCLUG:9290] Hot System Backups and an active MySQL Database

[Joseph Heil <heilja@dbsource.com>]

The safest way to backup any db is cold.  But if you must run a hot backup
you need to know of the db is running a transaction log.  If the db does not
support a transaction log, then doing a hot backup is very risky.
Because when you do a hot backup not all of the db files may be in sync
from what is on tape to what is live/hot, especially if you had any
transactions written to the db during the backup period.  If the db supports
transaction logs, then hot backups can then restored from any point from which
a db failure occured plus any logs created during and after the hot
backup period.

Quoting Ben Kochie (ben@nerp.net):
> i would normal avoid the database area, but before the backup, run a mysql
> dump of the database, much safer
> 
> Thank You,
>         Ben Kochie (ben@nerp.net)
> 
> *-----------------------*  [ - * - * - * - * - * - * - * - ]
> | Unix/Linux Consulting |  [ Haiku Error Message:          ]
> |  PC/Mac Repair        |  [  Chaos reigns within.         ]
> |   Networking          |  [  Reflect, repent, and reboot. ]
> | http://nerp.net       |  [  Order shall return.          ]
> *-----------------------*  [ - * - * - * - * - * - * - * - ]
> 
>  "Unix is user friendly, Its just picky about its friends."
> 
> On Tue, 19 Oct 1999, Bob Tanner wrote:
> 
> > Any problems doing a hot system backup with a very active MySQL database
> > running?
> > 
> > I am using BRU, but will use any tools that will work. 
> > 
> > I know with Oracle I have to "freeze" the database if I want to do a hot
> > backup, so is there the same thing with MySQL?
> > 
> > -- 
> > Bob Tanner <tanner@real-time.com>       | Phone : (612)943-8700
> > http://www.real-time.com                | Fax   : (612)943-8500
> > Key fingerprint =  6C E9 51 4F D5 3E 4C 66 62 A9 10 E5 35 85 39 D9 
> > 
> > 
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tclug-list-unsubscribe@mn-linux.org
> > For additional commands, e-mail: tclug-list-help@mn-linux.org
> > 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tclug-list-unsubscribe@mn-linux.org
> For additional commands, e-mail: tclug-list-help@mn-linux.org

-- 
Joseph A. Heil, Jr.                  DBA - Oracle, DB2, Posgresql, Msql 
heilja@dbsource.com                  http://www.dbsource.com
voice: 612-445-5180                  fax:   612-445-5196
Key fingerprint = 95 FC 3A F4 8A 10 05 85  3F 53 01 86 AD DB DB 51