MySQL & CRON

2005-03-03 Thread shaun thornburgh
Hi, I have a web based that allows users to upload XML files and insert them into the database, however some of these files are large and are causing the webserver to timeout. Is it possible to create a cron job that can insert the xml files say every hour, then the users of the site would only

RE: MySQL/Cron problem

2003-09-18 Thread Jason Linden
rsday, September 18, 2003 1:42 PM To: 'Jason Linden'; [EMAIL PROTECTED] Subject: RE: MySQL/Cron problem What do you mean it doesn't release itself? Can you provide some free examples of before and after then 5 min after that? The indication from the content of the below message is tha

RE: MySQL/Cron problem

2003-09-18 Thread Dathan Vance Pattishall
D] -->Subject: RE: MySQL/Cron problem --> -->Somebody suggested that I create the cron job as a php scripts, so I -->did: --> -->include("dbinfo.inc.php"); --> -->$connect = MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable -->to connect to the dat

RE: MySQL/Cron problem

2003-09-18 Thread Jason Linden
en [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 2:32 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MySQL/Cron problem Tried it... didn't do anything. Also, there are 11 different instances of mysql running. Any ideas why? Or is that just how it works? -

RE: MySQL/Cron problem

2003-09-17 Thread Dathan Vance Pattishall
mailto:[EMAIL PROTECTED] -->Sent: Wednesday, September 17, 2003 11:32 AM -->To: [EMAIL PROTECTED]; [EMAIL PROTECTED] -->Subject: RE: MySQL/Cron problem --> -->Tried it... didn't do anything. Also, there are 11 different instances -->of mysql running. Any ideas why?

RE: MySQL/Cron problem

2003-09-17 Thread Jason Linden
EMAIL PROTECTED] Subject: Re: MySQL/Cron problem Hmmm, have you tried putting is a folling mysqladmin flush-threads command? -Original Message- From: Jason Linden [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:57 AM To: [EMAIL PROTECTED] Subject: MySQL/Cron problem I am fairly n

Re: MySQL/Cron problem

2003-09-17 Thread Tbird67ForSale
Hmmm, have you tried putting is a folling mysqladmin flush-threads command? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL/Cron problem

2003-09-17 Thread Jason Linden
I am fairly new to both linux and mysql. I have a cron job that runs every minute to move data from one mysql table to another (both tables are in the same database), see below: Cron job is: mysql -u *** --password=*** syslog < /var/scripts/updsysklog2 Script is: INSERT INTO sysklog2 (machi