Page 1 of 1

ERROR 1170 (42000) at line 102607:

Posted: Fri Jun 07, 2013 5:36 pm
by hillmandj
Hi,

I created a Access to SQL dump file using Bullzip, but when I imported it into MySQL Workbench, I received this error: ERROR 1170 (42000) at line 102607: BLOB/TEXT column 'SID' used in key specification without a key length

A number of the tables were imported, but not all of them. Not sure how to fix this issue, since the database that was dumped is quite massive. Any suggestions?

Thanks!

-D