Restore MySql Database

Restore MySql Database

 

I've just posted Backup MySql Database a few days ago, now i want to share about how to Restore MySql Database. Let's rock..

example :   username : tesaja
   password : 12345
   database name : coba
   database file that want to restore : coba.sql
   backup location : /home
sintaks :
mysql -u [username] -p [password] [databasename] < /backup_location/database_file

So..the command is
mysql -u tesaja -p 12345 coba < /home/coba.sql