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'. F
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
http://www.mysql.com/doc/R/E/RENAME_TABLE.html says:
As long as two databases are on the same disk you can also rename from one
database to another:
RENAME TABLE current_database.table_name TO other_database.table_name;
And as the user comments say, you can use ALTER TABLE with 3.22.
Copying c
Hi,
I am using mySQL 3.22.23 on a Linux platform. How can I copy or move Tables between
different Databases? Is there a simple command for that? We do not have the
mysqlhotcopy command; is it safe to download and use for our mySQL version, and can it
do what I want it to do? I cannot find anyt
