Hello everyone, I was wondering how could I make a mirror copy of a table to another server in the easiest way? I browsed through the MySQL documentation but didn't find any clue of a "COPY TABLE" command or a similar method. I know that I can make a dump from a table and then run that dump file in another server - but maybe there are also better ways to do it?
I have two database servers, the one is running inside a local network and the other is running in the web. Because there are no web access to the local network database server, I need to do frequent copies (automatically) to the web to have some information in the website. This is why I'd need a "mirroring" feature. Any ideas? - Ville -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]