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 'timestamp' at row 5407; (I still have to figure this out :) On Apr 8, 2005 6:08 PM, Mister Jack <[EMAIL PROTECTED]> wrote: > 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 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]> 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 for the _last_ query if there is any). > > > > Thanks for your help > > > > > > > > > > You can see more details if you launch your client with one of the > > > "verbosity" options. Use a -v, -v -v, or -v -v -v to increase the > > > verbosity > > > of your client. > > > > > > For more client options (at a shell prompt): > > > > > > mysql --help > > > > > > Shawn Green > > > Database Administrator > > > Unimin Corporation - Spruce Pine > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
