<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class="">As the subject says, i have moved my backend/frontend to a new box, a new distribution *and* a new name<div class=""><br class=""></div><div class="">The new box is fully functional, but before I start recording and creating rules, I'd like to get my old recordings out of the old box. </div><div class=""><br class=""></div><div class="">The database versions are the same (I was using 0.22 from rpmfusion, now Mythbuntu 9.10 - 0,22)</div><div class="">i have a backup or three , taken with the new mythconverg_backup.pl</div><div class="">The mysql password under mythbuntu is a pain - the mythtv user password is OK, as its in a text file, but i can't for the life of me find the db root user, so the following :</div><div class=""><br></div><div class=""><a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup">http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup</a></div><div class=""><span style="font-family: sans-serif; font-size: 13px; line-height: 19px; " class="Apple-style-span"><div style="margin-top: 0.4em; margin-right: 0px; margin-bottom: 0.5em; margin-left: 0px; line-height: 1.5em; " class="">Before performing a partial restore, the database must exist and must have tables. After dropping the mythconverg database:</div><pre style="padding-top: 1em; padding-right: 1em; padding-bottom: 1em; padding-left: 1em; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: dashed; border-right-style: dashed; border-bottom-style: dashed; border-left-style: dashed; border-top-color: rgb(47, 111, 171); border-right-color: rgb(47, 111, 171); border-bottom-color: rgb(47, 111, 171); border-left-color: rgb(47, 111, 171); color: black; background-color: rgb(249, 249, 249); line-height: 1.1em; " class="">DROP DATABASE IF EXISTS mythconverg;</pre><div style="margin-top: 0.4em; margin-right: 0px; margin-bottom: 0.5em; margin-left: 0px; line-height: 1.5em; " class="">run the mc.sql script, as described <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Database_Restore" title="Database Backup and Restore" style="text-decoration: none; color: rgb(0, 43, 184); background-image: none; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: initial; background-position: initial initial; " class="">above</a>. Then, start mythtv-setup to create the database schema. Exit mythtv-setup, and then restore the database:</div><pre style="padding-top: 1em; padding-right: 1em; padding-bottom: 1em; padding-left: 1em; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: dashed; border-right-style: dashed; border-bottom-style: dashed; border-left-style: dashed; border-top-color: rgb(47, 111, 171); border-right-color: rgb(47, 111, 171); border-bottom-color: rgb(47, 111, 171); border-left-color: rgb(47, 111, 171); color: black; background-color: rgb(249, 249, 249); line-height: 1.1em; " class="">mythconverg_restore.pl --partial_restore</pre></span><div class="">will not work unless I have the mysql root password</div><div class=""><br></div><div class="">Also, as I understand it, this should only get my recordings and rules back - will I need to reset everything again? (run mythsetup or somesuch?)</div><div class=""><br></div><div class="">What are the implications for the restore regarding the name change? The machine has the same name, but the database was on localhost, and now is on its ip address, is this going to mess the restoration?</div><div class=""><br></div><div class="">Any help or guidance appreciated. i have searched the mythbuntu forums, but the older posts suggest that the root mysql user has a blank password, and this is definitely not the case here</div><div class=""><br></div><div class=""><br></div><div class="">cheers</div><div class=""><br></div><div class="">John</div></div></body></html>