Categories
osTicket

osTicket attachments migration for huge databases

.Recently I had some issues during the migration of files from database to filesystem for an istance of osTicket 1.12.x, but I think it’s related to all range 1.10-1.14.

The istance had more than 60.000 files ( 40GB of data ) pushed as attachments inside the database. And the database was quickly growing by 1GB/week causing problems to the nightly backup procedure on a DB Cloud. Simply, the procedure stopped to work when the database reached 20GB and the provider did not offer any alternative solution. So it was mandatory to proceed with the migration on filesystem to keep it smooth and easy to backup.