On Jul 6, 2018, at 18:04, Peter Claes <peterclsb...@gmail.com> wrote:
> If so what would be the correct commands to get the .sql file into the
> database ?
> How do I get all the permissions right ?
Once you’ve got the test tone playing, you’re 90% there.
Here’s the Fred (aka “The Command-Line Troglodyte”) method:
WARNING: This procedure will DESTROY the Rivendell database that is currently
loaded on the machine!
From a shell on the machine running MySQL/MariaDB, do:
mysql -A -u root -p Rivendell
You’ll be prompted for a password. Enter the one you set for MySQL in the
‘Final Steps’ section of the install guide. You should then get a ‘mysql>’
prompt. Enter the following commands (including trailing punctuation):
drop database Rivendell;
create database Rivendell;
exit;
Now, find your sql backup file, then run the following command:
cat <path-to-backup-file> | mysql -u root -p Rivendell
(The ‘|’ is the ‘pipeline’ character. Shift-Backslash on my keyboard, although
that can vary.)
You’ll be prompted for that MySQL password again. Enter it. When the command
completes, start up rdadmin. You should get the message about needing to update
the DB schema. Click ‘OK’ and let it run. When you get the RDAdmin login,
you’re done.
Cheers!
|----------------------------------------------------------------------|
| Frederick F. Gleason, Jr. | Chief Developer |
| | Paravel Systems |
|----------------------------------------------------------------------|
| Do not try to think outside of the box. That's impossible. |
| Instead, realise the truth. There is no box. |
| --Quoted by "larsmjoh" on GrokLaw.net |
|----------------------------------------------------------------------|
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
