sql cron
Posted by: The
Posted on: 2007-07-24 12:55:00
How do I run a .sql file cron??
I have this:
/usr/bin/mysql publicsize --user=limited --password=mypasshere < /home/ryannaddy/cron/logOut.sql
Posted by: The
Posted on: 2007-07-24 12:55:00
How do I run a .sql file cron??
I have this:
/usr/bin/mysql publicsize --user=limited --password=mypasshere < /home/ryannaddy/cron/logOut.sql
Posted by: Tor
Posted on: 2007-07-24 14:56:00
In shell is one way.
tor.eff.org
Promos: MaxTOR: Save Maximum TOR: Save Maximum and give $1 to TOR
Posted by: Lensman
Posted on: 2007-07-24 16:15:00
Are you asking how to set up a cron job or how to run a .sql script in a cron job?
Posted by: The
Posted on: 2007-07-24 16:29:00
I know how to make one, but I am getting errors, when I run that command in PuTTY, Error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I don't know the popper command to enter into the text field, so that when my cron job is run, it executes properly, that is what I need help with.
when the .sql file gets run, this is the code that is within the file:
UPDATE `users` SET `onlineStatus` = '0' WHERE `onlineStatus` = '1' AND (UNIX_TIMESTAMP(NOW())-`lastAccess` > 1800);