daily backups

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
xavier
Posts: 4
Joined: 25 Sep 2006, 07:57

daily backups

Post by xavier »

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.
Narcissus
Developer
Posts: 338
Joined: 17 Feb 2005, 09:45

Post by Narcissus »

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.
xavier
Posts: 4
Joined: 25 Sep 2006, 07:57

Post by xavier »

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
Post Reply