It pissed for 2 days non stop when I went in '07 - apparently the most rainfall all season happened in those 48hrs...
Looking back now, going to Bora Bora was a silly idea!
Did you go around about the 5th August? We went for 5 nights and it rained for about 3 days. We also went to Bora Bora