How to restore a database backup on Dedicated Server?

We have already seen how easy it is to create a database backup via SSH. The procedure for restoring this backup is no different and here are the steps:

Database Backup for servers without cPanel
  • log into your SSH;
  • locate the folder where your backup is kept;
  • once inside type mysql DATABASE_NAME < BACKUP.sql  and replace DATABASE_NAME with the database where this backup will be restored.
Database Backup for servers with cPanel
  • log into your SSH;
  • mysql -uUsername -pPassword -H localhost database_name < database_backup.sql

Should you experience any difficulties you can always contact our 24/7 Support Team who will gladly assist you in this matter.

  •  
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

CentOS Web Panel Installation – Step by step Guide

In this article, we will show you how to make a working CentOS Web Panel Installation. To avoid...

CentOS Web Panel Review – Introduction

  CentOS Web Panel is a hosting control panel which centers around easy and quick management...

Install PHP Libraries on a CentOS

There are several ways to install PHP Libraries that your installation can utilize on a VPS or...

Install Python’s PIP on a CentOS Server

PIP is Python’s Package Manager, with it you can easily install libraries and additional Python...

Install Python’s PIP on a Debian Server

If you’re using a Debian server that’s hosting a Python application you might need to have...