Bug #754 Documentation: Tutorial section Using More Than one Table
Submitted: 30 Jun 2003 1:31 Modified: 30 Jun 2003 8:16
Reporter: [ name withheld ] Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:4.0.13 OS:Windows (Windows)
Assigned to: Paul DuBois CPU Architecture:Any

[30 Jun 2003 1:31] [ name withheld ]
For some reason I could not populate the data for the 'event' table correctly.
I copied and pasted the values from the html and replaced the spaces with tabs and loaded the file in with 'LOAD DATA LOCAL INFILE "event.txt" INTO TABLE event;'.

This resulted in half the table containing corrupt data.

Thinking it may be unprintable characters in my text file from copy and pasted I downloaded the menagerie.zip archive and used the event.txt file from there.

I still had the same problem.
In the end to carry on working through the tutorial I entered all the values manually.

How to repeat:
Follow steps of section

Suggested fix:
I'm not sure.
[30 Jun 2003 8:16] Paul DuBois
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Cutting and pasting from HTML will not necessarily work, though loading
from event.txt should work.

Please show the statements you used for loading the data, and show
the resulting messages so we can see the status of the load attempt.