<div>
Have you tried using the --tee switch to output everything to an output file..<br />
<br />
See complete command line reference below -<br />
<br />
<a href="http://www.techotopia.com/index.php/The_mysql_Command-Line_Tool" rel="ugc">http://www.techotopia.com/index.php/The_mysql_Command-Line_Tool</a>
</div>


Have you tried using the --tee switch to output everything to an output file..

See complete command line reference below -

http://www.techotopia.com/index.php/The_mysql_Command-Line_Tool [http://www.techotopia.com/index.php/The_mysql_Command-Line_Tool]

<div>
<div class="content wysiwyg-content">
When you run a sql script file in command line with MySQL you can redirect the output of the query in a file but not the errors apparently:<br />
<br />
&gt;mysql -uuser -ppassword &lt;&nbsp;sql_script_file &gt;&nbsp;output_file<br />
<br />
If the sql_script_file returns a result like table rows they will get into the output_file but if there is an error within the script it is not redirected to the outpyt_file but only to the console.<br />
<br />
How can I get the errors from a script file to be saved to a output_file with MySQL.
</div>
</div>


When you run a sql script file in command line with MySQL you can redirect the output of the query in a file but not the errors apparently:

>mysql -uuser -ppassword < sql_script_file > output_file

If the sql_script_file returns a result like table rows they will get into the output_file but if there is an error within the script it is not redirected to the outpyt_file but only to the console.

How can I get the errors from a script file to be saved to a output_file with MySQL.

MySQL: run sql script file in command line and get the erros in a log file

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.