Hi Machiel,
As an alternative, you might consider use of mysqdump command,
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html, in a KSH/BASH
script running from cron
The script might look like this:
=====
!#/bin/ksh
mysqldump --password=yourpassword [more switches needed here]
your_database your_table > /path/to/output/file
====
mysqldump command has switches to accomplish fields termination as you
need, plus it gives opportunity to specify target database via
--compatible=name
<http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html#option_mysqldump_compatible>switch.
Hoping this helps,
Mikhail Berman
machiel.richards wrote:
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
