Restore a database to dedicated server

[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

[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.