Good news. We have now been able to resolve the issues and are back on r1soft system.
We have also upgraded to latest R1 Soft features that enables end cPanel users (on shared servers only, not VPS) to be able to restore MySQL databases as well.
When the user clicks on r1soft icon in cPanel and is taken to r1soft backup manager, the next screen will show them option of restoring the files in their home directory as well as MySQL databases.
To restore a MySQL database, end user must first have an empty database with exact name created in cPanel and can then restore the data from r1soft backup.
The file restoration is done in the same way as before.
Thank you for your understanding.