Magento 2.2.1 website move database import error 150

[CraigLambo]

We are in the the process of moving a website from one server to another, it all went smoothly until I started importing certain table data.

We are using phpmyadmin to import the '.sql' database, when trying to import certain table data it is showing an error 150 message (screenshot below).

The screenshot shows the SQL query I am trying run and the error 150 message.

Any help is much appreciated.

[CraigLambo]

Just to add to my query I have also tried adding 'SET FOREIGN _KEY_CHECKS=0;' at the beginning of the import file and adding 'SET FOREIGN_KEY_CHECKS = 1;' at the end of the database import file but this makes no difference at all.