Hello everybody. 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