Welcome to WebmasterWorld Guest from 54.234.63.187

Forum Moderators: open

Message Too Old, No Replies

Copy Schema without Data

possible in mySQL

     

txbakers

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

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



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

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

WebmasterWorld Senior Member 10+ Year Member



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

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

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



---- excellent -----

thanks.

 

Featured Threads

Hot Threads This Week

Hot Threads This Month