Force reindex of a Cinnamon repository
- Optional: In some cases, the index in the file system must be deleted, typically in the path
- Log on to the database as user
- Execute the following SQL statements:
delete from index_jobs; insert into index_jobs select id,false,'cinnamon.ObjectSystemData',id from objects; insert into index_jobs select id,false,'cinnamon.Folder',id from folders;
NOTE: If you want to index objects or folders only, leave out the other query. Obviously, you can restrict the inner
selectstatement with a
whereclause, for example, to index only objects of a specific object type.