Dear Warren, Yeah - you need to drop your Rivendell database completely via mysql (if you know how to do that). Then recreate the database and run a restore from the save database dump (backup) that you have.
Sounds like you did something that interrupted the restore process (you definately want to let if finish before you do anything in the database). Curios as to why you would be doing a restore at all, if all you wanted to do was back up the Db. They are mutually exclusive - you usually just do a backup - no need to restore since the data is still there after a backup.... As noted below - after deleting (dropping) the Rivendell database, if you run rdadmin - it will recreate it for you. Then - after it tells you it created the database, exit rdadmin and you can restore from your backup (assuming the backup is good). Hope this helps. Todd Baker From: "drew Roberts" <[email protected]> To: "Warren Mead" <[email protected]> Cc: "User discussion about the Rivendell Radio Automation System" <[email protected]> Sent: Friday, April 7, 2017 8:29:35 AM Subject: Re: [RDD] rdadmin won't start If you still have the backup, you could use non-Rivendell tools to drop the Rivendell database. At that point, if a correct database is indeed the problem, you should be able to run rdadmin which will, iirc, create a blank Rivendell db. The run the restore again. If that seems too dangerous, you could bring up a new (virtual) machine quickly and run a restore on that. Perhaps the backup is bad...??? all the best, drew On Fri, Apr 7, 2017 at 3:39 AM, Warren Mead < [email protected] > wrote: RDAdmin is no longer starting on our station backup computer. . This happened during a routine backup which involved the Restore Database procedure. Possibly I didn't have wait for the message that indicates that restore is complete, before moving on to Manage Hosts. If I try to start RDAdmin from the terminal, this is the message: invalid SQL or failed DB connection[Table 'Rivendell.VERSION' doesn't exist QMYSQL3: Unable to execute query]: select DB from VERSION The system is Centos 6.6, Rivendell v2.10.3 I would really appreciate any advice how to approach this. Regards Warren Mead Gold MX _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev -- Enjoy great Bahamian Music at: Bahamain Or Nuttin - http://www.bahamianornuttin.com _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
