[Gllug] Mysql replication

[william pink]

2009/3/30 Andy Smith <andy at strugglers.net>

> Hi william,
>
> On Mon, Mar 30, 2009 at 12:55:23PM +0100, william pink wrote:
> > Ah now theres a problem I don't know the position of the master at the
> time
> > of the dump, looks like I have to write a script to send me the master
> > status at the time of the dump then and do it tomorrow night.
>
> Doing a mysqldump with the master information embedded in it is
> covered in the MySQL documentation.
>
>
> http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_master-data
>
> Alternatively:
>
> http://dev.mysql.com/doc/refman/5.1/en/replication-howto-masterstatus.html
>
> Cheers,
> Andy
>
> --
> http://bitfolk.com/ -- No-nonsense VPS hosting
> Encrypted mail welcome - keyid 0x604DE5DB
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFJ0LosIJm2TL8VSQsRAuZDAJ9tDXx7FHtd6rAWn8R43WhT87DMcACgyhyu
> rE3vf/1Ddph4XcXbJBEK6H0=
> =5LYX
> -----END PGP SIGNATURE-----
>
> --
> Gllug mailing list  -  Gllug at gllug.org.uk
> http://lists.gllug.org.uk/mailman/listinfo/gllug


Thats great thanks

Will
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20090330/6d74b3d4/attachment.html>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug