[RDD] Sorry slightly off-topic
gstephens at orcon.net.nz
Fri Nov 2 08:13:23 EDT 2007
I thought so. What it does for you it doesn't for me. I was running RD
0.9.82-1 on openSUSE 10.2 when I added the audio and cart info. I did the
export using RDAdmin to a *.sql file. That file was less than 2KB and it
contained nothing that represented anything like what you've posted. It was
a bunch of other SQL stuff.
SQL was running and Rivendell was using the database quite successfully and
I had over 200 items in the Library along with some events-clocks-grids all
I'll go back in to Rivendell soon and put a few items in the database then
do an export via RDAdmin to show you what I mean about not having anything
like you've responded with below.
I tried just replacing the rivendell folder that I still have with
everything from the old database but it didn't want a bar of it and I had to
remove the folder and let RD create a new database again. I'll go do a
search on what you've mentioned aswell and get back to you soon with an
export example from RDAdmin.
----- Original Message -----
From: "Kevin Miller" <atftb2 at alaska.net>
To: "User discussion about the Rivendell Radio Automation System"
<rivendell-dev at techweb.rfa.org>
Sent: Saturday, November 03, 2007 1:04 PM
Subject: Re: [RDD] Sorry slightly off-topic
> Gavin Stephens wrote:
> > I'll have to go back and learn some more on this. I thought the *.sql
> > from RDAdmin would include all the details of the carts in the backup.
> > However when I opened the *.sql backup file saved to the desktop it was
> > a page full of sql looking code/settings and that's all it exported.
> > That's why I ended up just copying the entire folder where all the
> > was stored. I see there doesn't appear to be an easy backup for dummies
> > to do a backup of the actual cart information etc... without knowing sql
> > more.
> Odd. I exported the database, and I have lots of data mixed in with the
> sql commands and such. For instance, here's the start of the carts table:
> /*!40000 ALTER TABLE `CART` DISABLE KEYS */;
> LOCK TABLES `CART` WRITE;
> INSERT INTO `CART` (`NUMBER`, `TYPE`, `GROUP_NAME`, `TITLE`, `ARTIST`,
> `ALBUM`, `YEAR`, `ISRC`, `LABEL`, `CLIENT`, `AGENCY`, `PUBLISHER`,
> `COMPOSER`, `USER_DEFINED`, `USAGE_CODE`, `FORCED_LENGTH`,
> `AVERAGE_LENGTH`, `LENGTH_DEVIATION`, `AVERAGE_SEGUE_LENGTH`,
> `CUT_QUANTITY`, `LAST_CUT_PLAYED`, `PLAY_ORDER`, `VALIDITY`,
> `START_DATETIME`, `END_DATETIME`, `ENFORCE_LENGTH`, `PRESERVE_PITCH`,
> `ASYNCRONOUS`, `OWNER`, `MACROS`) VALUES (999999,1,'TEST','Test
> Tone','Salem Radio
> 1','March of the Mad Maiden','Kim Angelis','Violin
> No data followed yours? Do a search fo "INSRERT INTO" - that's the
> command to put the data back in the database...
> Kevin Miller
> Juneau, Alaska
> Registered Linux User No: 307357
> Rivendell-dev mailing list
> Rivendell-dev at techweb.rfa.org
More information about the Rivendell-dev