Re: seeing errors

2017-03-26 Thread william drescher

On 3/25/2017 10:03 AM, Hal.sz S.ndor wrote:

2017/03/24 15:19 ... william drescher:

While loading a database using the mysql command 'source'  I see
occasional warnings flash by on the screen.

when it finished I used the command "show warnings," but only one
warning showed (the last one).

How can I see the warnings earlier in the load ?


There is an option to the client program mysql,
"--show-warnings", that not summaries but full messages are
shown. Furthermore, if, as by default, warnings, too, go to the
error log, you will find everything interesting there.


Thank you


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql



Re: seeing errors

2017-03-25 Thread Hal.sz S.ndor

2017/03/24 15:19 ... william drescher:

While loading a database using the mysql command 'source'  I see
occasional warnings flash by on the screen.

when it finished I used the command "show warnings," but only one
warning showed (the last one).

How can I see the warnings earlier in the load ?


There is an option to the client program mysql, "--show-warnings", that 
not summaries but full messages are shown. Furthermore, if, as by 
default, warnings, too, go to the error log, you will find everything 
interesting there.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql