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
<code>
Example:
<code>
> 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  

nScraps.com 2011   Privacy Policy  Terms of Service  Feedback