How to restore a database on my Dedicated server via SSH?

Once you have logged in to your dedicated server as root via SSH, go to the folder where the dump file of your database resides. Once in it, type the following command to import it into the selected database:

mysql DATABASE_NAME < BACKUP.sql

Change DATABASE_NAME with the actual name of the database into which you want to restore the backup.

Note that if the dump file of your database contains a "CREATE DATABASE" clause you will have to delete this line from the dump file. Since it contains only plain text, you can use any text editor to do that.

You need help managing your dedicated server? We got it! SiteGround experts not only write helpful articles, but also manage the servers for our clients so they don’t have to read articles like this one.Learn more.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to reboot your dedicated server via WHM?

The WHM panel provides two options for a server reboot: Forceful Server Reboot Graceful...

How to change the password for the root user via WHM?

In order to change the password for the root user you will need to access the WHM panel and...

How to access WHM?

WHM stands for Web Host Manager. This is the cPanel's server administrative management software....

How to restart a service on my dedicated server?

In order to restart a service on your dedicated machine, follow these steps: Log in your WHM...

How to edit the MX records of a domain on my dedicated server via WHM?

In order to edit an MX record of a domain on your dedicated server, follow these steps: Log in...