I managed to recover the database in Ubuntu 18.04. Here is how I have done it, if anybody has the same problem. I am assuming MySQL (server and client) is installed. First stop MySQL
sudo systemctl stop mysqlExtract the raw database files from the compressed file in a folder, e.g. mydatabase. Move the folder to the mysql folder. For Ubuntu it is at /var/lib/mysql
sudo mv mydatabase/ /var/lib/mysqlIMPORTANT! Change the owner of the folder to mysql. If you don't do that you will get access errors when trying to check and repair the database.
sudo chown -R mysql:mysql /var/lib/mysql/mydatabaseStart MySQL
sudo systemctl restart mysqlCheck and repair the database
mysqlcheck -u root -p mydatabaseYou can now dump the database to a .sql file. You can do that from the shell or use phpMyAdmin. I used phpMyAdmin. Finally, login to your Heliohost account's cPanel and import the .sql file using phpMyAdmin. Done!