Copying Tables Between Databases

To copy tables between database (on the same server) use this syntax:

CREATE TABLE New Table_name
SELECT * FROM Original Table_name;

So my code snippet is:

CREATE TABLE `xfer_db.image`
SELECT * FROM `cnueu_drpldb.image`;
CREATE TABLE `xfer_db.files`
SELECT * FROM `cnueu_drpldb.files`;

Note to self: try always to create snippets that can be run in phpMyAdmin or in the mysql command shell. Hence one reason to use back ticks to enclose field names in MySQL as shown.