How to move MySQL database from one server to another

First access the files of the database (MYI, MYD, FRM) from the existing database by going to
/var/lib/mysql/(your database) – This path holds true for ubuntu

Then go to the new server and put it in the same place

/var/lib/mysql/(your database).
restart your server and mysql then view it through phpmyadmin.

Configuring PHP + MySQL + Apache on Amazon EC2 Step by Step

Access MySQL from Host being on Vagrant

Setting new Vagrant machine for PHP-Mysql development

error duplicate entry for key when creating new unique key mysql

Using mysql keyword as column in Doctrine Entity – PHP

Connecting to Vagrant [PuPHPet] MySql from host