Export (backup) and import mysql database on terminal

Following are the two methods:

Export (Backup)

$ mysqldump -u username -p database_to_backup --result-file backup_name.sql

with triggers and procedures

$ mysqldump -u username -p --routines database_to_backup --result-file backup_name.sql

This will store the sql file in the current directory.

Import

$ mysql -u username -p database_to_backup < backup_name.sql

This will store the sql file in the current directory.