Hi there
I have three sites, each runnin MYSQL. I want to replicate the data between
all three. I know I cannot do this with the standard replication in MYSQL,
because all three sites will add their own records and the manual says the
slave cannot insert entries it's self. So, I want to basically dump things,
transfer them and then import on the other side. Is there a way of doing
something like this with SQL statement instead of having to run mysqldump?
One of my problem will be with the auto number field, I know how to do this
by writing a program that reads the data and then save it in the correct
format into a text file, but was just wondring if anyone had any other
brilliant ideas to share with me
Regards
Warren
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Africa
Cell (+27-83) 262-9163
Office (+27-31) 767-0249
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
