Database import Error in Migration Magento 1.9 Store

[foysal]

I am migrating a Magento 1.9 store to another hosting. While I am importing previous database to new phpmyadmin I am getting below error.

[Manish Mittal]

Hello @foysal 

Check Mysql version which you are using with new host. It should support current Magento version.

Check old Mysql version and use same to import it will solve your problem. Thanks

[foysal]

Thanks @Manish Mittal . Both are same. Thanks.

[Rahul Gupta]

@foysal Have you tried to install database via terminal?

Thanks

[Stuart M]

This looks suspiciously like either your export from your original host corrupted on download or it prematurely terminated on upload.

Depending on the size of your SQL file you might be better off uploading it to your server and using the mysql client over ssh which is much faster and able to process large imports.