Import from drizzledump fails

[Andrew Hutchings]

The following from a drizzledump errors:

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET utf8 */;

With the following error:

ERROR 1064 (42000) at line 13: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'CHARACTER SET utf8 */' at line 5

Question1: Should these version comments still be used by drizzledump because the next Drizzle is effectively the first version.

If yes then we either need this comment to be acceptable or removed.
If no then we need to remove all these comment insertions from drizzledump

Note: fix-bug-310275 drizzledump used, trunk broken at time of writing. Dump attached.

[Andrew Hutchings (linuxjedi)]

Compatibility comments need to be stripped out

[Andrew Hutchings (linuxjedi)]

Files created with drizzledump can now be imported into drizzle
Removed "DEFAULT CHARACTER SET" from CREATE DATABASE as this is no longer valid syntax