I’ve watched videos and ordered the right type of connector. It doesn’t seem so hard with flood soldering techniques.

Fortunately the break is clean and happened on the connector’s legs, so the traces are unharmed. I think the hardest part will be to remove the remnants left on the traces.