Documentation :: Exporting SQL File Using MySQL Client

Type Password at the Prompt

mysqldump -h 127.0.0.1 -u db_user -p db_name > import_file.sql

Include Password in Command

mysqldump -h 127.0.0.1 -u db_user -psecretpassword db_name > import_file.sql