homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

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


Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved