Home > Resources > Internet >How to copy mysql database to another server

How to Copy Mysql Database to Another Server

This guide shows you how to copy mysql database from A server to B server.

Two steps to copy a mysql database to another server:

1. Login B server, export data from A server. Use sql command: mysqldump -h a_server_host -p -u database_user database_name > data_backup.sql. Note: You should allow B server to rumote access mysql database on A server.

2. Import data to database on B server, sql command: mysql -p -u b_database_user b_database_name<data_backup.sql

 

Tips: You can use sql command to export data from A server, copy it to B server, and then use sql command to import to the database on B server.

 

Related Articles:

Hot Categories
Windows 10 Password
Windows 8 Password
Windows 7 Password
More +
Hot Articles
How to Reset Windows Laptop Password If Forgot It
How to Reset Windows password with USB
How to Reset Windows 7/8/10 Password without Any Software
Dell Administrator and BIOS Password Reset on Laptop
How to Reset Surface Pro or Surface 3 Tablet Forgotten Password
More +
Latest Articles
4 Methods to Access UEFI BIOS Setup in Windows 8/10 New PCs
How to Copy Mysql Database to Another Server
How to Move Wordpress to a New Server
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +