Not sure if it's useful, but I have this issue quite often so built some PHP
scripts to export and import carts between systems. This has the advantage that
you can export and import individual carts or whole groups including basically
all their metadata (not just the data exported by RDexport) and on importing
you can have new sequential cart numbers (useful if the new system has a
different range) or even change sample rates.
The scripts aren't pretty, they use RDexport and RDimport to export the audio
to a FLAC file and create an additional file for each with the extra metadata
along with the data file created by Rivendell. However I have successfully used
these to move over 5000 carts between various 2.19.2 systems without issue,
though I please backup your entire library first as I can make no assurance it
won't corrupt things in some strange way as I know we're not really meant to
read and write to the database directly.
http://radiotools.uk/download/rivendell-export-import-101.zip
Jonathan
-Original Message-
From: rivendell-dev-boun...@lists.rivendellaudio.org
[mailto:rivendell-dev-boun...@lists.rivendellaudio.org] On Behalf Of Lorne
Tyndale
Sent: 20 July 2018 16:09
To: Rick; rivendell-dev@lists.rivendellaudio.org
Subject: Re: [RDD] question on relationship /var/snd and database
For copying from 1 rivendell install to another, the easiest is to use
rivendell_filter
It will copy carts (including audio) from one Rivendell machine to
another. A few things to keep in mind though.
-It will use the same cart numbers on the destination machine as the
source machine. So if you already have carts on your destination
machine with the same cart numbers, they will be over-written
-It does not do any audio processing. It simply will copy the audio
files as-is and copy across the needed database entries
-The 2 machines need to be networked and you'll have to mount your
/var/snd from your source machine to somewhere on your destination
machine other then /var/share for the purpose of copying your audio
(once the audio is copied over you can unmount the source /var/share)
-The database on the source machine needs to be accessible over the
network
For syntax, do a:
rivendell_filter --help
Hope this helps.
Lorne Tyndale
>
>
> I have an existing RD install on which I would like to replace /var/snd
> by a different from another server. That means I would have to import
> cards and cuts also from that install. Any other tables that need to be
> replaced?
> ___
> Rivendell-dev mailing list
> Rivendell-dev@lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev