I am trying to import a MySQL dump file.
The file was created on a Linux server, I am trying to import on windows
I logged into the command line and ran:
But this seems to have thrown up some character set problems (specifically with smart quotes and other non standard punctuation).
It was suggested to me that I run:
mysql -u username -d dbase < c:\dump.sql
When I try this I get the error
ERROR 2006 (HY000) at line 149351: MySQL server has gone away
A bit of googling suggested that this was to do with the max_allowed_packet switch but I have tried this and it hasn't worked. Has anyone any idea what this could be?
If anyone has a suggestion about the character set issue that would be helpful too.