Mantis Bug Tracker - Forums

hello,

I'm on fedora core 4 , mantis 1.0.5 and xampp 1.5.3, I'm a newbie in mantis and linux, but I want to make a script or something like that wich make daily backups of mantis database, with the attached files, and send it to an ftp account . Is it possible? and if yes , does anyone have an idea?

Thank you in advance.

It's definitely doable, yes.

Assuming your attached files are stored in the database, you might be able to use the code at http://www.phpfreaks.com/script/view/11.php . NOTE: I've never used it, just found it.

Personally, we have a relatively 'complete' script that dumps the database, zips it and the current Mantis code, stores it remotely and then rotates the backups. Unfortunately, it's not something that I can give you.

But be assured that it is fairly simple, yes. You can use the mysqldump command line app to dump the database to a text file and then from there you can do whatever you like. Whether you do all of this from a PHP file using exec or you just do it all in a shell / batch script, well, it's up to you.

thank you for your help,
I made it already and you're right it's quite simple. I've just used the mysql dump command in a script and set it up in a cronjob. thank you anyway