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 th
It apparently does not use the --lock-tables=false flag.
Sent from my HTC smartphone on the Now Network from Sprint!
- Reply message -
From: "ICR Programs"
To: "User discussion about the Rivendell Radio Automation System"
Subject: [RDD] Rivendell v2.4.0 and RDAdmi
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
RD
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 /
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 in
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
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 t
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 rduser
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 from
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 w
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
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 tables
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 k
13 matches
Mail list logo