I sincerely hope you're fast at the keybord. We run multiple streams in a live
environment on 1 rdserver. This doesn't seam an acceptable option to me. Better
sequence : create new load swap old/new delete old
Verzonden vanaf mijn Samsung-apparaat
-------- Oorspronkelijk bericht --------
Van: [email protected]
Datum: 27-09-2018 18:00 (GMT+01:00)
Aan: [email protected]
Onderwerp: Rivendell-dev Digest, Vol 65, Issue 16
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: Backup/Restoring the DB via command line [WAS: Moving RD
to another system] (Fred Gleason)
----------------------------------------------------------------------
Message: 1
Date: Thu, 27 Sep 2018 11:25:46 -0400
From: Fred Gleason <[email protected]>
To: rivendell-dev <[email protected]>
Subject: Re: [RDD] Backup/Restoring the DB via command line [WAS:
Moving RD to another system]
Message-ID: <[email protected]>
Content-Type: text/plain; charset="utf-8"
On Sep 27, 2018, at 09:25, Lorne Tyndale <[email protected]> wrote:
> As far as I understand the Restore in rdadmin does not do a schema check
> / update, so it will work if you are staying at the same version of
> Rivendell.
Actually, it *does* check the schema after the basic restore is complete, and
will run an update if required.
That said, one get's much more fine-grained control by using the command-line
utilities for backup and restore. (In fact, in the upcoming v3.x release, the
backup and restore buttons have been completely removed from RDAdmin). Here?s
how:
BACKUP - Just do:
mysqldump -h <server-ip-addr> -u rduser -p Rivendell >
my-backup-file.sql
or, if you want to get fancy, you can compress the backup on-the-fly:
mysqldump -h <server-ip-addr> -u rduser -p Rivendell | gzip >
my-backup-file.sql.gz
RESTORE - Do:
echo drop\ database\ Rivendell\; | mysql -h <server-ip-address> -u
rduser -p
echo create\ database\ Rivendell\; | mysql -h <server-ip-address> -u
rduser -p
cat my-backup-file.sql | mysql -h <server-ip-addr> -u rduser -p
Rivendell
That first command *completely deletes* the previously existing Rivendell DB,
so be careful! What?s happening here is that:
1) We delete the existing DB
2) Create a new, empty DB
3) Write our backup into the new, empty DB
If you have a compressed backup, you?d replace the third line above with this:
gzip -cd my-backup-file.sql.gz | mysql <server-ip-addr> -u rduser -p
Rivendell
First thing after the restore completes, run rdadmin to check (and if necessary
update) the schema. You?re done!
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/20180927/f42c16a7/attachment-0001.html>
------------------------------
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
End of Rivendell-dev Digest, Vol 65, Issue 16
*********************************************
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
