If Central Backup Server is enabled for your vps, this means that your vps will be backed up once per day and stored on another server, your vps will stay online when this happens.
You can restore individual files by using the browse backup button from within your VPS Control Panel control panel. Click on the file manager tab and you will be able to browse your entire live backup.
To restore a file/directory, just copy the file/directory in the file manager, and then you can paste it back inside the file manager of the vps. (To paste the file in your vps via file manager in VPS Control Panel, remember the vps has to be powered off).
This will include your MYSQL databases which are stored in /var/lib/mysql
The way the central backup works is it takes a full copy of your VPS including the data and mysql databases, the backup is sequential it will store 3 backups in your central backup server
- daily.0
- daily.1
- daily.2
So you have a choice of the last 3 backups to take your files from should you need to.