22979 Posts in 11815 Topics by 2826 members
|Go to End|
27 November 2009 at 1:08am Last edited: 27 November 2009 1:30am
I know this is a strange question, but what I need to know is this.
Just for some background, I have a client who I've developed a site for in SS. Soon they are going to have a page of services for the public to search on, this will be quite a large database. All straight forward so far right?
Wrong, (this is where it gets tricky) the client will obviously be able to update the site themselves only the building their offices are in is reputable for having bad internet connections. For this reason they want an offline version of the database they can update and then import to the live site. My initial thoughts are to have an intranet as this is something they can make use of anyway, and to run the same SS pages as on the website so they always have access to the information. The only question then is how do I sync the website with the intranet? The intended use would be that they work on the intranet and then migrate that data to the website.
Apart from exporting CSV files from phpMyAdmin does anyone know of a more automated process of doing this that isn't too difficult for the client?
28 November 2009 at 9:06pm
I think that you can use mysql replication onw-way or mirroring and rsync for SS dirs like Uploads and Themes ( but last one isn't often update ).
29 November 2009 at 8:18am
Excellent, that is what I needed to know.
I found this incase anyone else needs it
and also of interest
|Go to Top|