Migration of MySQL database tables and replication of tables

Migration of tables between databases on the same server:

CREATE TABLE Db.tablename as SELECT * from Db2.tablename;

This SQL is used by MySQL to copy a table from a DB2 database on one server to another database db, and to copy the structure of the table and the contents of the data.

To copy the structure and contents of a table from another service, proceed as follows:

Export data when you choose to export the content contains the list, I use the MySQL tool is navicate

When you select the column that contains the table, you can set the following settings when you import the structure and data of the tables in the database on another server:

Edit the structure of the table here, modify the primary key operation

Migration of MySQL database tables and replication of tables