I want to copy table contained from one database and insert onto another database table

If you want to copy a table from one Database to another database , You can simply do as below.

CREATE TABLE db2.table LIKE db1.table;
INSERT INTO db2.table SELECT * FROM db1.table;

or just CREATE TABLE db2.table SELECT * FROM db1.table in MySQL 5

In BASH you can do:

mysqldump database_1 table | mysql database_2

Related