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.

WebHostFace

Share
Published by
WebHostFace