[ZendTo] Migrating current drop-offs to a new Zend.to server

[Glenn Noel]

Hello folks,

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 zend.to database and drop-offs from an older server to
a new server?

My database is the default SQLite3 (/var/zendto/zendto.sqlite) that
installs via the Zend.to installer .  I found the following historical
post: http://mailman.ecs.soton.ac.uk/pipermail/zendto/2018-March/003159.html
.
This post indicates:

 *"Export your database (full dump and upgrade schema or just data
spending on your old version"*

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.

The next post in the thread that I listed above:
http://mailman.ecs.soton.ac.uk/pipermail/zendto/2018-March/003160.html

"















*1. Comment out the cron jobs in /etc/cron.d/zendto and then restart crond
on both your old and new servers before you give them both access to the
database.Failure to do this will result in the overnight cleanup job
*wiping all your drop-offs and/or database records* of them.2. After you've
copied all the /var/zendto stuff over to your new server, then assuming
your new server is using SELinux (which it will be by default), you need to
reset the SELinux attributes on everything under /var/zendto.Fortunately
this is very easy. On the new server, as root do     restorecon -FivR
/var/zendtoObviously you'll need to make sure the basic owner, group and
permissions are correct after your rsync (or however you're getting them
there), but things won't work unless you do the restorecon above as well.
"ls -Z" shows you the SELinux attributes. The "-FivR" options make it
recurse and show you any files it changes the attributes of."*

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?

All assistance is always appreciated.

Glenn


On Thu, Oct 21, 2021 at 1:16 PM Glenn Noel <glenn.noel at gmail.com> wrote:

> Hello Zendto community,
>
> 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.
>
> 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.
>
> I have looked over the zend.to 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?
>
> Thanks for any assistance you can provide.
>
> Glenn
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://jul.es/pipermail/zendto/attachments/20211118/5bf64d93/attachment.html>