Please read Docker HowTo Install before installing REDcap [[Docker HowTo Install]] == Prerequisites if required '''Step 1 - Install Git''' {{{$ sudo apt-get update }}} {{{$ sudo apt-get install git }}} Please note you will need to have an account on git. '''Step 2 - Backup Redcap Database''' Log on to the mysql database machine. {{{mysqldump --routines --skip-extended-insert --force -h localhost -u root -p redcap > $(date +\%d-\%m-\%Y-)_redcap.sql }}} This will create a database dump file. Connect to my sql. {{{mysql -u root -p}}} Create a database, make sure you postfix with Redcap version number. Please stick to this naming convention. {{{mysql > create database redcap6168}}} Import the lastest database. {{{mysql -u root -p -h localhost redcap6168 < 19-09-2016-_redcap.sql}}} '''Step 3 - Create / Grant Mysql permissions''' If a new user is needed run the following, replace necessary details {{{CREATE USER 'briccsext02_user'@'uhlbriccsext02.xuhl-tr.nhs.uk' IDENTIFIED BY 'password'}}} Grant necessary privileges to user. {{{GRANT USAGE ON *.* TO 'briccsext02_user'@'uhlbriccsext01.xuhl-tr.nhs.uk' IDENTIFIED BY 'password'}}} {{{GRANT ALL PRIVILEGES ON redcap6168_briccsext.* TO 'briccsext02_user'@'uhlbriccsext01.xuhl-tr.nhs.uk';}}} {{{GRANT ALL PRIVILEGES ON redcap6168_briccsext.* TO 'briccsext02_user'@'uhlbriccsext02.xuhl-tr.nhs.uk';}}} If user already exists {{{GRANT ALL PRIVILEGES ON redcap6168.* TO 'redcap'@'10.156.254.207';}}} {{{GRANT ALL PRIVILEGES ON redcap6168.* TO 'briccsext02_user'@'uhlbriccsext02.xuhl-tr.nhs.uk';}}} or {{{GRANT ALL PRIVILEGES ON redcap6168_briccsext.* TO 'briccsext_user'@'uhlbriccsext01.xuhl-tr.nhs.uk';}}} == Upgrade Redcap There are 3 docker scripts available from github : git clone https://github.com/LCBRU/docker_redcap_upgrade Amend database.php sudo docker build -t lcbruit/redcap_fresh:v6.16.6 . sudo docker run -itd -p 80:80 lcbruit/redcap_fresh:v6.16.6 git clone https://github.com/LCBRU/docker_redcap_v5.7.0 git clone https://github.com/LCBRU/docker_redcap_fresh REDCap 6.16.6 http://uhlbriccsapp02.xuhl-tr.nhs.uk/redcap/index.php REDCap Software - Version 5.7.0 http://uhlbriccsapp02.xuhl-tr.nhs.uk:81/redcap/index.php Installation script * Image * CRON * php upgrade