Excellent - operating perfectly now! Thank you very much! I will save this into my cheat-notes.
On Sun, Jul 18, 2021 at 12:15 PM < [email protected]> wrote: > Send Rivendell-dev mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > or, via email, send a message with subject or body 'help' to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Rivendell-dev digest..." > > > Today's Topics: > > 1. Re: RDAdmin will not start (Fred Gleason) > 2. Issues importing 4 hr long file with normalize on? (Lorne Tyndale) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 17 Jul 2021 13:51:41 -0400 > From: Fred Gleason <[email protected]> > To: Rivendell-dev mailing list > <[email protected]> > Subject: Re: [RDD] RDAdmin will not start > Message-ID: <[email protected]> > Content-Type: text/plain; charset="utf-8" > > On Jul 17, 2021, at 10:10, Jesse Jones <[email protected]> wrote: > > > Something went wrong in restoring a copied database through RDAdmin - > the gui "flashed" and now the GUI for RDAdmin refuses to open - so I can't > even roll it back to a previous version. > > > > When I invoked RDAdmin as root in the command line - I get multiple > lines of: > > invalid SQL or failed DB connection[Table 'Rivendell.VERSION' doesn't > exist QMYSQL3: Unable to execute query]: select DB from VERSION > > > > I am nonconversant with mySQL mechanics so I need neophyte instructions > on how to get this ON AIR machine back on line. The CentOS is working - > only Rivendell is down. > > To restore a DB backup ?manually? from the command-line, run the following > commands from a non-root shell on the machine running MySQL: > > echo drop\ database\ Rivendell\; | mysql -u -p > echo create\ database\ Rivendell\; | mysql -u -p > cat <path-to-db-backup-file> | mysql -u -p Rivendell > > Then get a root shell and restart the Rivendell service by doing: > > service rivendell restart > > N.B. ? the above procedure will COMPLETELY REMOVE the previously loaded > database. > > Cheers! > > > |---------------------------------------------------------------------| > | Frederick F. Gleason, Jr. | Chief Developer | > | | Paravel Systems | > |---------------------------------------------------------------------| > | A room without books is like a body without a soul. | > | | > | -- Cicero | > |---------------------------------------------------------------------| > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20210717/0e17f819/attachment-0001.html > > > ------------------------------ > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > > End of Rivendell-dev Digest, Vol 99, Issue 18 > ********************************************* >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
