Copy MySQL table from one database to another Posted on 6 April 2018 by kosmas emailFacebookTwitterLinkedinProblem You would like to copy a table with its data from one database to another. Solution You can use the following: MySQL INSERT INTO database2.table SELECT * from database1.table 1 INSERT INTO database2.table SELECT * from database1.table taken from here