Harry Potter author JK Rowling was moved to tears as she killed off one of her key characters, she has revealed.