That happened to me while I was travelling and it would have cost a bundle to get a new one,
I ended up just buying a cheap third party Pro Duo USB adapter to transfer stuff from the card to the computer rather than using the camera cable.
Something like
this
Might be easier to do that