List:General Discussion« Previous MessageNext Message »
From:Nicola Salvemini Date:January 7 2010 1:44pm
Subject:Re: table export in cron
View as plain text  
----- 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!


      

Thread
table export in cronmachiel.richards6 Jan
  • Re: table export in cronGary Smith6 Jan
  • Re: table export in cronMikhail Berman6 Jan
    • Re: table export in cronsureshkumarilu6 Jan
Re: table export in cronMichael Dykman6 Jan
Re: table export in cronNicola Salvemini7 Jan
  • RE: table export in cronmachiel.richards7 Jan
    • Re: table export in cronJoerg Bruehe7 Jan
    • RE: table export in cronDan8 Jan