What was the eventual fate of Ptolemy XII?

Ptolemy XII was a king of Egypt who was a Macedonian.  During his time as king, he maintained strong relations with Rome.  Egypt eventually became a client kingdom of Rome.  This meant that for the good of the kingdom, they submitted to Rome's authority.  Under this system, they could have Rome's protection, and also avoid invasion by Rome itself.

Eventually, the citizens of Alexandria rose up against Ptolemy because they disagreed with his decisions to align himself with Rome.  They forced him to leave Egypt, and he found sanctuary in Rome.  Meanwhile, his daughter ruled in his place.  Ptolemy tried to unsuccessfully to gain the support of the Romans to help him reclaim his throne from his daughter.  He finally found Aulus Gabinius, who was a military commander.  He paid him to help attack his kingdom with an army.  He then reclaimed the throne and had his daughter executed.  He died shortly after he became king again.