Backing up of Attachments in database

dgrieve · Post by **dgrieve** » 03 Apr 2006, 13:27

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?

dcomo · Post by **dcomo** » 05 Apr 2006, 13:39

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.)