How to get a spool file generated, along with the executed SQL script

You are viewing an old version of this question. View the current version here.

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

Comments

Comments loading...
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.