Question: how to transfer data from one mysql database to another?
Answer: Step One—Perform a MySQL Dump. Before transferring the database file to the new VPS, we first need to back it up on the original virtual server by using the mysqldump command. ... 
Step Two—Copy the Database. SCP helps you copy the database. ... 
Step Three—Import the Database.