Export DB and No Import???

Exported the DB with accurate setting as per both the hosting and domains, first thing I discovered is there is no import.
When I imported the exported-file into MySQL directly the new website went down and is unacceptable due to infinite loop of redirection.

Much better plugin to do the job is “ALL IN ONE WP MIGRATION” – the only restriction is that FREE version support only less than 512MB files size import. Rest it does everything perfect and without any issues.