Error Empty Query

MySQL error - 1065 - Query was empty - is returned when I try to load civicrm_data.mysql or civicrm_generated.mysql

This error is caused by an issue with a few versions of MySQL and the commenting style used in some lines in those sql scripts.

You'll need to go through the civicrm_data.mysql file in a text editor and remove the leading and trailing comment characters on the lines which have them....

So this...

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

becomes this...

SET @OLD_CHARACTER_SET_CLIENT=@
@CHARACTER_SET_CLIENT;

These comments are designed to insure that older versions of MySQL don't "see" commands that they don't support - but your MySQL version doesn't implement this commenting convention correctly for some reason.