How to enable standard account SSH access on a dedicated server?

Once you have logged to your dedicated server as root via SSH, type the following command in order to create a backup of your database:

mysqldump DATABASE_NAME > BACKUP.sql

Change DATABASE_NAME with the actual name of the database you want to back up.

This will create a backup file of your database called BACKUP.sql that you can later use to restore your information from.

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