Hello,
I have managed to complete successfully the migration; below are the steps i followed.
I exported the DB form the original destination through phpmyadmin.
I went to the new server and created a new empty database and gave it the name of the exported one.
I then created a new user, same credentials as the exported one.
I imported the db with no errors.
I then installed invoice ninja on the preferred domain name through softaculous.
Finally, I edited the env file to match the migrated DB and the app key.
I hope that helps someone.