[Gllug] Mysql replication

Andy Smith andy at strugglers.net
Mon Mar 30 12:25:16 UTC 2009


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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 196 bytes
Desc: Digital signature
URL: <http://mailman.lug.org.uk/pipermail/gllug/attachments/20090330/3c62a9d0/attachment.pgp>
-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug


More information about the GLLUG mailing list