Documentation

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