I tried the full restore using that backup I did (the managed one on the cloud) but the process was failing... it was throwing up errors while importing the DB that the plugin backed up...
What I did was manually imported each table via PHPMyAdmin and all worked (took a long time) but I got the site up and running but during the upload one table didn't fully get imported,was getting timeout errors.
I thought this might still be ok to run the site but it turned out that order details from the Ecommerce (WooCommerce) side are missing now.
I was onto the support (hosting) and they tried to import that again but with some errors:
#1062 - Duplicate entry '17104' for key 'PRIMARY'