MySQLDump: Dumping Just the Schema

   By chris on January 21st 2008 in /dev/random | 1,664 views

I always forget the syntax for just dumping the schema of a database:

~/: mysqldump -u root -pmypassword test_database --no-data=true --add-drop-table=false > test_dump.sql

2 Responses to “MySQLDump: Dumping Just the Schema”

  1. tony responded on 08 Feb 2008 at 11:52 am #

    Thank you

  2. helmi03 responded on 22 Oct 2008 at 10:03 am #

    Thanks, save my day :-)

Trackback URI | Comments RSS

Leave a Reply