copy database structure without data in mysql (with empty tables)

mysql copy database-schema
Pramod picture Pramod · Jan 1, 2013 · Viewed 56.7k times · Source

Is there any way to copy database structure without data in MySQL, so the new database will be the same as it is copied from, but with empty tables.

After getting some suggestions I tried the command, but I am getting syntax error, my username = root and password = nothing. I guess the default one. I am trying following command, 

mysqldump -u root -p -d xyz_db | mysql -u root -p -Dnew_db

what I am missing or misplacing in command?

Answer

Raab picture Raab · Jan 1, 2013 
mysqldump -u user -ppass -d olddb | mysql -u user -ppass -D newdb

The new database must already exist. The -d flag in the mysqldump command prevents copying of data.

There's no space between the flag -p and the password.

Related questions

How to copy a row and insert in same table with a autoincrement field in MySQL?

In MySQL I am trying to copy a row with an autoincrement column ID=1 and insert the data into same table as a new row with column ID=2. How can I do this in a single query?

Read More
How to copy data from one table to another new table in MySQL?

I want to copy data from one table to another in MySQL. Table 1 (Existing table): aid st_id from_uid to_gid to_uid created changed subject message link Table 2 (New Table) st_id uid changed status assign_status I …

Read More
In MySQL, can I copy one row to insert into the same table?

insert into table select * from table where primarykey=1 I just want to copy one row to insert into the same table (i.e., I want to duplicate an existing row in the table) but I want to do this without …

Read More