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

[jules at zend.to]

Glenn,

Switch off the Apache daemon (systemctl stop apache2 or systemctl stop 
httpd) so you know nothing will be trying to change it.
Then just copy the single zendto.sqlite file to wherever you want it to go.
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.

Cheers,
Jules.

On 18/11/2021 19:47, Glenn Noel via ZendTo wrote:
> 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 <http://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/zendto
> Obviously 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 <http://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
>
>
> _______________________________________________
> ZendTo mailing list
> ZendTo at zend.to
> http://jul.es/mailman/listinfo/zendto

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

www.Zend.To
Twitter: @JulesFM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://jul.es/pipermail/zendto/attachments/20220107/b7fd8ccb/attachment.html>