----- machiel.richards <machiel.richa...@gmail.com> 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/mysql?unsub=arch...@jab.org
