| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe and Support WebmasterWorld|
|Copy Schema without Data|
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 -----
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
© Webmaster World 1996-2013 all rights reserved