On Monday, March 14, 2005 03:27, [EMAIL PROTECTED] wrote: > Hi, > Thank you for your reply. I tried even with --tee option with > mysql as follows > > Mysql -uroot db_name --tee = test < 'input_file' > 'output_file' >
mysql -uroot db_name < input_file 1> output_file 2> err_file > But in the out put file I am getting as below > > Logging to file 'test' > > Actual error is not logging into the ouput file. I am able to see the > error messages in the command prompt. How to get these error messages > in the output file. Please help me in this. > > Thanks, > Narasimha > > -----Original Message----- > From: Gleb Paharenko > Sent: Friday, March 11, 2005 7:34 PM > To: mysql@lists.mysql.com > Subject: Re: Reg creating log > > Hello. > > You may use --tee option of mysql to store the results in the file. > Or just redirect the output: > mysql -uroot db_name < 'input_file' >'output_file'. > > See: > http://dev.mysql.com/doc/mysql/en/mysql-commands.html > > [EMAIL PROTECTED] wrote: >> >> Hi, >> >> What is the command to create log file while executing mysql >> command. >> >> I.e I want to run a file using mysql as follows >> >> Mysql -uroot db_name < "Inputfile" >> >> >> I want to log the above results into a log file, to do the same >> what option I have to use here with mysql command. >> >> >> PS: Input file contains some sql statements. >> >> >> Please help me in this. This is very urgent. >> >> Thanks, >> Narasimha -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]