Migrate Wordpress installation to new server
The instructions here how to back up databases using phpMyAdmin used to work for me.  The author wrote:


  “Disable foreign key checks” isn’t always necessary. I do a lot of CiviCRM work. Restoring a CiviCRM database will fail unless this option is enabled in your export.