Local and server synchronization

Question

Data synchronization

All development is carried out on a local server and every day you need to upload an update to the Internet.
And it is not very convenient to upload the database to the hosting every time, unzip the files, prescribe the database config.
Maybe there is some solution?

Answer 1

SVN + Dump Triggers

Answer 2

For my bike, I made a utility for users to manually and automatically synchronize the database from the local version of the site (and this is another utility from the same set).
In your case, you probably need to write a batch file that creates the archive locally, run ftp with a batch file, upload the archive there, you can unpack it via PhpConcept Library - Zip Module , and hang the image recovery database on cron or via Sypex Dumper .
Instead of a batch file, you can make an executable on the Roadsend Studio IDE if you know php - a very handy thing.