Re: How do I copy a table from one MySql schema to another mySql schema in MySl?

[Anthony Willard]

If it's on the same server just a different database, you can use

CREATE TABLE newdb.mynewtable LIKE olddb.myoldtable;

You can then insert data into the new table from the old using

INSERT newdb.mynewtable
SELECT *
FROM olddb.myoldtable;

If they are on different servers, you can use the "mysqldump" command line utility to dump the structure and/or data to a file, then run the file on the new server. Use "--tables" to specify which table(s) you need to migrate.

Anthony