Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Local and remote website synchronization with Subversion possible?
I am developing a blog-type website locally using MAMP and Textpattern.
I’ve seen Slingshot and got interested in the idea of working on and posting to my site locally on my machine or remotely to my server on Textdrive when traveling, and then synchronizing both using Subversion.
My idea is to have a remote repository containing both my Public_HTML folder and a dump of the site’s MySQL database.
I’m a novice Subversion user.
How feasible is this? Would it be more trouble than it’s worth in your opinion?
Cheers.
Offline
Re: Local and remote website synchronization with Subversion possible?
One issue I can think of is that the site name in the local MySQL database would be sitename.dev while the server would be sitename.com. Perhaps writing a MySQL search and replace script and running it after every commit would be an option?
Offline
Re: Local and remote website synchronization with Subversion possible?
If you make changes on both locations (adding articles), then synchronising them will give you problems, because the article ID in the database is auto-incremented, so adding articles on both sides will give you two different articles with the same article ID (one in each website location), so one of them will disappear or the synchronising will fail.
Last edited by ruud (2007-08-17 11:10:41)
Offline
Re: Local and remote website synchronization with Subversion possible?
Very good point Ruud—thank you!
Offline