Assuming that both databases are on the same mysqld instance setting triggers to keep the table up to date should do what you want...
On Thu, Oct 9, 2008 at 10:34 AM, Eric Anderson <[EMAIL PROTECTED]> wrote: > > I've got two databases Foo and Bar. Both databases have a table called > 'zoop_t'. Foo's is the "master" copy (i.e. the one that gets updated) and > Bar needs to be updated if/when changes are made. > > Currently, I'm mysqldump'ing that table from Foo at midnight via cron and > feeding it back into Bar via cron. > > Is there a way to set up real-time "replication" of that table? > Assuming that both databases are on the same mysqld instance setting triggers to keep the table up to date should do what you want... -- Rob Wultsch [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
