MySQL loader warnings - where are they?

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #294,451

10/9/07 9:19:21 AM

MySQL loader warnings - where are they?

I must have something broke but I can't tell what.

This is what the load tells me:
Query OK, 10071264 rows affected, 65535 warnings (49.37 sec)
Records: 10071264 Deleted: 0 Skipped: 0 Warnings: 10071264

The data looks OK, but that doesn't mean I didn't break something.
Where can I find the exact message, or what setting to I need to notch up to show me?

Post #294,523

10/10/07 1:15:35 PM

"show warnings" on command line

Post #294,570

Picture of static

10/11/07 2:06:59 AM

So what warnings were you getting?

I'm curious.

Wade.

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed

Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please

-- "Anything but Ordinary" by Avril Lavigne.

· my ·
· [link|http://staticsan.livejournal.com/|blog] ·
· [link|http://yceran.org/|website] ·

Post #294,585

10/11/07 3:30:33 PM

Stupid misaligned data stuff

Pure user error in construction of load file.
Could see it when I glanced at the loaded data, but I'd rather see the error at the moment.

MySQL loader warnings - where are they? - (crazy) - (3) - Oct. 9, 2007, 09:19:21 AM EDT

"show warnings" on command line -NT - (crazy) - (2) - Oct. 10, 2007, 01:15:35 PM EDT

So what warnings were you getting? - (static) - (1) - Oct. 11, 2007, 02:06:59 AM EDT

Stupid misaligned data stuff - (crazy) - Oct. 11, 2007, 03:30:33 PM EDT

Rebuild the remnant of the Obelisk, one mile from the pyramid.
44 ms