Mysql local to remote sync

Asked

Viewed 2,317 times

10

I wonder if it is possible to replicate a local Mysql database with the remote. Use Phpmyadmin and do not know if it will be possible because I have no fixed IP to find each other.

php mysql synchronization replication
  • 1

    You can take a look at my answer that I gave a while ago, it might also serve your problem. http://answall.com/questions/90164/como-fazer-backup-do-banco-datas-para-nuvem-e-como-ter-datas-synchronized/90264#90264 Or follow more details on my blog: https://medium.com/@juniorb2s/seven-head-4d7193dfc1c

  • Renan, can you explain the situation better? You have a local bank, and want to synchronize the data with some cloud database?

  • Yes, it’s possible, and the name of it is called master-master replication. The only peculiarity of your case is that you would have to use a no-ip to get a fixed address to be informed on the remote server. Give a gloomy you get.

  • This and your production bank ? If it is I think it would not be cool

  • Dear Note: http://answall.com/questions/188495/sincronizar-banco-data

  • Just one remark about No-IP: It’s not just creating a no-ip. You also need to direct the TCP 3306 INPUT port on your ADSL (if you do not use valid IP and with ports released) to the terminal that hosts Mysql. If your internet is neighborhood provider, will have to request TARGETING (is not release) port to your router (or PC, if direct).

Show 1 more comment

1 answer

2

It is possible yes and very simple to do!

1) As you do not have fixed IP, go to the NO-IP website and register a dns host.

2) Download their program and let it run on the machine where PHPMYADMIN is located

3) Log into PHPMYADMIN with your user and password and go to the following options:

USER ACCOUNTS > Select the root account or the one you are using > EDIT PRIVILEGES > LOGIN INFORMATION > Change the 'HOST NAME' that will be in LOCATION: localhost for ANY MACHINE: %

4) Run and can access the database externally in an sql program (such as Navicat), using the no-ip host with port 3306 if no change, user name, password!

Browser other questions tagged php mysql synchronization replication

You are not signed in. Login or sign up in order to post.