MySQL Bugs: #55500: Workbench fails to load sakila database

Bug #55500	Workbench fails to load sakila database
Submitted:	23 Jul 2010 9:02	Modified:	17 Nov 2010 18:47
Reporter:	Daniël van Eeden	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.25	OS:	Windows (Windows Server 2008 R2)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
I've downloaded sakila-db.zip from http://dev.mysql.com/doc/index-other.html

Loading sakila-schema.sql works fine but loading sakila-data.sql fails.

It first says the file needs to be converted from LATIN1 to UTF-8 and then loads the file. Running the file breaks on line 153. The file has 153 lines according to MySQL Workbench, but 165 according to a 'wc -l' on a UNIX system.

How to repeat:
Load sakila-schema.sql
Load sakila-data.sql

bug #57636 was a duplicate of this, but since that was closed 1st, Im marking this a duplicate instead