Backup website on VPS & fix database

I have a website on a VPS which has developed a database error. In order to fix this I am required to move the site to a new VPS, first having backed-up the existing database. The existing VPS has NO CONTROL PANEL which requires you to backup all data using SSH. As soon as I hire you, I will instruct the hosting company to create the new VPS AFTER you have backed up the existing data to your local machine. I requite an experienced web developer in Drupal & mysql database.