By sparkguitar05 on
I like to work on my site on my local system first and used to upload the database, replacing the older one. But nowdays the problem is that I have people posting on my site, so say if I download today's database on my local desktop, make some changes like adding modules and fine tuning it, and than replace the database of the live site, I will loose all posts of users of past few hours/day
How can I sync development between my live site and local development ?
Comments
Me Too, been looking
Me Too, been looking everywhere...
I found some fee based software... but the demo modes will not allow for a full sync, so I don't know if it is going to work...
Hoping someone will share how they are doing it as it has to be a pretty common issue.
One person suggested CVS, but I have not idea about using CVS.
Navicat 8
I found a software that does it. (demo version, it is payware). Good news is I was able to do it... and there are probably other out there that do the same... maybe even some opensource...
I tinkered for a long time and now know the steps needed to get a good sync.
I have created a screencast and will post it on my blog hopefully this weekend.
If you need help sooner, just let me know and I will walk you through my steps.
:) YEA!!
cvs
You probably do not want to use content versioning to sync databases, especially if users can make edits to the live site.
However, it might not be bad to version the structure of your database tables.
No idea if this works, but
Here's a module called Staging that might be helpful:
http://drupal.org/project/staging