Error 1044 when importing DATABASE

[simon1066]

Not sure if this helps but I had a similar issue, although not the exact same error messages, when moving to a new host, yesterday.

I found that exporting from within phpmyadmin and then importing to the new host, again within phpmyadmin, did not work (can't remember the errors I received).

I managed to successfully complete the transfer by exporting the database using cPanel database backup facility and then importing that into the new phpmyadmin. Seemed to work fine.

[Mthirty5]

Not sure if this helps but I had a similar issue, although not the exact same error messages, when moving to a new host, yesterday.

I found that exporting from within phpmyadmin and then importing to the new host, again within phpmyadmin, did not work (can't remember the errors I received).

I managed to successfully complete the transfer by exporting the database using cPanel database backup facility and then importing that into the new phpmyadmin. Seemed to work fine.

Thanks Simon. I've tried this and it has solved the problem.