Copy Schema without Data

Forum Moderators: open

Message Too Old, No Replies

possible in mySQL

9:09 pm on Jan 27, 2007 (gmt 0)

I'm using mySQL 5.X and was wondering if there was a way to copy all the tables from a schema without copying all the data with one command.

I'd like to rebuild the schema, but don't need all the data, and don't want to recreate all the tables again......

9:23 pm on Jan 27, 2007 (gmt 0)

Hi txbakers, you can use

mysqldump

[dev.mysql.com] with the

--no-data

option. This will create just the DDL statements for the tables you specify without any data.

1:24 pm on Jan 29, 2007 (gmt 0)

---- excellent -----

thanks.