mysql 下载库里所有create table 语句

mysqldump -h localhost -u root -p --no-data --compact  some_db  
mysqldump -d --compact --compatible=mysql323 ${dbname}|egrep -v "(^SET|^/\*\!)"

来源是Stack Overflow