Backup and Restore Mysql Database using Mysqldump

Below are mysqldump commands for backup and restore mysql database:

UNIX / LINUX

Backup:
mysqldump --opt --user=username --password database > dumpfile.sql

Restore:
mysqldump --opt --user=username --password database < dumpfile.sql
Notes:
- dumbfile.sql contains SQL command for creating tables and data. (CREATE,INSERT,DROP etc.)