Linux: Backup and restore MySQL database using mysqldump

Backing up database using mysqldump:

mysqldump -u [username] [dbname] > [dump_filename]

Restoring file from a backup:

mysql -u [username] [dbname] < [dump_filename]

References

• MySQL 5.1 Reference Manual :: 4.5.4 mysqldump
• mysqldump.com