No announcement yet.

How to transfer data from one server to another server in MySQL?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Aiden
    I have come across a piece of writing related to the topic and found it to be very helpful. So follow these steps:
    Open the SQL Server Management Studio and connect to Server A.
    1. Right-click on the database and select Tasks and then Copy Database.
    2. Once you click on Copy Database then the following screen will appear. Click on "Next".
    3. Enter the Source server name (for example, Server A) and enter the Server Authentication mode and click on "Next".
    4. Enter the Destination server name and authentication and click on "Next".
    5. Now use the SQL Management Object method and click on "Next".
    6. Now under Select Databases you can see "Which databases would you like to move or copy"?. Let us select the Copy option and click on "Next". (If we select Move then the database will be moved to the next server).
    7. Now you can check the MDF and log file path on the destination machine.
    8.If you have any job or procedure in the master database then select, else click on "Next".
    9. Enter the log events if the copy fails. Here are two options: 1. System event view or 2. Local path. Now let us select the Windows event logs and click on "Next".
    10. Now select “Run immediately” if you want to run or schedule the run. Then click on "Next".
    11. Now Verify the options and click on Finish.
    12. Then you can see the progress of the status.
    13. After Success close the windows and refresh the Server B database node. Now you can see Test DB is there with all the data.

    Leave a comment:

  • How to transfer data from one server to another server in MySQL?

    I want to transfer my data from one server to another. How can I do that?