[RDD] Sorry slightly off-topic
gstephens at orcon.net.nz
Fri Nov 2 10:17:28 EDT 2007
Ah ha! Found my problem. I wasn't using the default database in the rd.conf
file and I was using small letters rivendell not Rivendell as the database.
Now I backed up the right mysql folder but via RDAdmin it doesn't allow a
backup of any other database other than "Rivendell" capital letter
Now there's a whole heap of stuff exporting even for just two audio cuts.
Perhaps it would be handy if RDAdmin when it goes to backup the database
pays attention to the rd.conf file and uses the database name provided there
----- Original Message -----
From: "Gavin Stephens" <gstephens at orcon.net.nz>
To: "User discussion about the Rivendell Radio Automation System"
<rivendell-dev at techweb.rfa.org>
Sent: Saturday, November 03, 2007 1:57 AM
Subject: Re: [RDD] Sorry slightly off-topic
> Okay here's the exported file (pasted in this email aswell). After some
> drive swapping (I'm building another PC for Rivendell in the middle of
> things) I did another export.
> This was exported from SUSE 10.2 and the latest Rivendell release. There's
> only two audio cuts in the library at the moment but there's no cut
> information in the sql file RDAdmin outputs when I do a backup database.
> resigning to re-entering all the carts again by hand, just a little
> frustrating that I still have the old sql folder of rivendell that still
> all that stuff in there. It sounds like the backup process is quite simple
> but just not working for me.
> -- MySQL dump 10.10
> -- Host: localhost Database: Rivendell
> -- ------------------------------------------------------
> -- Server version 5.0.26
> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
> /*!40101 SET NAMES utf8 */;
> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
> /*!40103 SET TIME_ZONE='+00:00' */;
> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
> FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
> /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
> /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
> /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
> /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
> /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
> /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
> /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
> /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
> -- Dump completed on 2007-11-03 1:48:41
> ----- 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
> > > 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
> > > to do a backup of the actual cart information etc... without knowing
> > > 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
> > /*!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
> > (etc.)
> > No data followed yours? Do a search fo "INSRERT INTO" - that's the
> > command to put the data back in the database...
> > ...Kevin
> > --
> > Kevin Miller
> > http://www.alaska.net/~atftb
> > Juneau, Alaska
> > Registered Linux User No: 307357
> > _______________________________________________
> > Rivendell-dev mailing list
> > Rivendell-dev at techweb.rfa.org
> > http://techweb.rfa.org/mailman/listinfo/rivendell-dev
> Rivendell-dev mailing list
> Rivendell-dev at techweb.rfa.org
More information about the Rivendell-dev