Re: Log Warnings Level

Kristen G. Thorson wrote: But all I really get from this reading is 0 turns it off, 1 prints some warnings, and 2 prints level 1 warnings plus aborted connections warnings. I have not been able to find any additional information in my search. Am I missing something, or is this all the docu

RE: Log Warnings Level

> -Original Message- > From: Colin Charles [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 17, 2007 9:08 PM > To: Kristen G. Thorson > Cc: mysql@lists.mysql.com > Subject: Re: Log Warnings Level > > Kristen G. Thorson wrote: > > Hi! > > > But

Re: Log Warnings Level

Kristen G. Thorson wrote: Hi! But all I really get from this reading is 0 turns it off, 1 prints some warnings, and 2 prints level 1 warnings plus aborted connections warnings. I have not been able to find any additional information in my search. Am I missing something, or is this all the doc

Log Warnings Level

The manual indicates that you can specify a specific level to control what types of warnings are logged: http://dev.mysql.com/doc/refman/5.0/en/server-options.html (See section on log-warnings.) But all I really get from this reading is 0 turns it off, 1 prints some warnings, and 2 prints level

Re: Warnings level

Hi, sorry for the noise, it may be useful for someone else : cat backup20050408.sql | sed 's/INSERT/SHOW WARNINGS;INSERT/' | sed 's/CREATE/SHOW WARNINGS;CREATE/' | sed 's/DROP/SHOW WARNINGS;DROP/' > backup.sql then use the backup.sql thus created. So I got :Invalid TIMESTAMP value in column 'tim

Re: Warnings level

Hi, I got back warnings, event when started with mysql -v -v, I don't have the Warnings appearing on the console... Do I really have to insert SHOW WARNINGS; in the dump file after each statements ??? On Apr 7, 2005 6:10 PM, Mister Jack <[EMAIL PROTECTED]> wrote: > Hi ! > > Thanks, for your answ

Re: Warnings level

Hi ! Thanks, for your answer. Indeed, I didn't think about the verbose option. I tried it and used "tee" to log data. Well so far I haven't got anymore Warnings (strange though...) :-) On Apr 5, 2005 9:50 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Mister Jack <[EMAIL PROTECTED]> w

Re: Warnings level

Mister Jack <[EMAIL PROTECTED]> wrote on 04/05/2005 01:38:00 PM: > Hi, > > I've got a dump file from my main DB (MySQL 4.1.10a), when I load it > with "source backup.sql" I can see some warnings around. Is there any > way to log those warnings, or to stop on warnings ? (show warnings > only show

Warnings level

Hi, I've got a dump file from my main DB (MySQL 4.1.10a), when I load it with "source backup.sql" I can see some warnings around. Is there any way to log those warnings, or to stop on warnings ? (show warnings only show warnings for the _last_ query if there is any). Thanks for your help -- MySQ