Exporting an SQL file using the mysql command line
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