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 Utilizadores acharam útil
Esta resposta foi útil?

Artigos Relacionados

CentOS Web Panel Review – Introduction

CentOS Web Panel is a hosting control panel which centres around easy and quick management of the...

How to install FFmpeg on your VPS / Dedicated Server

In this tutorial we will show you how to install FFmpeg on your VPS/dedicated server running on...

How to terminate accounts on my Dedicated Server?

In this article we will show you an easy and efficient way to terminate accounts from your...

How to suspend / unsuspend accounts on my Dedicated Server?

As customers come and go, you might have various reasons to suspend or unsuspend accounts. So,...

Is Microsoft Exchange supported on my Dedicated Server?

All of our servers, including the Dedicated ones, are Linux-based. Microsoft Exchange is a...

Powered by WHMCompleteSolution