sql cron

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

Re: sql cron

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

Re: sql cron

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?

Re: sql cron

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);

Tags: cronusr binsql