(Easiest Way) How to Move MySQL Database to Another Server

In this article, you will get methods to move/migrate MySQL database to another server. The easiest way to migrate database from one server to another is EaseUS Todo PCTrans - a professional database moving software. And more, we also introduce the backup program of MySQL, getting the details to export/import MySQL database.

EaseUS Todo PCTrans

  Free Download

100% Secure

Page Contents
 

Page Table of Contents

"How can I move MySQL from one physical server to another? Such as this exact scenario: I have a MySQL server that uses InnoDB table and is about 20GB in e. I want to move it to a new server, what's the most efficient way to do this?"

MySQL is a relational database management system based on the Structured Query Language. We utilize it for managing information stored in the computer, including personal data or the vast amount of info in a company. Thanks to this free-to-use database management system, the companies have the easy to power their business. So how to migrate the database between two servers for saving these data?

Follow our step-by-step guide to move MySQL database to another server by third-party database transfer tool and the backup program of MySQL. These two methods apply to migrate database in Windows.

mysql logo

(Easiest) How to Transfer MySQL database from One Server to Another

There is no need to learn the command line of other articles mentioned; a few clicks can move the MySQL databases. That's why EaseUS Todo PCTrans stands out from them. All you need is to download this database migration tool and do the 3 easy steps. Trust EaseUS! We are professional to move database from one server to another.

Click the download button for a trial:

EaseUS Todo PCTrans Technician

Trustpilot
 
☆ Deploy & install Todo PCTrans on multiple PCs.
Transfer unlimited files, programs, apps between Servers.
Transfer account, domain account, and settings.
Data rescue, find product key of installed programs.
One license for multiple PCs.

  Free Download

100% Secure

Notice:

EaseUS Todo PCTrans supports the migration of MySQL installed on the system disk by default. Also, it helps to transfer the custom installation of MySQL.

Step 1. Run EaseUS Todo PCTrans on both PCs

On the source PC, select "PC to PC" on the main screen of EaseUS Todo PCTrans and move on.

select pc to pc transfer mode

Step 2. Choose transfer direction - Old or New Computer

"New" - Transfer all data from remote old computer to current new computer.

"Old" - Transfer all data from current old device to a new computer.

choose transfer direction

Step 3. Connect two computers

1. Select your target PC to connect via its IP address or device name and click "Connect".

2. Enter the login password of your target PC and click "OK" to confirm.

If you didn't see the target PC in the listed devices, you can also click "Add PC" to manually connect the target PC by inputting its IP address or device name.

connect two PCs

Step 4. Select apps, programs, and software and transfer to the target computer

1. You can select and choose what you want to transfer from the current computer to the target PC.

2. After selecting desired applications and programs, click "Transfer" to start the transferring process.

select apps to transfer from PC to PC

  Free Download

100% Secure

If you want to do the remote transfer, you can try the "Backup and Restore" mode of EaseUS Todo PCTrans. In the next part, we will introduce database backup program to back it up as a single file using the mysqldump.

How to Migrate Database to Destination Server

Migrating the database between two servers requires the Mysqldump, a command-line utility power to create the MySQL database backup, to clone MySQL database.

First, you need to export databases to Dump file. Then transfer it to the destination server. In the end, import MySQL databases to a new server.

Step 1. Export MySQL Database to Dump File

Log in to your old server and input the systemctl command to stop the MySQL service:

systemctl stop mysql

Export your database as a dump file using mysqldump command:

Dump all MySQL databases: mysqldump -u [user] -p --all-databases > all_databases.sql

Dump a single database:  mysqldump -u root -p --opt [database name] > database_name.sql

Step 2. Transfer MySQL Databases to New Server Using SCP command

SCP is a file transfer program installed on Linux. If you want to use it, you can put the SCP command line on the Command Prompt. If it does not work, you can download the SCP first. Or go back to use EaseUS Todo PCTrans.

All databases:  scp all_databases.sql [email protected]:~/

Single database:  scp database_name.sql [email protected]:~/

Once it is done, you can see the database in the new server.

Step 3. Import Database in MySQL

Run the following command line to import MySQL database's dump file into the new server.

All databases:  mysql -u [user] -p --all-databases < all_databases.sql

Single database:  mysql -u [user] -p newdatabase < database_name.sql

More Options:

If you want to move any specific tables of MySQL database, input the following command:

mysqldump -u [username] -p [database] [table1] [table2] > dump.sql

About the Author

Updated by Tracy King

Tracy joined in EaseUS in 2013 and has been working with EaseUS content team for over 10 years. Being enthusiastic in computing and technology, she writes tech how-to articles and share technical solutions to resolve Windows & Mac data recovery, data backup, partition management, data transfer, Windows update issues, etc.

Read full bio

Reviews and Awards

Product Reviews

TrustScore 4.7 | 34 reviews
  • EaseUS Todo PCTrans Free is a useful and and reliable software solution created to serve in computer migration operations, be it from one machine to another or from an earlier version of your OS to a newer one.

    Read More
  • EaseUS Todo PCTrans is by the folks at EaseUS who make incredible tools that let you manage your backups and recover your dead hard disks. While it is not an official tool, EaseUS has a reputation for being very good with their software and code.

    Read More
  • It offers the ability to move your entire user account from your old computer, meaning everything is quickly migrated. You still get to keep your Windows installation (and the relevant drivers for your new PC), but you also get all your apps, settings, preferences, images, documents and other important data.

    Read More

(Easiest Way) How to Move MySQL Database to Another Server

Try smart Windows 11 data transfer tool to move all data in 1 click.

EaseUS Todo PCTrans

  Free Download

100% Secure