Backup Smart

Backup Smart is an app that allows you to backup all your cPanel websites to your Mac. Backup Smart will download the whole compressed .GZ file (which will turn a large text database into a much smaller file), just like you would do from cPanel.

If you only need to restore a few rows of the database instead of the whole lot then this is a manual process and is achieveable by extracting the SQL from the archive you have and using a text editor to copy the SQL that you need into your phpMyAdmin.