Easy way to replicate MySQL over HTTP
The database exists on a VPS, which we have control to install anything. But our office proxy blocks non-HTTP traffic.

We have 

 1. content , which must by synced from the dev machine to the web server
 2. user-generated data, which must the synced from web server to dev machine.

Both types of content exist on **separate tables** of course, but transfer is definitely **two-way**.

----------
This is for the purpose of backup and updating content (yeah we directly insert rows!). I am OK with transferring entire content at once (DB will be under 50mb for a year), but transferring **only changes** would be better.


----------
For previous projects, we used to have shared hosting. We used to export the entire DB over PHPMyAdmin at once, or modify it on site.
Easy way to replicate MySQL over HTTP
===

The database exists on a VPS, which we have control to install anything. But our office proxy blocks non-HTTP traffic.

We have 

 1. content , which must by synced from the dev machine to the web server
 2. user-generated data, which must the synced from web server to dev machine.

Both types of content exist on **separate tables** of course, but transfer is definitely **two-way**.

----------
This is for the purpose of backup and updating content (yeah we directly insert rows!). I am OK with transferring entire content at once (DB will be under 50mb for a year), but transferring **only changes** would be better.


----------
For previous projects, we used to have shared hosting. We used to export the entire DB over PHPMyAdmin at once, or modify it on site.