In addition to the standard Import and Export tab, you can also import an SQL file directly by dragging and dropping it from your local file manager to the phpMyAdmin interface in your web browser. If ...

I tried to export all of the MySQL databases using phpMyAdmin as an SQL file. After downloading it, I did an SCP of it to the new server which is a local to remote transfer.

Steps to reproduce 1.Export any joomla or moodle (maybe even Wordpress database) from phpmyadmin 4.5.5.1(as I was testing on Joomla Site). 2.Now create a sample database and Import the sql file. 3.