How to copy a table structure from one database to another?

Go to the database in which you want to create the new table, and use CREATE TABLE... LIKE..., fully qualifying the source table name.

Following line of code should do the job:

create table new_table_name like existing_table_name; 

As per comments, it's not entirely clear what you want to achieve. Are trying to create a copy of the database (from scratch) or just copy a single table structure across to another database?

In any case, I'd recommend mysqldump.

If you want to copy all of the tables, you use:

> mysqldump -d $databaseName > $newFile 

Alternatively, if you only want to copy one table, you can use:

> mysqldump -d $databaseName.$tableName > $newFile 

Then you can you either import this file into the other database...

There are multiple tools that will allow you to view the schema of an existing database and export it as a file that you can then run against the new database. A few that cone to mind:

• MySQLWorkbench
• Squirrel SQL
• mysqldump

There are many others.

I am looking for the same solution. I tried below example it worked, go to the database where you want to create a table and try like below example.

CREATE TABLE new_table_name LIKE database.table_name 

This example will create a table with AI, Index, Key. its something like duplicate table structure.

You can use SQLyog for this. SQLyog is an all-round Management Tool (/'GUI'/'Frontend') for MySQL.

It's a simple operation, I think is not necessary to dump the database.

My way to solve this:

USE TARGET_DB; CREATE NEW_TABLE LIKE SOURCE_DB.SOURCE_TABLE;