Cherie provided some good information!
I have had 4 LPs. I have one lesion on my spine. 2 LPs were negative, 2 were positive for MS.
None of them were painful. I will add, tho, that following the 2 positive LPs I did have the dreaded LP headache. My neuro, who performed all 4 of them, says it's just coincidental!
Follow the post LP instructions to the "T", if you decide to have one. It is not required for a diagnosis.
The decision is ultimately up to you. Here's a like to the Revised McDonald Criteria for Diagnosing MS
http://www.mult-sclerosis.org/DiagnosticCriteria.html