BASIC MYSQLDUMP USAGE EXAMPLES


mysqldump -u ${USER} -p${PASSWORD} ${DATABASE}  > /path/to/${DATABASE}.dump.sql


mysqldump -u ${USER} -p${PASSWORD} --all-databases > /path/to/dumpfile.sql


mysql -u ${USER} -p${PASSWORD} ${DATABASE} < /path/to/${DATABASE}.dump.sql


mysql -u ${USER} -p${PASSWORD} < /path/to/dumpfile.sql

Consider also using additional arguments:
 


--single-transaction
--quick
--lock-tables=false

 
+INFO in the docs.