Bug #754 Documentation: Tutorial section 3.3.4.9 Using More Than one Table

• Submitted: 30 Jun 2003 1:31
• Modified: 30 Jun 2003 8:16
• Reporter: [ name withheld ]
• Status: Can't repeat
• 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 ]

Description:
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 3.3.4.9.

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
http://bugs.mysql.com/how-to-report.php

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.
Thanks.