Hi all
I have a question regarding exporting of tables to a file
from mysql.
We need to export tables from mysql to a delimeted file
which will then be imported into another database (oracle).
We can do this manually from within mysql using the
following command:
select * from <table> into outfile
'/path/to/output/file' fields terminated by '|';
This needs to be configured though to be run in a cron once
every week at a specific time.
How can we do this when running in a cron script?
Your assistance is appreciated.
Regards
Machiel
