On Tuesday 29 January 2013 05:17:18 pm ICR Programs wrote:
The issue that worries me is this: I am not able to back up the database.
I should be able to, shouldn't I?
(this was using the Backup Database button on RDAdmin) and trying it from
command line (though I am not sure how to do that).
Hi,
I suppose the database isn't locally or mysql user specified in
rd.conf (usually *rduser*) doesn't have enough rights to do that
(specifically LOCK TABLES) or both of them.
Here two solutions:
- You give those rights to the user under which you run the backup. If
it has LOCK TABLES, it may be
Hi Alessio and list members,
Thank you once more for your assistance!
We run a pretty basic setup: one machine running Rivendell and the backup
volumes are two hard drives, one internal the other external that have
/var/snd copied to them each day. The same user, 'rd' is what I've been
logged
try this, I left out a hyphensorry, I had to write it down and
retype on another machine. should have been --lock-tables=false.
mysqldump -u rduser -pletmein --lock-tables=false Rivendell
/home/rd/Desktop/testrd.sql
Nathaniel C. Steele
Assistant Chief Engineer/Technical Director
WTRM-FM /
Fantastic! This worked (thank you!) Two points: 1) I had to take the
soft line break out between /home ... for it to work (not a biggie, even
a novice like me figured that out. And 2) so if this works from the command
line, why is it that the button for Database backup still doesn't work in
Subject: [RDD] Rivendell v2.4.0 and RDAdmin Update -- How does one do the
RDAmin Update?
Date: Wed, Jan 30, 2013 7:13 pm
Fantastic! This worked (thank you!) Two points: 1) I had to take the soft
line break out between /home ... for it to work (not a biggie, even a novice
like me figured that out
Dear list members,
I'm sorry to basically post this same question again, but the thread it was
in went in another direction and I didn't want to get my query lost in the
shuffle.
What I did glean from the thread and a few other messages was that Apache
may be at play here ... however, I don't
To update the schema you just need to run RDAdmin. From memory not
much happens as far as the user is concerned (unless it dies in which
case you get an error message). As for the mysqldump error it failed
because it couldn't lock the tables on a live system. You can dump
without lock
Thanks Wayne,
The issue that worries me is this: I am not able to back up the database.
I should be able to, shouldn't I?
(this was using the Backup Database button on RDAdmin) and trying it from
command line (though I am not sure how to do that).
And, the system wasn't 'live' in the sense that
I had the same problem, it has nothing to do with the 2.4.0 update.
Google mysql errno 24 and find out how to do a backup without lock
tables from the command line. IF you give me some time I'll tell you the
command that worked for me but I'll have to go find it in the history.
Wish it would
Thanks again, to the best user list out there!
Nathan, I can wait. I'll google it anyway to see what I can glean, but I am
sooo far from a power user I don't want to break anything.
Is this in anyway related to our not being able to see anything in the
GUI's Trash folder? We can only see if
Is this in anyway related to our not being able to see anything in the
GUI's Trash folder?
I wouldn't think so, but I am no expert either.
This worked for me from the terminal as root, not sure it was necessary
to be root but it probably was or I wouldn't have done it
mysqldump -u
Thanks so much, Nathan. I really appreciate the details with each step, as
that helps me learn.
I tried your command but I got an error of 'unknown variable'. I copied and
pasted from the email, so perhaps the spacing got thrown off. I didn't
want to mess with it and break something, so I left
13 matches
Mail list logo