Sometimes you just cannot get that mysql database file to import, even via the command line.

eg mysql -p -u username databasename < databasefile.sql and you get a nasty ERROR 2006 - MYSQL server has gone away message in return. The first obvious thought is that it is somekind of timeout issue, so you waste ages playing around with the interactive and wait timeout values. Try this instead, or in addition to the time out values.. Edit the /etc/my.cnf file and either add or edit the appropiate line in the [mysqld] block and make


Then restart mysql again:

service mysql restart

and try to import your database again – worked for me.