Re[2]: [PHP-DB] database synchronization

2002-10-29 Thread Martin Hudec
Hello Peter, nice readinglooks like i need to get binary log with queries that modified some data...okayand use queries from this log on our slave databaseokay mysqlbinlog log-file | mysql -h server_name i suppose server_name is hostname but what if this hostname changes (or

RE: Re[2]: [PHP-DB] database synchronization

2002-10-29 Thread Peter Lovatt
--- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: Martin Hudec [mailto:corwin;corwin.sk] Sent: 29 October 2002 08:44 To: Peter Lovatt Cc: [EMAIL PROTECTED] Subject: Re[2]: [PHP-DB

Re[2]: [PHP-DB] database synchronization

2002-10-29 Thread Martin Hudec
Hello Juhan, JK So you can't determine database servers' ip addresses, since they may or JK may not be dynamic. So don't use the ip address, use hostname and JK update this hostname every time ip-address changes. You can do it with JK your own scripts and local host file or you can use public