----- machiel.richards <[email protected]> wrote > > How can we do this when running in a cron script? >
Hi! You can use following command in a shell script running from cron: echo "select * from <table> into outfile '/path/to/output/file' fields terminated by '|';" | mysql --user=<youruser> --password=<yourpassword> <yourdatabase>; Bye! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
