osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Trying to migrate file and file_chunk from one database to another database
I am trying to migrate attachments (and tickets & threads) from DB_1 to DB_2. I wrote basic mysql query to select all the fields from DB_1 and trying to insert into DB_2. I can successfully echo all the data on the page but the insertion doesn't work.
I am getting the max(id) from file table in DB_2 and inserting the new file_id as max(id) + 1 for file_id field in both attachment and file_chunk tables, since they are not auto-increment fields.
I am new to this, could someone give me some advice?