What is the simplest Rivendell setup ? You need :
- any recent computer
- any sound card supported by alsa
- in our case, a debian or ubuntu
- something like gnome and kde
- five minutes
Objective : a first sound in Rivendell :
Tag Archives: mysql
Par où commencer l’installation de Rivendell
La mise en production de Rivendell ne se limite pas à installer un package sur une machine. De nombreuses questions se posent lors de la préparation de son installation. C’était justement le sujet d’une réunion avec l’équipe de Divergence FM au début du mois. Le support préparé pour cette discussion a donné naissance à une présentation de quelques 40 slides.
Migrate data from postgresql to mysql
Several of the Tryphon applications are in production with postgresql databases. AudioBank is in this case. Mostly because Tim is persuaded that MySql sucks :-p
In my laptop, only MySql is running. So to retrieve production data, I need to migrate it.
Dump only data from the wanted postgresql database :
pg_dump -d -a --column-inserts <database> > data.sql
Remove postgresql specific instructions :
sed -i -e '/^SET / d' -e '/^SELECT pg_catalog/ d' data.sql
If needed, change quotes used for postgresql reserved keywords (in column names for example) :
sed -i -e 's/"key"/`key`/' -e 's/"type"/`type`/' \ -e 's/"version"/`version`/' -e 's/"password"/`password`/' data.sql
Create a fresh structure of your mysql database (with rake db:migrate for example) and insert the data :
mysql database < data.sql
The NAS of our mobile studio
Our Autres(M)Ondes mobile studio integrates for a while a NAS server dedicated to rivendell mysql and files. The first steps to set up a such server are described into the Rivendell wiki page Setting up a dedicated Rivendell MySQL and audio store server.