Autodelete

**first backups** Joined: 11 Jan 2012 Posts: 1

Autodelete seems to work OK when backing up locally but for remote FTP backups, it does not work. Is there a way to make this work so that I don't accumulate too many backup files on my remote server? Or is this something I have to set up on the remote server through a cron job there? Thanks

Posted: 2012-01-11, 10:03 Re: Autodelete

**knows MySQLDumper** Joined: 06 Feb 2012 Posts: 3

Hi,

I am working on this problem. At the moment you can:
- specify per FTP Server if you want to auto-delete (1st variable)
- specify per FTP Server how much backups you want to keep (2nd variable)
Writing this data to /work/config/mysqldumper.conf.php and /work/config/mysqldumper.php give problems with writing the 1st variable. When modifying the files, reading it works fine. Looks like a problem with PHP (not my programming language).

The cronscript is able to:
- read the correct information
- delete correct number of files from the FTP Server
At the moment, if you have multiple databases, it will do the reading of the files on the FTP Server for each uploaded databasxe file(s).
Also the multipart files are not recognized at the moment, it is only able to find/decide on single file backups. I need to find out how the files for multipart are made (db_date_time_partnumer.extention?).

If you are able/willing to help me with the mentioned problems, feel free to contact me.

**knows MySQLDumper** Joined: 06 Feb 2012 Posts: 3

Fixed the problem with the multipart files. I didn't want to open the files on the FTP-Server or download the files from the FTP-server to decide if it is a multipart file.

Still looking for someone who knows PHP and can help me with the problem that the variable autodelete on FTP server isn't written correctly to the config files.

If you want to test what I have got till now, feel free to contact me, I can tell you what and how to modify which files in order for the cronscript to work correctly.

Posted: 2012-02-06, 20:18 (No subject)

I don't understand what you are talking about.
You are talking about FTP, but the autodelete function is only for deleting files on the server where MySQLDumper is running.
The FTP option is for additionally transferring the backup files to another external FTP-Server. On the external FTP-Server the autodelete function is not active and won't remove files.

So what exactly do you mean when you say FTP?
Do you use the ftp option to transfer the backups to another ftp server or do you ftp the backups to the same server where MSD is running?

Posted: 2012-02-06, 22:54 (No subject)

It seems to me that pavdeijk has programmed a new feature in MSD 1.24.4 that should implement the autodelete functionality for using with the built in FTP option, but now needs a little PHP help for writing the config files.

If it is solid enough to not just run in his server environment but together with other server configurations, that would be a nice addon.

Posted: 2012-02-06, 23:02 (No subject)

Ah, now I understand. Didn't get that at first reading. Wink

@pavdeijk
If you post a svn-patch here, we might be able to help.

**knows MySQLDumper** Joined: 06 Feb 2012 Posts: 3

Hi DSB and Jens_K,

Sorry for my English, as my German is worse.

I modified the code of some files in order to display an option of enabling auto-delete on remote FTP-servers, save this information (otherwise it is not very useful...) and use this information in the file crondump.pl.
The way I made the changes should be universal, that is not only my testing-environment canuse this, but everyone who uses your program.

Jens is correct about my problem (at least for what a colleague needs). But I do not know how to make an SVN-patch.
I used the original files, and registered my changes with a coding, so you have to search for the coding to get the modifications.
And the program I use for typing the code (notyepad++) also removed the trailing spaces from the script, so comparing it will generate quite some differences between my local copy and one from the download.

If you can tell me (via a link) or show me how to make an SVP-patch, I'll be happy to help.
Or I can send you the modified files, so you can see the differences yourself. Let me know though PM.

Posted: 2012-02-08, 12:58 (No subject)

Hi pavdeijk,

In that case I would like to take a look at the code myself. Please mail your package to admin at mysqldumper.de .
Thanks in advance. Wink