Member Avatar for hassanumair1

Hello!
how can i sync or replicate my 2 db's on localhost xampp on windows. I want to replicate themselves as customer order something on my site and i am able to update his order and criteria as aearly as possible and also for security purpose. That if incase any disaster or damage happen; so there may be no database down. Kindly send me a scenario. I want it all command based and want to make a batch file.

what approch may best

1 : client / server
or
2 : Master / slave

I also used a sqlyog for synchronization. But my company requires to replicate their databases on command line based batch file. Just like an perl script and no tool needed like task scheduler or something.
  • 1 Contributor
  • 1 Reply
  • 211 Views
  • 2 Minutes Discussion Span
  • Latest Post Latest Post by hassanumair1
Member Avatar for hassanumair1

kindly send me solution as early as possible.
Regards:
Hassan

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.