hi.
if you're not on a windows box, try something like:
mysql -uroot -p <test.sql 2>&1 | tee output.log
the mysql client also has a --tee option, as well as a tee(\T) command that
could be of use.
-ravi.
-----Original Message-----
From: Mohammad Shoja [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 11:22 AM
To: [EMAIL PROTECTED]
Subject: Log HELP!
Mybe this is not a mysql question but a unix command line question:
would you please tell me how can I log execution of a DDL?
I have a test.sql which is a DDL file, I wanna log its output but when I
try the following it create log file but its empty.
mysql -u root databasename <test.sql >log
it Just send errors and logs to STDERR.
Thanks you for your helps in advance.
Regards
----------------------------------------------------------------------
Mohammadreza Shojatalab
European Bioinformatics Institute Tel: +44 (0)1223 494 669
EMBL Outstation Fax: +44 (0)1223 494 468
Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED]
Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja
CB10 1SD, UK
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php