MySQL Backup and Restore

Restoring a MySQL Database using command line:

mysql -u user_name -p database_name < file_mysql.sql

Backup a MySQL Database using command line:

mysqldump -u user_name -p database_name > file_mysql.sql