Jeremy's Home > mysqlsnapshot

mysqlsnapshot (a perl script)

This page is pretty sparse right now... I need some time to add more than the bare essentials.

For MySQL 3.23.xx, setting up replication can be a pain because you need to generate an inital (consistent) snapshot of your data to load onto your slave(s). You also need to make sure the binary log on the master reflects the exact time at which you took the snapshot. mysqlsnapshot automates the process.

mysqlsnapshot used to be known as myrepl, but this is a more descriptive name.

Please remember to read the replication section of the MySQL docs so that you understand what's involved with setting up replication.

Updated on: Wed Aug 29 23:09:06 2001
Copyright 2001, Jeremy D. Zawodny <Jeremy@Zawodny.com>

Site built with Emacs, MySQL, HTML::Mason and some random Perl code on my Linux box.

Need books or CDs? Try Amazon.com and help to fund my collection.