How can I change status of all the entries in a channel to closed?
Grab all of the entry IDs you want from the craft_entries table, then find the rows matching those IDs in the craft_elements table and set their enabled column to 0 to disable them en masse.