linked server like M$ has?

[darwin101]

Hi all
Is there a way to link 2 mysql servers (5.0 and 4.xx) like you can do with sql server? One of the mysql server is "inside" the fire wall and the other is "outside" of the fire wall.

Much thanks

 

[TonyGroves]

Do you mean you want both servers to host the same data? MySQL uses "replication" or "clustering" to achieve that. Both techniques are explained in the manual.

 

[darwin101]

what i want to do is copy data from the server outside the firewall to the server behind the firewall then delete the data on the server outside the firewall. i was hoping to write a proc to do this.. or use some other tools. i just haven't found a way to do this like i can with sql server.
thanks

 

[TonyGroves]

Well, you can use "mysqldump" on one server, piping the output to "mysql" on the other server, which should do what you want. Example:
[tt]
c:\mysql\bin\mysqldump -h firstserver -u root -prootpwd dbname | c:\mysql\bin\mysql -h secondserver -u root -prootpwd dbname