Greetings,
I have the following setup:
- Machine "A" is running MySQL and is disconnected from the network 80% of
the time.
- Machine "B" is running MySQL and I would like it to act as a master
server.
- Machine "A" has a crontab running to check the network status every
second. When the network link comes up, I would like to have machine "A"'s
data transfered to Machine "B".
I don't know if this would be the best solution, nor do I know much on this
topic, but would after the network connection is made, should I have a
script write all the records from Machine "A" to a file (I saw an e-mail
on this list once about dumping all the tables and their info to one .sql
file, and using that for a backup copy) and then transfer that file to
Machine "B", then on machine "B" have the file imported into Machine "A"'s
MySQL?
Im sure there is a better solution to mine.
Any suggestions?
Thanks!
- Chris
---------------------------------------------------------------------
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
