<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
</head>
<body dir="auto">
<div>I've heard that, too, and it might be true in larger installs, but it just hasn't been the case for us so far. </div>
<div><br>
</div>
<div>We backup the entire MySQL database 4x a day. I admit it's many many thousands of tables (and more each semester, of course) but we're just copying the directory on the server to an evault, and it's all automated and goes quite smoothly. </div>
<div><br>
</div>
<div>But maybe you're a lot bigger than us? </div>
<div><br>
</div>
<div>(I hope I'm not jinxing myself by saying this! Maybe someday we'll get to that promised point where those problems occur, but it hasn't happened yet). </div>
<div><br>
Joe<br>
<div><span style="background-color: rgba(255, 255, 255, 0);">-- <br>
Joseph Ugoretz, PhD</span></div>
<span style="background-color: rgba(255, 255, 255, 0);">Associate Dean<br>
Teaching, Learning and Technology<br>
Macaulay Honors College, CUNY<br>
<a href="x-apple-data-detectors://2/1" x-apple-data-detectors="true" x-apple-data-detectors-type="address" x-apple-data-detectors-result="2/1">35 West 67th St.</a><br>
<a href="x-apple-data-detectors://2/1" x-apple-data-detectors="true" x-apple-data-detectors-type="address" x-apple-data-detectors-result="2/1">New York, New York 10023</a><br>
<a href="tel://212-729-2920">212-729-2920</a></span></div>
<div><br>
On Jun 24, 2015, at 8:20 PM, Grogan, David <<a href="mailto:David.Grogan@tufts.edu">David.Grogan@tufts.edu</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">This is good info Joe. According to our sys admin the huge number of tables (as you know WP schema isn’t exactly normalized) starts to cause real issues with MySQL backups. I’ll ask him to delve a bit deeper
into what those issues are.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">David<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> wp-edu [<a href="mailto:wp-edu-bounces@lists.automattic.com">mailto:wp-edu-bounces@lists.automattic.com</a>]
<b>On Behalf Of </b>Joseph Ugoretz<br>
<b>Sent:</b> Wednesday, June 24, 2015 8:10 PM<br>
<b>To:</b> Low-traffic list discussing WordPress in education.<br>
<b>Subject:</b> Re: [wp-edu] Process for pruning/retiring inactive sites?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">We've found that students will sometimes return to a site and pick it up again even after several years of inactivity. We want to make sure never to preclude that possibility, so we don't prune old or inactive sites at all. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I don't think I could trust any automated system, and I certainly don't want that manual drudgery. And I don't want a student to ever find that her work, no matter how preliminary and initial, has disappeared--or even give her the impression
that she needs to tidy it up or make it disappear. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Is it really that big a drag on the system to have some inactive sites? (We are up to over 4,000 sites now, and probably only 50-60% are "active"--depending on your definition). Enough to justify the time consuming drudgery? Why not just
let them remain?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Joe<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">-- <br>
Joseph Ugoretz, PhD<o:p></o:p></p>
</div>
<p class="MsoNormal">Associate Dean<br>
Teaching, Learning and Technology<br>
Macaulay Honors College, CUNY<br>
<a href="x-apple-data-detectors://2/1">35 West 67th St.</a><br>
<a href="x-apple-data-detectors://2/1">New York, New York 10023</a><br>
<a href="tel://212-729-2920">212-729-2920</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
On Jun 24, 2015, at 7:29 PM, Grogan, David <<a href="mailto:David.Grogan@tufts.edu">David.Grogan@tufts.edu</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">Hello all,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">What process do you have in place to clean up your WP instance of old and inactive sites? Every summer we look at this and go through a process of manual identification (e.g. sites not updated in past 6 months) and go about trying to contact
site admins for permission to delete. It’s time consuming and drudgery. <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">David<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">--------------------------------------------------------------<o:p></o:p></p>
<p class="MsoNormal">David Grogan<o:p></o:p></p>
<p class="MsoNormal">Senior Solutions Specialist<o:p></o:p></p>
<p class="MsoNormal">Educational Technology Services (ETS) Tufts Technology Services (TTS) Tufts University<o:p></o:p></p>
<p class="MsoNormal">108 Bromfield Rd<o:p></o:p></p>
<p class="MsoNormal">Somerville, MA 02144<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Phone: 617.627.2859<o:p></o:p></p>
<p class="MsoNormal">Fax: 617.627.3082<o:p></o:p></p>
<p class="MsoNormal"><a href="http://it.tufts.edu/ests">http://it.tufts.edu/ests</a><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</blockquote>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif"">_______________________________________________<br>
wp-edu mailing list<br>
<a href="mailto:wp-edu@lists.automattic.com">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu">http://lists.automattic.com/mailman/listinfo/wp-edu</a><o:p></o:p></span></p>
</div>
</blockquote>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>wp-edu mailing list</span><br>
<span><a href="mailto:wp-edu@lists.automattic.com">wp-edu@lists.automattic.com</a></span><br>
<span><a href="http://lists.automattic.com/mailman/listinfo/wp-edu">http://lists.automattic.com/mailman/listinfo/wp-edu</a></span><br>
</div>
</blockquote>
</body>
</html>