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 -pletmein --locktables=false Rivendell >
/home/rd/20130110rd.sql
I'll break it down as best I understand
mysqldump the command to do the backup
-u rduser the username to access mysql, this is the default if you
areusing the broadcast appliance installation, otherwise it will be
whatever you setup.
-pletmein the password to login to mysql, again default on Broadcast
appliance. the username and password are the same as what is specified
in the rd.conf file also. not the lack of a space between the -p flag
and the password is intentional. you can also just use -p but then it
will ask you for the password.
--locktables=false tells mysql not to lock the tables, which is what was
causing you the error. so potentially the database could lose some
things like if a song plays during the backup the play count could be
off by one. maybe worse things could happen I don't know....
Rivendell the database you wish to backup
> /home/rd/20130110rd.sql tells where you want the backup to go,
including what the file will be named. i use the date and add rd to
remind me it is the rivendell database. note there is a space between >
and the path.
AS a curious side effect, the resulting backup shows as a 0kb file, but
it actually is not and has data in it. not sure why
If any f my info is wrong someone please correct me, but I had to do
this during a recent server migration and it was a success.
Thanks,
Nathaniel C. Steele
Assistant Chief Engineer/Technical Director
WTRM-FM / TheCrossFM
On 1/29/2013 5:31 PM, ICR Programs wrote:
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 the Terminal as in
cd .Trash
ls -al .....
then I manually delete by using
rm *.*
On Tue, Jan 29, 2013 at 5:22 PM, Nathan Steele
<[email protected] <mailto:[email protected]>>
wrote:
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 work right from RDadmin though.
Nathaniel C. Steele
Assistant Chief Engineer/Technical Director
WTRM-FM / TheCrossFM
On 1/29/2013 5:17 PM, ICR Programs wrote:
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 didn't have
RDAirplay or any other Rivendell components running. I rebooted
the system and then tried all this.
Any suggestions, please?
thanks!
Rene
On Tue, Jan 29, 2013 at 4:36 PM, waynemerricks
<[email protected]
<mailto:[email protected]>> wrote:
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 but data integrity is not guaranteed as
changes
could have been made while the dump was running.
Basically, business as usual but an off putting error message
that
makes you wonder.
Regards,
Wayne
On 2013-01-29 21:27, ICR Programs wrote:
> Dear list members,
>
> Im sorry to basically post this same question again, but
the thread
> it
> was in went in another direction and I didnt 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 dont know
anything about
> Apache or how/why it was affect our system such that we
were able to
> back up the Database before upgrading from 2.3.x to 2.4.0
>
> Also, Im NOT sure about whether this is relevant, and
indeed it was a
> problem that cropped up BEFORE this v2.4.0 update, but
whenever one
> moves a file to the trash (logged in as user rd) it doesnt
appear in
> the GUI in the Trash. If one logs in via terminal,
however, the
> deleted files are there and one can expunge them from the
system. I
> am guessing this is a permissions problem, but am mystified
why it
> would have happened.
>
> Thanks to all!
> Rene
>
> Hello Fred and all,
>
> Thanks for your work on the updates and indeed, the
Rivendell System.
>
> I upgraded, but have what I hope is a slight problem.
>
> I used the Package Updater -- it had a notification up
about the
> updates -- and it installed fine.
>
> I then opened RDAdmin, typed the user name "admin" and
wasnt sure
> what
> to do next in order to update the database schema (which is
now,
> according to System Info, Rivendell Version 2.4.0; Database
schema
> 216).
>
> I did try to do a backup of the database, and that gave the
error
> "Unable to create backup"
>
> I then went to Terminal, typed "rddamin" and got this:
>
> Terminal Output:
>
> [rd@icr-dj-desktop ~]$ rdadmin
> mysqldump: Got error: 1016: Cant open file:
> ./Rivendell/Weekday_6_AM_CLK.frm (errno: 24) when using
LOCK TABLES
>
> What should I do now, please?
>
> Thanks,
> Rene
>
> --
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> "Democracy is not a spectator
> sport"
>
> Ithaca Community Radio -- 88.1 FM in
> Ithaca
> WRFI 91.9 FM in
> Watkins Glen
> WINO 89.9 FM
> in Odessa
>
> News, Culture & Information from our Neighborhoods and the
World
>
> _Phone_: 607.319.5445 <tel:607.319.5445> [1]
> _Email_: [email protected]
<mailto:[email protected]> [2]
> _Web_: http://ithacaradio.org/ [3]
>
>
> Mailing address:
> The Clinton House
> 103 West Seneca St.
> Suite 305
> Ithaca, N.Y, 14850
>
>
>
> Links:
> ------
> [1] http://mail2.thevoiceasia.com/tel:607.319.5445
> [2] mailto:[email protected]
<mailto:[email protected]>
> [3] http://ithacaradio.org/
_______________________________________________
Rivendell-dev mailing list
[email protected]
<mailto:[email protected]>
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Democracy is not a spectator sport"
Ithaca Community Radio -- 88.1 FM in Ithaca
WRFI 91.9 FM in Watkins Glen
WINO 89.9 FM in Odessa
News, Culture & Information from our Neighborhoods and the World
/Phone/: 607.319.5445 <tel:607.319.5445>
/Email/: [email protected] <mailto:[email protected]>
/Web/: http://ithacaradio.org/
Mailing address:
The Clinton House
103 West Seneca St.
Suite 305
Ithaca, N.Y, 14850
_______________________________________________
Rivendell-dev mailing list
[email protected]
<mailto:[email protected]>
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
<mailto:[email protected]>
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Democracy is not a spectator sport"
Ithaca Community Radio -- 88.1 FM in Ithaca
WRFI 91.9 FM in Watkins Glen
WINO 89.9 FM in Odessa
News, Culture & Information from our Neighborhoods and the World
/Phone/: 607.319.5445
/Email/: [email protected] <mailto:[email protected]>
/Web/: http://ithacaradio.org/
Mailing address:
The Clinton House
103 West Seneca St.
Suite 305
Ithaca, N.Y, 14850
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
