Mysql Import db dump Warnings/ Errors write in a file.
Posted on 2011-02-20
Im importing my database from mysql server version 5.0.4 to new mysql 5.5.8.
I have some 300 tables & I have used mysqldump to get the full dbSQL files.
Now in the new mysql server console Im choosing database & importing data from full sql files like this.
mysql> source ./fulldump.sql
While doing this I'm getting a lot of warnings particularly in the middle of import.
But since this import runs fast in console window & the final lines of import has no warnings.
So I couldn't see the full warnings/messages of the import.(Cant issue show warnings command at right place)
It doesn't contain errors, but it has ONLY warnings.
HOW SHOULD I REDIRECT THE CONTENT OF WARNINGS TO A LOG FILE WHILE IMPORTING ?