You can use the export options in phpmyadmin, to export the database into SQL files.
Those SQL files you can then import locally to recreate the database.
Depending on the size of the database, sometimes the Export will need to be broken up into the structure and the data separately. Alternatively you can do small groups of tables together.