Hi. On Mon, Dec 10, 2001 at 11:12:58AM +0000, [EMAIL PROTECTED] wrote: > On Monday 10 December 2001 10:30, Benjamin Pflugmann wrote: > > You may want to have a look at "replication" in the fine manual: > > http://www.mysql.com/doc/R/e/Replication.html > > A lot of info there! But it seems to apply mainly to v4.
Usually the manual annotates the version the information belongs to, if it changed recently. I did not compare it for that section, but you can always look at the manual you got with the version you downloaded. It's just easier for me to point out a link to the online manual in comparison to explaining in words which chapter you have to look for. You always can get the idea what I am talking about from the online manual and then look for the corresponding chapters in your local one. > I'm not sure of Ananth's situation, but what I want to do is have > dbs on a web site periodically synced to the same dbs on a LAN db > server which is on dialup. Both are using v3.22.27, and are on > *nix. Replication was introduced in 3.23. The 3.23 version of replication would be able to handle your situation as it can continue from where it left last time. > I was thinking of having a cron job on the website to dump the dbs, > and then another cron job on the lan box to dial up, download the > dump, and then update the local dbs (if that is possible - otherwise > it could be done manually, I suppose). Sounds reasonable for version 3.22, as long as your database doesn't get big. Note that up to 3.23.11, there is a known, severe security issue (if an "untrusted" computer may try a connection to MySQL on your database server, you are affected) http://www.mysql.com/doc/N/e/News-3.23.11.html Another one was fixed in 3.23.36 (which affects you, if you host "untrusted" users) http://www.mysql.com/doc/N/e/News-3.23.36.html > Is there any more elegant method to do this? Not in 3.22, I fear. Bye, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
