search

Spodii / netgore

Cross platform online rpg engine using C# and SFML
http://www.netgore.com/
40 stars 16 forks source link

Invalid database dumps #256

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Make sure "USING BTREE" is removed from dumps. Also, why is it even added? 
Initial research shows that it shouldn't be created in later versions of 
mysqldump. Is there some better way to remove it than just deleting the text?

Original issue reported on code.google.com by Spodiii on 18 Nov 2010 at 10:17

GoogleCodeExporter commented 9 years ago 
I dropped the index and added it back by hand-written SQL, and that seemed to 
make it stop adding the key to the dump. So I think the issue has just been 
that Navicat MySQL adds USING BTREE when you use a unique index on varchar, 
making it appear in the dump.

Should be fine now, and I have a note written to remind myself to double-check 
for it before the next release.

Original comment by Spodiii on 18 Nov 2010 at 11:23