[Loris-dev] LORIS Development Database Set Up

[Eli Johnson]

Hi all,

We are setting up a development server and database for our instance of
LORIS. I am looking for advice on how to best set up and maintain a
development database that replicates our production database. From
discussion with Dave and Leigh at McGill, it sounds like we will want to
clone our production database. This could be done via a mysqldump from the
production database which is loaded into the development database.

*Several specific questions*:
1. I imagine cloning the production database via mysqldump every time would
take a bit of time with a larger database. Any advice on this process? Is
mysqldump the best method or is there a recommended alternative method to
do this?

2. Does anyone have scripts or tools they could share to help automate this
process?

3. Will I need to completely clone the production database every time I
want to update the development database or is there some way to update it
incrementally?

Any additional advice on best practices for this are appreciated!

Thanks,
Eli

Eli Johnson
Researcher
Institute of Child Development
University of Minnesota
joh17964 at umn.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.bic.mni.mcgill.ca/pipermail/loris-dev/attachments/20191104/b6e4c460/attachment.html>