The screencast demonstrates how to use the WP Migrate DB plugin (free version) to export your live site’s database as an SQL file with all the URLs and file paths updated and ready to be imported to a development or staging site using phpMyAdmin.
source