Hello.
There is no direct way to load warnings into log files. But you may use a small value for max_error_count and launch mysql in a batch mode saving results in the file. Marcus Bointon <[EMAIL PROTECTED]> wrote: > I'm migrating a MySQL 3.23 db to 4.1.10 (on Linux x86) and I'm getting > some infrequent warnings when importing data dumps created with > mysqldump, but I can't seem to find out what the warnings are. > > I'm typically importing around 100,000 records at a time, so using > 'SHOW WARNINGS' manually is no use - and I can't yet nail down a query > that actually generates a warning anyway. > > I can start the mysql client using -v, but as even at the lowest level > or verbosity it always displays the query, and since my inserts are > often 30k per record, it's just not practical to scan the output, plus > it makes it go very slowly. > > I've got log-warnings in my my.cnf file, and mysqld is definitely > picking it up (adding it made log-warnings appear as set to 2, though I > can't find any reference in the docs for what the values mean), but > mysql is not logging any warnings at all. > > I have log-error=/var/lib/mysql/mysql.err set in my.cnf, and again it's > definitely being picked up by the server. > > If it makes a difference, I'm using all InnoDB tables. > > All I need is for warnings to be logged along with the query that > caused it without having to log everything and trawl through it - what > have I missed?! > > Marcus -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
