Forums

Parallel installation for editing

Permalink
Hi,

Here's what I'm thinking about:

I want to have an installation of C5 on my personal PC, and another installation on my host.

Why? I want to edit the content on my own pc, which is not always online, and if I'm at home and connected, is faster than the web host.

So when I'm done editing a couple of pages, I need to copy the whole content of my local installation to the remote host.

First I thought that I can just make a backup of the database, restore it on the other machine, and upload the files (images, etc.) using ftp.

I'm not sure if it works though, because there has to be some configuration stuff on the db that should not be overwritten on the remote server. Should I preserve the content of a few tables on the remote host? Does anyone has any clue on this? I'm going to try this anyway, I thought I'd post here to see if anyone has any ideas...

-Hamed
iravanchi
 
iravanchi replied on at Permalink Reply
iravanchi
Well, I tried the above approach and it works. I used WAMP and installed C5 locally, no problem.

I authored some pages, dumped the MySQL and uploaded the dump, restored the MySQL DB remotely using ssh console, and everything worked!

My problem is, this approach is appropriate for a static web site, but is no good even if you got a single form or guestbook on the web site.

I will use this local approach until I launch my web site, but after that, this is of no value for me.

I'm wondering if there's a way to record MySQL DML (Data Manipulation, INSERT, UPDATE and DELETE statements) locally, and re-run the script remotely. I know there's a SQL Log feature in C5, what I'm not sure if the recorded SQL can be any good for this, and if I do this and there's a concurrent change in my website (like a form submittion or comment) is there going to be a problem or not.

I'll post back if I got more results.
gsownsby replied on at Permalink Reply
gsownsby
I've tried such schemes with Concrete5 and other CMSs...usually the extreme effort is not worth it and there is too high a potential for procedural mistakes and other problems to slip in.

I host on HostMonster.com ($3.95 per month) and the speed difference is hardly noticeable compared to using Wamp at home. Plus you are using a commercial heavy iron server vs. much less than that at home. SimpleScripts is also available to install Concrete5 and update it.
Mnkras replied on at Permalink Reply
Mnkras
you could use a sync like service that updates now and then
ScottC replied on at Permalink Reply
ScottC
Aside from adding asset library contents, I have found that the editing remotely on a fast host is about the same as editing locally, at least with 5.3 onward.

I have a low range VPS and I don't really notice much of a difference between local and remote, and while i have "high speed internet" it isn't all that high speed.

Editing over on the mediatemple grid was pretty annoying, mosso is better, but a vps from concrete5 or something along those lines would be something worth looking into.