<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Glenn,<br>
<br>
Switch off the Apache daemon (<tt>systemctl stop apache2</tt> or <tt>systemctl
stop httpd</tt>) so you know nothing will be trying to change it.<br>
Then just copy the single zendto.sqlite file to wherever you want it
to go.<br>
It's as simple as that. The entire database is held in that one
file, that's one of the things that makes SQLite so easy to use.<br>
<br>
Cheers,<br>
Jules.<br>
<br>
<div class="moz-cite-prefix">On 18/11/2021 19:47, Glenn Noel via
ZendTo wrote:<br>
</div>
<blockquote type="cite"
cite="mid:WM!e3be09e9c91d94eebddfbd20df8fe059beaceea8b762f9976169c6761985a4d89c75733729f3c2f2f161f629d8b6c860!@mx.jul.es">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hello folks,
<div><br>
</div>
<div>I'm circling back to this task and wanted to check with you
all again to see if anyone had a fairly comprehensive set of
instructions for copying/migrating a <a href="http://zend.to"
target="_blank" moz-do-not-send="true">zend.to</a> database
and drop-offs from an older server to a new server? </div>
<div><br>
</div>
<div>My database is the default SQLite3
(/var/zendto/zendto.sqlite) that installs via the Zend.to
installer . I found the following historical post: <a
href="http://mailman.ecs.soton.ac.uk/pipermail/zendto/2018-March/003159.html"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">http://mailman.ecs.soton.ac.uk/pipermail/zendto/2018-March/003159.html</a>. </div>
<div>This post indicates:</div>
<div><br>
</div>
<div> <i>"Export your database (full dump and upgrade schema or
just data spending on your old version"</i> </div>
<div><br>
</div>
<div>I have tried looking up how to export SQLite databases and
have tried and failed a frustrating amount of times. I have
very little experience with databases so it's a definitely a
learning experience for me - however I'm at the point now
where I feel I'm not making any progress. If anyone could
offer suggestions or easy-to-follow tutorials I would be
grateful.</div>
<div><br>
</div>
<div>The next post in the thread that I listed above: <a
href="http://mailman.ecs.soton.ac.uk/pipermail/zendto/2018-March/003160.html"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">http://mailman.ecs.soton.ac.uk/pipermail/zendto/2018-March/003160.html</a></div>
<div><br>
</div>
<div>"<i>1. Comment out the cron jobs in /etc/cron.d/zendto and
then restart <br>
crond on both your old and new servers before you give them
both access <br>
to the database.<br>
Failure to do this will result in the overnight cleanup job
*wiping all <br>
your drop-offs and/or database records* of them.<br>
<br>
2. After you've copied all the /var/zendto stuff over to
your new <br>
server, then assuming your new server is using SELinux
(which it will be <br>
by default), you need to reset the SELinux attributes on
everything <br>
under /var/zendto.<br>
Fortunately this is very easy. On the new server, as root do<br>
restorecon -FivR /var/zendto<br>
Obviously you'll need to make sure the basic owner, group
and <br>
permissions are correct after your rsync (or however you're
getting them <br>
there), but things won't work unless you do the restorecon
above as <br>
well. "ls -Z" shows you the SELinux attributes. The "-FivR"
options make <br>
it recurse and show you any files it changes the attributes
of."</i><br>
</div>
<div><br>
</div>
<div>This sounds pretty straight-forward (Thanks Jules :) ), but
I wanted to check with the community if all of this was still
accurate for current installs? </div>
<div><br>
</div>
<div>All assistance is always appreciated.</div>
<div><br>
</div>
<div>Glenn</div>
</div>
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Oct 21, 2021 at 1:16
PM Glenn Noel <<a href="mailto:glenn.noel@gmail.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">glenn.noel@gmail.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">Hello Zendto community,
<div><br>
</div>
<div>I have an older Zend.to server running Ubuntu Server
16.04.6 LTS running Zend Ver. 5.19-1. I've deployed and
configured a new server running Ubuntu Server 20.04.3
LTS running Zend Ver 6.11-2.</div>
<div><br>
</div>
<div>My new server is ready for production, but I'd like
to move any existing drop-offs from the old server to
the new server. </div>
<div><br>
</div>
<div>I have looked over the <a href="http://zend.to"
target="_blank" moz-do-not-send="true">zend.to</a>
site, but have been unable to find any documentation
about how to move the drop-offs. I also found some
older posts about others that have done this, but I
wanted to check if anyone could point me in the right
direction for up-to-date instructions on how to do this?</div>
<div><br>
</div>
<div>Thanks for any assistance you can provide.</div>
<div><br>
</div>
<div>Glenn</div>
</div>
</blockquote>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
ZendTo mailing list
<a class="moz-txt-link-abbreviated" href="mailto:ZendTo@zend.to">ZendTo@zend.to</a>
<a class="moz-txt-link-freetext" href="http://jul.es/mailman/listinfo/zendto">http://jul.es/mailman/listinfo/zendto</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">Jules
--
Julian Field MEng CEng CITP MBCS MIEEE MACM
'Probability factor of one to one. We have normality. I repeat, we
have normality. Anything you still can't cope with is therefore
your own problem.' - Trillian, The Hitch Hikers Guide to the Galaxy
<a class="moz-txt-link-abbreviated" href="http://www.Zend.To">www.Zend.To</a>
Twitter: @JulesFM
</pre>
</body>
</html>