Mysql database table structure Export

Mysql database table structure Export command line specific usage: mysqldump-u using anonymous name-p password-d database name Table Name> Script Name; export the entire database structure and data mysqldump-h localhost-uroot-p123456 database> dump. SQL export a single data table structure and data mysqldump-h localhost-uroot-p123456 database table> dump. SQL www.2cto.com exports the entire database structure (excluding data)/usr/local/mysql/bin/mysqldump-uroot-d entrym> dump. SQL export a single data table structure (excluding data) mysqldump-h localhost-uroot-p123456-d database table> dump. SQL author Yan Zhiwei