Tags
PHP
Asked 7 years ago
19 Sep 2016
Views 1077
pratik

pratik posted

online server's Mysql to localhost Mysql synchronization

Hi

i want to make sync tool between online server's MySql to Localhost Mysql

ideally i am working with many project and sometime client getting error at online but not local it working perfect for me . its only because some data entered by tester causing effect so everytime i need to create export from server's MySql and i download file and import to my local server(Wamp).
so now i want to make a tool where by click on button at admin panel i can download all data and tables form the server and it goes to my local database.

so tell me if any one can guide be . how can i make sync tool for one way : server to localhost for Mysql Database.
for now i want to do per database from admin so advice me accordingly.

sandip

sandip
answered Nov 30 '-1 00:00

i dont know more about this but you can do it by sqlyog . it will help to backup your online database to local .

Mitul Dabhi

Mitul Dabhi
answered Nov 30 '-1 00:00

you need server side programs which get request and make the sql dump. and local server can download it by script and make it run in local server so it export to local server database
Post Answer