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" <zotz...@gmail.com>
To: "Warren Mead" <vk...@westnet.com.au>
Cc: "User discussion about the Rivendell Radio Automation System"
<Rivendell-dev@lists.rivendellaudio.org>
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 < vk...@westnet.com.au > 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
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
--
Enjoy great Bahamian Music at:
Bahamain Or Nuttin - http://www.bahamianornuttin.com
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
___
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
