MySql Database backup command - mysqldump

Syntax:
mysqldump [options] -h hostname -u username -p password database|--all-databases [tables] > backupfile.sql

Example:

• mysqldump -h localhost -u root -p test > backup.sql
• mysqldump -h localhost -u root -p test mytable > backup.sql
• mysqldump -h localhost -u root -p --all-databases > backup.sql