Replication at home: Replicates with M:, creates csv files in M:, ftp uploads to the gandalf area and executes the Gandalf Load to load into the master (dl_uktw) and the admin (uktw_uktw) versions.
Replication away: Replicates with Dropbox, creates csv files, ftp uploads to the gandalf area and executes the Gandalf Load to load into the master (dl_uktw) and the admin (uktw_uktw) versions.
Samba area contains a replicated Merlin_data and an area for csv files to be dumped when operating at home
Local MySQL database no longer used - contains a dl_uktw version and was originally the master
Web area contains an old gandalf_load.php which is no longer used
The new VPS at Heart contains merlin.dynamiclisting.com and the new uktw.co.uk
This new server has a more up to date MariaDB and some error reporting has to be turned off to prevent problems. Most notably 0000-00-00, lack of defined defaults, field not in select for a group and Swedish/utf collation issues (mostle handled by turning off check variables)
The gandalf_load loads the csv files into the dl_uktw tables in the main dl_uktw database
The dl_uktw database acts as a master for WOS and for the old (now defunct) UKTW server
The new Merlin interface ONLY deals with uktw_uktw ... it makes NO changes to dl_uktw (the WOS master) though it does store its updates in a log file once development is complete we can copy uktw_uktw changes across to dl_uktw either automagically or on demand
The fandalf_load also executes gandalf_load_uktw which loads the same csv files into uktw_uktw tables before deleting them.
The new uktw works with the uktw_uktw database as well as uktw_utwk (for the site details) and uktw_local (for logs)
Some of the admin functions are now in /admin and the ticket functions are now in /TixAdmin
/merlin also contains the new, on-line version of our Merlin interface which is accessed as merlin.uktw.co.uk