Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By sunfish on
I have a need to update the texts in a bunch of nodes and I don't really want to do that one by one through the admin gui. I'm thinking of just exporting the node_revisions table to excel, making changes and importing it back to mysql.
After clearing the cache, I notice that the contents also appear in search_index, search_dataset, search_total, and cache_form. Can I just rebuild the index after the import or do I have to empty these tables before index rebuilding? How about the cache?
Comments
_
You can reindex the site at admin/settings/search. The problem with this method is that any other modules or code that interact with the node update process will be completely bypassed using this method.