MySQL backup and restore

• To restore a database from backup file
  #mysql db_name < backup-file.sql
  
  
• To dump one or set of databases
  #mysqldump --databases db_name1 [db_name2 ...] > my_databases.sql
  
  
• To dump all databases
  #shell> mysqldump --all-databases > all_databases.sql