Welcome to WebmasterWorld Guest from 54.158.51.150

Forum Moderators: open

Message Too Old, No Replies

Copy Schema without Data

possible in mySQL

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

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