This is odd, I’ve never had a problem moving a site if I use an export saved by phpMyAdmin. That’s how I usually move sites. If you can you should try the export/import process again. Make sure you export all of the DB tables. Also, make sure you add the “DROP TABLE IF EXISTS” statement when doing the export, these are the only things in an export that I know of that might cause a problem.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users