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: [email protected] [mailto:[email protected]] On Behalf Of Lorne Tyndale Sent: 20 July 2018 16:09 To: Rick; [email protected] 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 > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
