<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hello Eli,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
There is no need to create a new database dump from production every time you start a new project.
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
If you do all you development on your dev instance before porting to production and keep this dev instance to the same release of LORIS as your prod, both database instance should have the same schema.
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
It is also a good idea to test a new release of LORIS elsewhere than you production instance first to ensure there is no compatibility problem with your internal development before upgrading you production.
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
As long as database schema modification are eventually applied to both instance, there is no need to use a datadump to re-synchronize. Of course the data itself would be out of date but it is normally not a problem for a development instance.<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<p style="margin-top: 0px; margin-bottom: 0px;margin-top:0; margin-bottom:0">M<span class="_Xbe">é</span>lanie Legault
<span style="color:rgb(255,0,0)">|</span> Software developer <span style="color:rgb(255,0,0)">|</span> Faculty of Medicine<span style="color:rgb(255,0,0)"> |</span>
<span style="color:rgb(255,0,0)">McGill University </span> <br>
</p>
<div>3801 University, Montr<span id="ms-rterangepaste-start"></span><span class="_Xbe">é</span><span id="ms-rterangepaste-end"></span>al, QC H3A 2B4 </div>
<br>
<p style="margin-top: 0px; margin-bottom: 0px;"></p>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> loris-dev-bounces@bic.mni.mcgill.ca <loris-dev-bounces@bic.mni.mcgill.ca> on behalf of Eli Johnson <joh17964@umn.edu><br>
<b>Sent:</b> November 4, 2019 14:53<br>
<b>To:</b> loris dev <loris-dev@bic.mni.mcgill.ca><br>
<b>Subject:</b> [Loris-dev] LORIS Development Database Set Up</font>
<div> </div>
</div>
<div>
<div dir="ltr">Hi all,
<div><br>
</div>
<div>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. </div>
<div><br>
</div>
<div><b>Several specific questions</b>:</div>
<div>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? </div>
<div><br>
</div>
<div>2. Does anyone have scripts or tools they could share to help automate this process? <br>
</div>
<div><br>
</div>
<div>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? </div>
<div><br>
</div>
<div>Any additional advice on best practices for this are appreciated! <br>
</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Eli</div>
<div>
<div><br clear="all">
<div>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div><span style="font-size:12.8px">Eli Johnson</span><br>
</div>
Researcher<br>
Institute of Child Development<br>
University of Minnesota
<div><a href="mailto:joh17964@umn.edu" target="_blank">joh17964@umn.edu</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>