I am not sure on this one, since I am new to mysql myself. But how about just entering the appropriate information on the other host before the database name i.e. hostname.databasename.tablename Don't know how or where to privide the user name/pw for tthe 2nd. server though.
It's just an idea from a newbie, so do not put too much trust in it :) Sven On Monday, May 6, 2002, at 02:44 PM, Ewan Sadie wrote: > I have installed MySQL on two of my MS-Proxy servers. I am logging all > web browser logs to MySQL. > I want to replicate the database to a central server where I can do > queries on the data. I do not want to run select statement agains the > proxy server itself. > How can I replicate the data to a different server (like with slave > master replication) and then delete the data on the proxy server, > without deleting it on the central server. > What I actually want to do is something like a selecy into but between > different server/databases. > > I am evaluation MySQL and if I can get this right I will chuck out my > MS-SQL databases. > > Ewan Sadie > _____________________________________________ > lose weight now! http://www.slimandtrim.biz > > --------------------------------------------------------------------- > 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 <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- 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
