Hmmm… maybe I’m trying too hard. Yes, lots of import, delete, repeat. Here’s what I’m doing, for the record. Thanks to a modified version of @lead4good here
#I am running from /var/discourse/myscripts
require_relative '../discourse/config/environment'
cnt = 0
Topic.find_each do |t|
# Earlier topics ok to keep like FAQ, Welcome, etc.
# t.user_id -2 is discobot. I don't want to delete all
# of the "Greetings" topics for my new users
if t.id > 6 && t.user_id != -2
puts "Topic: #{t.id}, #{t.title}, #{t.user_id}"
t.destroy
cnt = cnt +1
end
end
puts "Deleted #{cnt} topics where t.id > 6 && t.user_id != -2"