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