is there a way to skip this DROP with prepare db 2020 05 11

Question

is there a way to skip this DROP with prepare db 2020 05 11 10 07 00 FAIL 20191010155147 UpdateTableHostsSearchIndex go drop old index Error 1091 Can t DROP hosts search check that column key exists quitting migration

zwass · Answer

No but maybe you can add the index before running the migration

vaar · Answer

do you know how this index is done by kolide just to not messup with the table slightly smiling face

zwass · Answer

<https github com kolide fleet blob master server datastore mysql migrations tables 20191010155147 UpdateTableHostsSearchIndex go> is what it s trying to do

zwass · Answer

I would try `CREATE FULLTEXT INDEX hosts search ON hosts host name ` and then run the migration again

zwass · Answer

As always very good idea to backup before running migrations

vaar · Answer

yes already did it thanks