How to get a spool file generated, along with the executed SQL script
We are migrating DB from Oracle to MariaDB. As part of schema objects installation, in Oracle, a script file was run. This contains the information on where and what needs to be the spool file that is to get generated, that track the script execution. While trying to run a similar script for MariaDB, we are unable to generate the spool file. We tried a reference that we found in https://lists.mysql.com/mysql/96132. But, with last option mysql database < script.sql > output.txt
we are getting the output.txt
, but with no tracking info of the script.sql
executed. Please advice, how we could include tee output.txt
within script.sql
to track the script execution in spool.
MariaDB version - 10.2.6
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.