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 can be done as well, just CREATE the table with the same table
definition, then use INSERT ... SELECT (using database.table instead of just
table).
> 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 anything definite in the
> manual about this, so any suggestions are welcome!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
