Hello.
You should also redirect stderr to the output file. The way it's done depends on the used shell. But usually you should use '2>' instead of '>'. [EMAIL PROTECTED] wrote: > > Hi, > Thank you for your reply. I tried even with --tee option with > mysql as follows > > Mysql -uroot db_name --tee =3D test < 'input_file' > 'output_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 [mailto:[EMAIL PROTECTED] > 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: >>=0D >> Hi, >>=0D >> What is the command to create log file while executing mysql >> command. >>=0D >> I.e I want to run a file using mysql as follows >>=0D >> Mysql -uroot db_name < "Inputfile" >>=0D >>=0D >> 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. >>=0D >>=0D >> PS: Input file contains some sql statements. >>=0D >>=0D >> Please help me in this. This is very urgent. >>=0D >> Thanks, >> Narasimha >>=0D >> -----Original Message----- >> From: Gleb Paharenko [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, March 09, 2005 11:16 PM >> To: mysql@lists.mysql.com >> Subject: Re: Access Denied >>=0D >> Hello. >>=0D >> Right. No need to FLUSH PRIVILEGES after GRANT.=3D0D >>=0D >> My fault, sorry.=3D0D >>=0D >>=0D >> Michael Stassen <[EMAIL PROTECTED]> wrote: >>>=3D0D >>> Gleb Paharenko wrote: >>>> Hello. >>>>=3D0D >>>> Execute FLUSH PRIVILEGES after granting. >>>> See: >>>> http://dev.mysql.com/doc/mysql/en/flush.html >>>> http://dev.mysql.com/doc/mysql/en/privilege-changes.html >>>=3D0D >>> Yes, please read this one. FLUSH PRIVILEGES is NOT needed after >> GRANT,=3D0D >>> REVOKE, or SET PASSWORD. You only need to FLUSH if you directly edit >> the=3D0D >>> grant tables (INSERT, UPDATE, DELETE). Since he/she is using GRANT, >> FLUSH=3D0D >>> PRIVILEGES is unlikely to be relevant. >>>=3D0D >>>> http://dev.mysql.com/doc/mysql/en/access-denied.html >>>> http://dev.mysql.com/doc/mysql/en/user-resources.html >>>>=3D0D >>>> Connect to the server using mysql command line client using > specified >> in GRANT statement >>>> username and password to check that the problem not in MySQL server. >> What output does the=3D0D >>>> following statement produce: >>>>=3D0D >>>> SHOW GRANTS FOR 'metal-host'@'localhost'; >>>=3D0D >>> Run this when it works, and then again when it doesn't. If the > result >> is=3D0D >>> different, then something is changing the privileges assigned to=3D0D >>> [EMAIL PROTECTED], so the solution will involve finding what is >> doing=3D0D >>> that. If the privs are the same, then we need to look elsewhere. >> From the=3D0D >>> (not entirely clear) description, I expect the first case. >>>=3D0D >>>> What exact version of MySQL server do you use? >>>>=3D0D >>>> [snip] >>>>=3D0D >>>> Hello Gleb, no i m not doing flush..i dont even know what flush is. >>>> do u have anything in mind ? >>>>=3D0D >>>> [snip] >>>>=3D0D >>>=3D0D >>> Michael >>>=3D0D >>>=3D0D >>> Metal Host Contact wrote: >>>=3D0D >>> > I have installed in a single user called "metal-host" more than 10 >>> > databases all with different names and in different php scripts >> (phpbb >>> > phpnuke mambo etc). >>> > the problem is that they only work as I install them,after some > hour >> later >>> > all the scripts show me that error : Access denied for user: >>> > '[EMAIL PROTECTED]' (Using password: YES) .... >>> > then im trying to do : GRANT ALL PRIVILEGES ON somethign.* TO >>> > [EMAIL PROTECTED] IDENTIFIED BY "password"; and then each >> database that >>> > i re-give the GRANT all command works perfectly..but for 1 minute >>> > only,then it gives me the same : Access denied for user: >>> > '[EMAIL PROTECTED]' (Using password: YES) .... So is there any >>> > limitation for the number of DBases that each user should >>> > run ? >>> > >>>=3D0D >>=0D >>=0D >> --=3D0D >> For technical support contracts, goto >> https://order.mysql.com/?ref=3D3Densita >> This email is sponsored by Ensita.NET http://www.ensita.net/ >> __ ___ ___ ____ __ >> / |/ /_ __/ __/ __ \/ / Gleb Paharenko >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET >> <___/ www.mysql.com >>=0D >>=0D >>=0D >>=0D >> --=3D0D >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >>=0D >>=0D >>=0D >>=0D >> Confidentiality Notice=3D0D >>=0D >> The information contained in this electronic message and any > attachments to=3D >> this message are intended >> for the exclusive use of the addressee(s) and may contain confidential > or=3D >> privileged information. If >> you are not the intended recipient, please notify the sender at Wipro > or=3D >> [EMAIL PROTECTED] immediately >> and destroy all copies of this message and any attachments. >>=0D > > > --=0D > For technical support contracts, goto > https://order.mysql.com/?ref=3Densita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > --=0D > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > Confidentiality Notice=0D > > The information contained in this electronic message and any attachments to= > this message are intended > for the exclusive use of the addressee(s) and may contain confidential or= > privileged information. If > you are not the intended recipient, please notify the sender at Wipro or= > [EMAIL PROTECTED] immediately > and destroy all copies of this message and any attachments. > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
