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 things as they are for now. Here's my input and output : [rd@icr-dj-desktop ~]$ mysqldump -u rduser -pletmein --locktables=false Rivendell > /home/rd/20130130rd.sql mysqldump: unknown variable 'locktables=false' [rd@icr-dj-desktop ~]$ [rd@icr-dj-desktop ~]$ mysqldump -u rduser -pletmein--locktables=false Rivendell > /home/rd/20130130rd.sql mysqldump: unknown variable 'locktables=false' [rd@icr-dj-desktop ~]$ Did I mistype something? I did try copying from the email and pasting a second and third time. Cheers, Rene On Tue, Jan 29, 2013 at 5:56 PM, Nathan Steele <nathan.ste...@thecrossfm.com > wrote: > 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 < > nathan.ste...@thecrossfm.com> 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 < >> waynemerri...@thevoiceasia.com> 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 [1] >>> > _Email_: progr...@ithacaradio.org [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:progr...@ithacaradio.org >>> > [3] http://ithacaradio.org/ >>> >>> _______________________________________________ >>> Rivendell-dev mailing list >>> Rivendell-dev@lists.rivendellaudio.org >>> 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*: progr...@ithacaradio.org >> *Web*: http://ithacaradio.org/ >> >> >> Mailing address: >> The Clinton House >> 103 West Seneca St. >> Suite 305 >> Ithaca, N.Y, 14850 >> >> >> >> >> >> >> _______________________________________________ >> Rivendell-dev mailing >> listRivendell-dev@lists.rivendellaudio.orghttp://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> >> >> >> _______________________________________________ >> Rivendell-dev mailing list >> Rivendell-dev@lists.rivendellaudio.org >> 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*: progr...@ithacaradio.org > *Web*: http://ithacaradio.org/ > > > Mailing address: > The Clinton House > 103 West Seneca St. > Suite 305 > Ithaca, N.Y, 14850 > > > > > > > _______________________________________________ > Rivendell-dev mailing > listRivendell-dev@lists.rivendellaudio.orghttp://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev > > > > _______________________________________________ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > 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*: progr...@ithacaradio.org *Web*: http://ithacaradio.org/ Mailing address: The Clinton House 103 West Seneca St. Suite 305 Ithaca, N.Y, 14850
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
