[QUESTION]Auto Query

I have got asaved query but i need to know if it can run auto after i close the server without runing it ?

Nope, You have to open it an Run it.

guide on Windows XP
ok firstly u need to make a bat file..example like this
red = where your mysql.exe located
green = username and password(mysql)
blue = where your query located(the query must be in SQL)

save it in .Bat file

ok then open control panel-->Scheduled Task

click Add Scheduled Task then click
next--->Browse for your .Bat file
then set your time your self..

Quote:

Originally Posted by PraDevil guide on Windows XP ok firstly u need to make a bat file..example like this Code: [COLOR="Red"]C:\wamp\mysql\bin\mysql.exe[/COLOR] -u [COLOR="SeaGreen"]root[/COLOR] -p[COLOR="SeaGreen"]test[/COLOR] -D my -e "source [COLOR="RoyalBlue"]C:\test.sql"[/COLOR] red = where your mysql.exe located green = username and password(mysql) blue = where your query located(the query must be in SQL) save it in .Bat file ok then open control panel-->Scheduled Task click Add Scheduled Task then click next--->Browse for your .Bat file then set your time your self..

thank you for explaining it >.< i kept screwing it up :(

Quote:

Originally Posted by PraDevil guide on Windows XP ok firstly u need to make a bat file..example like this Code: [COLOR="Red"]C:\wamp\mysql\bin\mysql.exe[/COLOR] -u [COLOR="SeaGreen"]root[/COLOR] -p[COLOR="SeaGreen"]test[/COLOR] -D my -e "source [COLOR="RoyalBlue"]C:\test.sql"[/COLOR] red = where your mysql.exe located green = username and password(mysql) blue = where your query located(the query must be in SQL) save it in .Bat file ok then open control panel-->Scheduled Task click Add Scheduled Task then click next--->Browse for your .Bat file then set your time your self..

Thanks but i get little proplem when i Browse for the .bat file its wont appears i think i need to make it .xml bcuz the task need an XML files and wont take the bat its says the format of the task is not vaild ! any ideas ?