Schedule data transfer service in MySQL -


I have two DB servers, i. E Server 1 and Server 2 I tell every morning (9:00 am) Server2 wants to transfer data to Server2.

How can we get it? Can this transfer of data be done automatically?

My choice on a window machine is to create a batch file that is going to mysqldump Runs, which is best for you.

This batch file can be connected to the window scheduler for automatic execution at any point in time.

You can consult the page for some guidelines by the MySQL community.

Now when you have a dump of your DB, then you should send it to the destination server through your script and deploy it locally (this can also be done automatically).

  • I use the parameters of mysqldump which allow me to increase the data on the new server
  • I use the dump That is, the community window cover around the RSINC program (if you are interested, then you should check synchronize on that page)

    Both final points are very fast process than copying whole DB Allow. / P>

Comments

Post a Comment