How to make database backup on my Dedicated Server?

In order to create a database backup you need to use your SSH console. Once inside, type:

For servers without cPanel:

mysqldump DATABASE_NAME > BACKUP.sql 

For servers with cPanel:

mysqdump -uUsername -pPassword -H localhost database_name > database_backup.sql

where you replace DATABASE_NAME with the actual name of your database. Running this command saves a copy of the database, called BACKUP.sql that you can keep for a later usage.

Should you experience any difficulties you can always contact our 24/7 Support Team who will gladly help you with your database backup.

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