Linux/MythTV

MySQL Root-Passwort setzen

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('ROOT_PWD') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

Datenbankzugriff für Remote Frontends erlauben

$ mysql -u root -p mythconverg
mysql> grant all on mythconverg.* to mythtv@"192.168.0.%" identified by "mythtv";
mysql> flush privileges;
mysql> quit

Backup der Datenbank

$ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql

Restore der Datenbank

$ mysql -u root -p
mysql>create database mythconverg;
mysql>exit
$ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql

Hostname in der DB ändern

$ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql

$ cat mythtv_backup.sql | sed s/\'frontend1\'/\'kidsroom\'/g >> mythtv_restore.sql

$ mysql -u root -p
mysql>drop database mythconverg;
mysql>create database mythconverg;
mysql>exit

$ mysql -u mythtv -pmythtv mythconverg < mythtv_restore.sql