View Single Post

   
  #2 (permalink)  
Old 04-29-2008, 08:28 PM
Peter H. Coffin
 
Posts: n/a
Default Re: Query 2 databases cross-server

On Sun, 27 Apr 2008 14:29:41 -0700 (PDT), weer1@gmx.net wrote:
> Hi,
>
> Does anybody know how to copy records from one mysql-database to
> another on another server?
> I use PHP and mySQL.


Very easy then. Open two database connections, select a set of data from
one, and while you loop through the rows of results, generate inserts
over the other connection.

--
The greatest dangers to liberty lurk in insidious encroachment by men of
zeal, well-meaning but without understanding. -Justice Louis D. Brandeis
Reply With Quote