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
|