Q:

Exporting / Migrating out a Drupal database "correctly" via "new version" of PHPMyAdmin

I've made a screenshot of my settings; do I have all of this right if I intend on migrating it back to Drupal on a separate server? I plan to import it again through SSH most preferably but may also use PHPMyAdmin.

A:

If you have ssh access, I highly recommend to use mysqldump command to export and then use mysql command to import. I have bad experiences of using phpmyadmin to export and import drupal db (e.g timeout issue). also note that mysqldump/mysql is a lot more faster. 
Export:
mysqldump -u=xxx -p=xxx mydb > dump.sql 

Import:
mysql -u=xxx -p=xxx mydb < dump.sql

