<br><br><div class="gmail_quote">2009/3/30 Andy Smith <span dir="ltr"><<a href="mailto:andy@strugglers.net">andy@strugglers.net</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi william,<br>
<div class="im"><br>
On Mon, Mar 30, 2009 at 12:55:23PM +0100, william pink wrote:<br>
> Ah now theres a problem I don't know the position of the master at the time<br>
> of the dump, looks like I have to write a script to send me the master<br>
> status at the time of the dump then and do it tomorrow night.<br>
<br>
</div>Doing a mysqldump with the master information embedded in it is<br>
covered in the MySQL documentation.<br>
<br>
<a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_master-data" target="_blank">http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_master-data</a><br>
<br>
Alternatively:<br>
<br>
<a href="http://dev.mysql.com/doc/refman/5.1/en/replication-howto-masterstatus.html" target="_blank">http://dev.mysql.com/doc/refman/5.1/en/replication-howto-masterstatus.html</a><br>
<br>
Cheers,<br>
Andy<br>
<font color="#888888"><br>
--<br>
<a href="http://bitfolk.com/" target="_blank">http://bitfolk.com/</a> -- No-nonsense VPS hosting<br>
Encrypted mail welcome - keyid 0x604DE5DB<br>
</font><br>-----BEGIN PGP SIGNATURE-----<br>
Version: GnuPG v1.4.6 (GNU/Linux)<br>
<br>
iD8DBQFJ0LosIJm2TL8VSQsRAuZDAJ9tDXx7FHtd6rAWn8R43WhT87DMcACgyhyu<br>
rE3vf/1Ddph4XcXbJBEK6H0=<br>
=5LYX<br>
-----END PGP SIGNATURE-----<br>
<br>--<br>
Gllug mailing list  -  <a href="mailto:Gllug@gllug.org.uk">Gllug@gllug.org.uk</a><br>
<a href="http://lists.gllug.org.uk/mailman/listinfo/gllug" target="_blank">http://lists.gllug.org.uk/mailman/listinfo/gllug</a></blockquote><div><br>Thats great thanks<br><br>Will <br></div></div><br>