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.