Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

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.

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

do you know how this index is done by kolide? just to not messup with the table :slightly_smiling_face:

<https://github.com/kolide/fleet/blob/master/server/datastore/mysql/migrations/tables/20191010155147_UpdateTableHostsSearchIndex.go> is what it's trying to do.

I would try `CREATE FULLTEXT INDEX hosts_search ON hosts(host_name)` and then run the migration again.

As always, very good idea to backup before running migrations.