deleting the saved db the one before???

I made a script that backups the database as sql file in the server. I mean script writes it into the harddrive, but everytime when i execute the script the harddrive loss another 3 mb. How can i modify the script to delete the one before when i execute it to write the new one???

Hi,
Just use fopen and the "w" method for write, which will reset the file pointer and overwrite the old file:

$fp = fopen("path/to/file/statement.sql", "w");

etc...

i have a backup.php and is like:
<?
exec('mysqldump -u username -p password db_name > /www/users/www.mysite.com/db_name.sql');
?>
and not working either...

you will need to open the file (fopen) and write nothing to it and save it, before you backup the server.

ok i did it...