cancel
Showing results for 
Search instead for 
Did you mean: 

Database import Error in Migration Magento 1.9 Store

Highlighted

Database import Error in Migration Magento 1.9 Store

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.


david_queens.png

4 REPLIES 4
Highlighted

Re: Database import Error in Migration Magento 1.9 Store

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

 

 

Problem solved? Click Kudos & Accept as Solution!
Highlighted

Re: Database import Error in Migration Magento 1.9 Store

Thanks @Manish Mittal . Both are same. Thanks.

Highlighted

Re: Database import Error in Migration Magento 1.9 Store

@foysal Have you tried to install database via terminal?

 

Thanks

Highlighted

Re: Database import Error in Migration Magento 1.9 Store

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.

--
Problem solved? Click Accept as Solution!