Executing In Batch Mode

[susa]

would anyone have a sample of how to execute a script done in sqlyog using windows scheduler ? output would be directed to some file much like how the export function works in the sqlyog ide

[peterlaursen]

If I understand right you can use a SJA notifications job and “SELECT … INTO OUTFILE”

http://dev.mysql.com/doc/refman/5.0/en/select.html

says

Quote:

The SELECT … INTO OUTFILE statement is intended primarily to let you very quickly dump a table to a text file on the server machine. If you want to create the resulting file on some client host other than the server host, you cannot use SELECT … INTO OUTFILE. In that case, you should instead use a command such as mysql -e “SELECT …” > file_name to generate the file on the client host.

[Author]

Posts