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