Copy Schema without Data

possible in mySQL

[txbakers]

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......

[andreasfriedrich]

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.

[txbakers]

---- excellent -----

thanks.