Backup / Restore data to a new database

Hello,

I've been having issues with my hosting company so I finally installed FrontAccounting locally. 

I'm trying to backup and resotre the data from my hosting company database to my local instance.

I know it's not as easy as using the back/restore function in FrontAccount and making a backup on the hosting database and then restoring to my location instance.  (as I tried that many times in the past)

So is there a guide or does someone have the steps to do this.