 <p>If columns are different i always have success with the below:</p> <pre><code>USE `old_database`; INSERT INTO `new_database`.`new_table`(`column1`,`column2`,`column3`) SELECT `old_table`.`column2`, `old_table`.`column7`, `old_table`.`column5` FROM `old_table` </code></pre>