How to log MySQL ERRORs using bat-file

Question

I run bat-file in Windows to clean MySQL Data Base at night. bat-file just use sql-script with simple delete-where operators.

code in bat-file like : "date /T >> cleaner_front.log" log some useful info to output file

code in script.sql file like : SELECT '14. delete from table (7 days)' AS '_'; SELECT NOW(); log some useful info too.

But if script.sql contains some errors (like table doesn't exists), error-message (ERROR 1146 (42S02) at line 56: Table '...' doesn't exist) was not written to output file

How can I write error messages from MySQL to common cleaner_front.log file during execution?

user2602807 · Accepted Answer · 2014-05-30 06:29:26Z

2

here is the launch string with error logging:

"path\to\mysql.exe" --host=host --user=user --password=pass -N -f < cleaner.sql 1> cleaner.log 2> cleaner_err.log

answered May 30, 2014 at 6:29

user2602807

1,2922 gold badges16 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jon Vote Over a year ago

Well looks like the poster didn't appreciate your help - but I do. Thanks.

Collectives™ on Stack Overflow

How to log MySQL ERRORs using bat-file

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related