[QUESTION]Auto Query

[T.h.u.n.d.e.r]

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

[chaosblade]

Nope, You have to open it an Run it.

[PraDevil[ELITE]]

guide on Windows XP
ok firstly u need to make a bat file..example like this

[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..

[MizTenshi]

Originally Posted by PraDevil

guide on Windows XP
ok firstly u need to make a bat file..example like this

[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 ******** it up

[T.h.u.n.d.e.r]

Originally Posted by PraDevil

guide on Windows XP
ok firstly u need to make a bat file..example like this

[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 ?