Having organized a lot of datasets in severeal MySQL databases on the same (local)-server the I needed to move a table to another database. The posted solution is copy-paste from Eric Bergen on the MySQL forum:
Alter table can be used to move tables from one db to another.
alter table old_db.foo rename new_db.foo
Rforge 