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.