If you want to mirror a single table and your DB's don't both have full access to each other then you can "push" one table from the server on the private IP address to the other with a cron jobby by using (in unix) the "mysqldump --add-drop-table -h someserver_with_good_permissions dbname tablename | mysql dbnameof_the_otherserver" which effectively overwrites that table with the latest table..
Cheers, Andrew -----Original Message----- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday 27 March 2003 21:44 To: 'Ville Mattila'; MySQL Mailing List Subject: RE: Mirroring a table Is creating a cronjob a feasible alternative? -----Original Message----- From: Ville Mattila [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 1:50 PM To: MySQL Mailing List Subject: Mirroring a table 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
