1
jolot
4y

Okok i cant find a decent solution on this so have to ask you guys; i have 2 ubuntu servers atm. I need to transfer some few mysql data from s1 to s2 when i press 'send' on my main site. So its available to use on s2 and then back if needed. How can i do this properly and secure?

Comments
  • 2
    You can add each other's servers in the firewalls. Then you can use simple mysql commands to transfer data.

    Then you authenticate each other based on IP.
  • 2
    mysqldump -u user -p -h server1.domain.tld dbname | mysql -u user -p -h server2.domain.tld dbname
  • 2
    Nice. And who said devRant is only for ranting? 😀
  • 0
    Thanks alot guys, ill try now 😊 this is full of experienced guys so gave it a shot 😆
Add Comment