Re: Cross server select into

2002-05-05 Thread Dicky Wahyu Purnomo
On Mon, 6 May 2002 07:44:04 +0200 "Ewan Sadie" <[EMAIL PROTECTED]> 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

Re: Cross server select into

2002-05-05 Thread Sven Bentlage
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

Cross server select into

2002-05-05 Thread Ewan Sadie
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 differ