Page 1 of 1

Backing up of Attachments in database

Posted: 03 Apr 2006, 13:27
by dgrieve
Mantis version 1.0.1

I currently have the file upload (attachments) set to be stored in the database. I run a backup script which currently uses mysqldump command to create a dump of the database.

Am I correct in thinking that this does not backup or include attachments to bugs?

Backing up

Posted: 05 Apr 2006, 13:39
by dcomo
If you choose to store all of your assets (reports, images, etc.) within MySQL, then running a mysqldump will dump all of the assets to a .sql file.

I don't know what switches you are using, however I usually do the following:

mysqldump -opt -u root -p $dbname > $dbname.sql
(The --opt is usually included, depending on the version of mysql.)