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.