Veritas-bu

[Veritas-bu] Suggestions/links/etc.. To doing online backup of MySQL with NB 5 .1

2004-11-11 05:14:04
Subject: [Veritas-bu] Suggestions/links/etc.. To doing online backup of MySQL with NB 5 .1
From: droman AT plcendesa DOT com (David Roman Esteban)
Date: Thu, 11 Nov 2004 11:14:04 +0100
Kjell Grindalen wrote:

> Hello everyone.
> I am new to this list, and I was wondering if some of the members here 
> have any experience, advices and such for doing online backup of MYSql 
> db on Windows 2000
>  
> I found something that was called Veritas Cluster agent for MySQL but 
> I dont feel that is the way to go
>  
> Any advice is welcome!
>  
>
> Kjell Grindalen
>
> SiO/IT
> Epost: Kjell.Grindalen AT sio DOT no <mailto:Kjell.Grindalen AT sio DOT no>
> Tlf:   2259 6863
> Mob: 9188 7200
>
>  

1.- mysqlhotcopy script http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
2.- make a master and a slave server the slave server only for backup 
purpose, at any time you break the sync, stop the slave database, make 
backup, then resync. the sync process is via "rcp" (not exactly) so it's 
as fast as your lan. http://dev.mysql.com/doc/mysql/en/Replication_FAQ.html
After 1 or 2 simply  backup result files.

-- 
Un saludo
David Román Esteban
droman AT plcendesa DOT com
(+34)669229194


<Prev in Thread] Current Thread [Next in Thread>