How to Restore or Recovering Mysql Database on Command line

Restoring/RECOVERY dumped content in Mysql in commend line

The following command is used for Recovery:

> mysql -u [username] -p -h [hostname] [database-name (or) database-name.table-name] < [backup-file].sql
> mysql -u root -p -h localhost db1.ta1 < db1.sql

Related Topic How to Restore MySQL Database from dump file
List of Mysql Error Code and Description
How to Backup Mysql Database on Command line
How to Change or Set New Root Password for Mysql Database
Remote Mysql Server SSH Login
SQL  mysql  database 2011   Privacy Policy  Terms of Service  Feedback