Skip to main content

After migrating osTicket to a new server, old attachments stored in the database appear corrupted and cannot be opened

osTicket: 1.17.4 / 1.17.6 Checked:

The database export was not performed in binary-safe mode. Binary blob data (attachments stored in the DB) requires binary-safe export. Re-export using mysqldump or mariadb-dump from the command line -- these are always binary-safe by default. If using MySQL Workbench, ensure 'Include binary columns' is checked before exporting. Re-import the corrected dump on the new server.

Originally sourced from forum.osticket.com . osFAQ.org summarises community knowledge for quick reference.

Helpful
Report an error