mangosR2/mangos — comment on commit cf52ae0699c467d2ce45fe167a768dc6b1941f3a
File:  line 0
By tibbi:

no, I have shut down the server for 2 minutes, ran
update characters set at_login = at_login | 4;
delete ps.* from pet_spell ps left join character_pet cp on ps.guid = cp.id where cp.PetType = 1;
Then while the server was still off, I deleted the listed spells from character_spell.
that 2nd query resets talents of pets. According to my tests it really reset just talents, not wiped all spells.