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