In this article, author Deepak Vohra discusses the details of migrating an on-prem database to a MySQL database on the cloud, using AWS Database Migration Service.

You don't necessarily <B>have</B> to have root access to the MySQL server, but you should at least have an account with insert/update/etc. permissions on the database you're going to be importing ...

Appart from the 'Natural Detox', gilbrikc mayhave a point:- All MySQL prior to 4.1 are UTF-8 unaware and that may be causing fun on the import, it's a long shot but something to consider.