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 |
|---------------------------------------------------------------------|_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
