Help with manual migration

Hi

I’m new to WordPress but starting to enjoy it, however…

I have had a site built from my design which uses the Ultimatum theme.

It is hosted on a test site and we now need to migrate it to another host.

We have tried to use the WordPress Move and Migration Assistant, but it fails on the database transfer. I am sure it is an ftp issue but fails even when using a secure ftp.

I followed a post that showed an manual migration by downloading the backup files then uploading them to the new host and using the restore… I got success on all files using this method but nothing has loaded into the dashboard?

Am I missing something simple?

Thanks