Hello i am working on a large php/mysql project and i am getting to the point where everything get really confusing.
I have a dedicated sever that runs CentOS with PLESK. And i have a windows PC with XAMPP.
Now the way i work is doing the development and basic testing om my PC, and whenever i feel the need of testing something on the server i upload everything and and test it on the server. Especially for the mysql changes this is really a pain, I have to export and import a new database again and again.
Is there some kind of method of easily switching between these envoirments. Or can someone point me in the right direction, because i have never made applications of such a large scale.
Thank you for your time.