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.

[mahsharghasemiyeh]

Database backup for non-cPanel servers

1. Log into SSH; 
2. Find the backup folder; 
3. Once inside, type mysql DATABASE NAME BACKUP.sql, replacing DATABASE NAME with the database to which this backup will be restored.

Database backup for cPanel servers
1. log into your SSH
2. mysql -uUsername -pPassword -H localhost database name database backup.sql 

[johnsonisabella582]

Step 1: Using SSH, connect to your dedicated hosting server as root.

Step 2: Locate the MySQL database dump file.

Step 3: Once inside, manually execute the command below to import it into the database of your choice.