Closed

Auto Synchronise local mySQL changes with server mySQL

Imagine the scenario - 20 developers all working on the same mysql database file - each one on their own local machine. That is, they grab the server mySQL sql install it locally (say on phpMyAdmin) then run XAMMP to develop PHP code and make database modifications.

Throughout the day they merrily add tables, change schemas, add data - never thinking much the the changes the other 19 developers are doing.

Now the fun part. The 20 developers go home and the database admin gets 20 SQL files and has to merge them into one "no-data-has-been-lost" sql file.

The above is a purely fictitious story but it gives you a good idea of what happens when even 2 people work locally on the same mySQL code and then try to merge their changes. 20 is a great number because you cannot do it manually.

WHAT I NEED:

I need someone to provide code (or access to a tool) to automate this process so that any SQL change made by (say) 20 developers could easily be merged into 1 SQL file and uploaded to the server with no loss of data. The server is PHP/mySQL/github is used. Local machine is XAMMP. The script would ideally have GIT hooks so that when github is updated with code the mySQL merger would trigger and the code and the mysql would stay in sequence.

I have a huge amount of work in server admin coming up so if you can show me your skills this could be the start of a great long term relationship.

Skills: Database Administration, MySQL, PayPal API, PHP, Software Architecture

See more: what do database developers do, synchronise it, php mysql developers, SQL Server Admin, script to merge and automate files, need mysql developers, auto part, mysql data grab, mysql grab, mysql number sql, lost server, start admin server, changes data access, schemas, mysql code change data, working auto script, sql server merge data, local file, install git, script auto database, add tables sql, access sql merge, phpmyadmin mysql, access database modifications, sql fun

About the Employer:
( 416 reviews ) Melbourne, Australia

Project ID: #5459526

4 freelancers are bidding on average $72 for this job

elboukharimu

Aucune proposition n'a encore été fournie.

$100 AUD in 3 days
(29 Reviews)
5.1
balamuralip

hello sir i am an expert programmer and developer..i have good experience in mysql database i can complete the project as per your requirement..so plzz consider me in this project thank you..

$60 AUD in 3 days
(2 Reviews)
2.6
ppandare

We are '3stechmind' team of dedicated software professionals developing the web projects for our [url removed, login to view] area of expertise is design the web site and implement the functional aspects in software technolgies like ph More

$73 AUD in 3 days
(2 Reviews)
1.3
Octaneinfosols

Hello Sir, Greetings..!! Octane Infosolution Pvt. Ltd. is present at your service.. WE READ ALL YOUR REQUIREMENTS AND FOUND THAT THERE IS A MATCH WITH YOUR REQUIREMENTS AND OUR SKILL SET. Hence we are new More

$53 AUD in 3 days
(0 Reviews)
0.0