<div dir="ltr">Davis,<div><br></div><div>I would even see if you can't find all sites that only have one post, like "Hello World," and delete those sites, so you can still clean out your system, but keep the stuff that folks may want later on. I know there are some scripts for this we used a year ago or so.</div><div><br></div><div>Jim</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Jun 24, 2015 at 8:20 PM, Grogan, David <span dir="ltr"><<a href="mailto:David.Grogan@tufts.edu" target="_blank">David.Grogan@tufts.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<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.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">David<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></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 [mailto:<a href="mailto:wp-edu-bounces@lists.automattic.com" target="_blank">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?<u></u><u></u></span></p>
</div>
</div><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></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. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></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. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></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?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Joe<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">-- <br>
Joseph Ugoretz, PhD<u></u><u></u></p>
</div>
<p class="MsoNormal">Associate Dean<br>
Teaching, Learning and Technology<br>
Macaulay Honors College, CUNY<br>
<a>35 West 67th St.</a><br>
<a>New York, New York 10023</a><br>
<a href="tel://212-729-2920" target="_blank">212-729-2920</a><u></u><u></u></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" target="_blank">David.Grogan@tufts.edu</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">Hello all,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></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. <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">David<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">--------------------------------------------------------------<u></u><u></u></p>
<p class="MsoNormal">David Grogan<u></u><u></u></p>
<p class="MsoNormal">Senior Solutions Specialist<u></u><u></u></p>
<p class="MsoNormal">Educational Technology Services (ETS) Tufts Technology Services (TTS) Tufts University<u></u><u></u></p>
<p class="MsoNormal">108 Bromfield Rd<u></u><u></u></p>
<p class="MsoNormal">Somerville, MA 02144<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Phone: <a href="tel:617.627.2859" value="+16176272859" target="_blank">617.627.2859</a><u></u><u></u></p>
<p class="MsoNormal">Fax: <a href="tel:617.627.3082" value="+16176273082" target="_blank">617.627.3082</a><u></u><u></u></p>
<p class="MsoNormal"><a href="http://it.tufts.edu/ests" target="_blank">http://it.tufts.edu/ests</a><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></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" target="_blank">wp-edu@lists.automattic.com</a><br>
<a href="http://lists.automattic.com/mailman/listinfo/wp-edu" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><u></u><u></u></span></p>
</div>
</blockquote>
</div></div></div>
</div>
<br>_______________________________________________<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" rel="noreferrer" target="_blank">http://lists.automattic.com/mailman/listinfo/wp-edu</a><br>
<br></blockquote></div><br></div>