I recently switched to backwpup to backup my wordpress sites. Its a nice handy tool to make and sql dump a wordpress xml export zips its all up and uploads to dropbox. What else would anyone want ? you can find the free version of it here. https://wordpress.org/plugins/backwpup/
So in the case of a migration or restore I unzip the file in its new home and have to load the databasedump.sql back into the database.
Presuming I have setup a database and a user with the appropriate permissions its just
mysql -u username -p -h localhost databasename < databasedump.sql
And thats pretty much it. The data is in the database.