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 ?

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?

<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

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 ?

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?