Question

How to transfer mysql database from one server to another

Answer 1

First, create a new database using CREATE DATABASE statement. Second, export all the database objects and data of the database from which you want to copy using the mysqldump tool. Third, import the SQL dump file into the new database.