Sorry if this was answered elsewhere. I did a search and couldn't find anything.
I'm looking for a way to change the administrators across many blogs all at once.
Here's why:
I run a WPMU installation for a school and many of our students have their own blog. I put the teachers in as the blog administrator so they can monitor them. Now that it's the beginning of the year, I would like a quick way to change last year's teacher to the new year's teacher.
I downloaded the sql file and found there's a place in the options database of each blog, but that doesn't change the name of the admin that shows up on each blog's Users page.
Does anyone have any advice? Thanks in advance.