[RDD] Sorry slightly off-topic

Kevin Miller atftb2 at alaska.net
Fri Nov 2 20:04:01 EDT 2007


Gavin Stephens wrote:
> I'll have to go back and learn some more on this. I thought the *.sql backup
> 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 only
> 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 database
> was stored. I see there doesn't appear to be an easy backup for dummies way
> 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
Labs',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,10000,10000,0,10000,1,NULL,NULL,2,NULL,NULL,'N','N','N',NULL,NULL),(0,1,'Music
1','March of the Mad Maiden','Kim Angelis','Violin
Voyager',NULL,NULL,'','','',NULL,NULL,'',0,0,0,0,0,0,NULL,0,3,NULL,NULL,'N','N','N',NULL,NULL),
(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


More information about the Rivendell-dev mailing list