[resolved] Attachments are still in the database after migration

AR84

Hi, I migrated the files from the database to the filesystem by using this command:

php setup/cli/manage.php file migrate --backend D --to F

The command was successful and the files are now in the filesystem and also they get opened from there. But i noticed that my database is still so big, so actually now I have the "old" files still in the database and the new and old files are also in the filesystem now.

Shouldnt the old files from the database be deleted during the migration?
Anything I can do to "only" have the attachments in the file system?

pwned

I haven't tested this on 1.11 but I've tested this on 1.10.4 and everything passed well and I have no doubt that everything should be same on 1.11.
So, everything from the database tables ost_files and ost_filechunk should be transferred to the filesystem and both tables should be empty.

Before you run the script make sure you have done this steps
https://github.com/osTicket/osTicket/issues/1243#issuecomment-54715803

AR84

Thanks for your reply, I just checked the database, ost_filechunk is empty, but ost_files still has 61.441 rows of data.
ost_attachment is used to define where the file is in the filesystem?
Could I manually delete the attachments from the database? Is there any value that defines if its loaded from the database or the file system?

AR84

Ha, funny. I just checked, actually the ost_file_chunk table is empty, i dont see any values inside, but it says the size is 25,1 GB, can this be? According to MariaDB there is nothing inside it anymore....

AR84

You can mark this ticket as solved, what I did was copying the table "ost_file_chunk" in the database to a new table. Then renaming the original table to "ost_file_chunk_old" and then new one to "ost_file_chunk". After verification that everything was working fine I then deleted the old table which before i named "ost_file_chunk_old". Now my database is 25GB smaller then it used to ?

ntozier

Well that would do it. ?