Page 1 of 1

Restore a database to dedicated server

Posted: Wed Sep 02, 2015 10:36 pm
by dylanjonathan147
Hello all,

I am not able to restore my database to server via ssh.Anybody know
how to restore a database to dedicated server through SSH.

Thanks

Re: Restore a database to dedicated server

Posted: Fri Sep 04, 2015 3:46 pm
by brownbenjamin4
First logged in to dedicated server as root via SSH, and then go to the folder where we want to put the file of database. Once in it, type the following command to import it into the selected database:

mysql DATABASE_NAME < BACKUP.sql

DATABASE_NAME is replacing with the actual name of the database into which we want to save the backup.