mysqldump -u username -ppassword –no-data database_name > dump.sql mysqldump -u username -ppassword –no-create-info database_name > dump.sql mysqldump -u username -ppassword –databases db_name1 [db_name2 ...] > dump.sql mysqldump -u username -ppassword –all-databases > dump.sql mysql -u username -ppassword database_name