Re: table export in cron

[Nicola Salvemini]

----- machiel.richards <machiel.richards@stripped> 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!