Problem

You would like to copy a table with its data from one database to another.

Solution

You can use the following:

INSERT INTO database2.table SELECT * from database1.table

taken from here