Given that WordPress doesn’t allow to import a local file (and this is quite unfair, in my opinion), you can transform a wp site into a xml file and then import it in your local database via phpmyadmin.
But you have to format carefully the xml: look how phpmyadmin export an xml file and format your xml according to that model.