Thanks @Edmond but this solution only works if both server (old & new ) have the same table structure. In my case the old server has a very old version of Call Center Stats Pro.
I believe there is some solution around the “queue” file that the new server will read and populate mysql. Just not sure how to go about it.