Hey, I have had both my Navel & Nose pierced twice..
My Navel 'grew out' because obviously my body doesnt want a bar there! (grrr) and i had it done again & it did hurt quite a bit, it was painless the first time, so i guess it must have been because of the scar tissue.
My nose healed up after my stud came out in my sleep so i got it done again, and didnt feel any different from the first time!
And i have had my tragus pierced, and i do love it but i dont think i would go through it again! its the most painful piercing ive had, and ive got quite a few including my lip & tongue!
It just a like a really really sharp pain, and it kills.. not to put you off! lol.
But if you really want it done then just go for it, because it only lasts for a bit, and after that its fine!
hope this helps, if you want to know anything else just let me know. x