Running cronjob on php script -> constantly running out of disk space

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • coool
    New Member
    • Aug 2007
    • 67

    Running cronjob on php script -> constantly running out of disk space

    Hi

    I'm trying to run a cronjob on a php script

    everything is working fine, but I'm getting my server disk space fulled up - so what's wrong here ???

    how can I fix this problem ?
  • pbmods
    Recognized Expert Expert
    • Apr 2007
    • 5821

    #2
    Heya, Coool.

    Changed thread title to better describe the problem.

    What does your cron job look like? Is it creating any temporary files or modifying a database?

    Comment

    • gregerly
      Recognized Expert New Member
      • Sep 2006
      • 192

      #3
      Originally posted by coool
      Hi

      I'm trying to run a cronjob on a php script

      everything is working fine, but I'm getting my server disk space fulled up - so what's wrong here ???

      how can I fix this problem ?
      <joke>
      My guess......wait for it.....

      Is your disk space getting filled up?
      </joke>

      Ok, seriously, we need more info on what your cron job is trying to do, and that might shed a little light on why your disk space is being all used up.

      Greg

      Comment

      • coool
        New Member
        • Aug 2007
        • 67

        #4
        alright :)

        my cron job run a php script every 10 minutes

        this php script has 3 calls to functions in another page

        I have few tables already in my database

        a call to remove database table -- (i have to do that)
        a call to create table in my database
        a call to read a table in text format (url) -- and insert this data into my database table

        -----------

        now in the page that have these functions

        it's as normal as create table - delete table - open file/read it/insert data to database table

        but yeah I have a temp. table created after inserting all the data in a table
        why ! because I wanted to group by all table by one field
        and I did that by creating a tempTable that select all feilds in oldtable and group them by one field -> then delete my old table -> then change the name of this tempTable to my old table name

        so what do you think now the problem ?

        Comment

        • pbmods
          Recognized Expert Expert
          • Apr 2007
          • 5821

          #5
          Heya, Coool.

          Have you checked to make sure that only the correct data is getting copied?

          Is your script perhaps creating too many tables or not properly dropping the ones it creates?

          Comment

          Working...