Hi, 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. Now, when I am ...

Migrating a database is as simple as selecting the database in the left column, clicking the Export link, and saving the database to a file.

To do so, from the top menu select ‘Server’ and ‘Data Export’ Option. We can select one or more database check-boxes to include the database in the Export file. -- So, let’s select our school database ...