0

Is there any way to insert data from one table in one server to another server using SQL languages in MySQL? We can do it in MS SQLServer by reference server name.

user207421
  • 289,834
  • 37
  • 266
  • 440
Kolika Chan
  • 11
  • 6
  • 2
    Possible duplicate of [How can I transfer data between 2 MySQL databases?](http://stackoverflow.com/questions/3242504/how-can-i-transfer-data-between-2-mysql-databases) – MaxZoom Sep 21 '16 at 02:19
  • i want to avoid dump file it make a lot of work as we have to schedule back up from server 1 and schedule insert in server 2 since it contain lot of hug data ( it over 110,000 records per day) – Kolika Chan Sep 21 '16 at 02:21
  • let me try , thank you . – Kolika Chan Sep 21 '16 at 02:40

1 Answers1

0
  1. first you need the structure of your database with tables and other objects(views,data,indexes,etc).
  2. create a backup of your database with all tables and objects of your database and save it on files .sql, por example a dump file.
  3. if you need insert data in different servers, you can create the database in each of your servers. You can execute this backup (a sql file with tables and other objects of database) in each server.
  4. if your tables dont have data you can load data in mysql via load data (MYSQL import data from csv using LOAD DATA INFILE) or through other way.
Community
  • 1
  • 1
Jorge T
  • 99
  • 1
  • 2
  • 8