=== aliby_ is now known as aliby === Seeker`_ is now known as Seeker` === pteague_work is now known as pteague === cmug is now known as cmug2 [06:36] hello? complete irc newbie here [06:38] I hope I do this right. I've composed a question... I will paste it here and hopefully it will show up right... [06:39] I haven't used IRC in ages and never used it that much so please pardon any netiquette faux pas's... Now that I've drafted my question... It's getting kinda late; is there an archive I can look for possible responses if nobody replies before I have to shut down? If it's not obvious, I am a Linux newbie and don't know all the ins n outs, so if you assume I already know about some gotcha, assume again. In A Nutshell: [06:40] my system. 10.04 has nothing recorded and I want to get the db table references into it from 8.10. I've already copied the 400gb or so of files from old to new server. The Dirty Details: I am running Mythbuntu 8.10 on a 1tb drive; it's been running for about a year. I've installed a new 2tb drive and by switching my boot drive in BIOS I've installed a "fresh" 10.04 copy of Mythbuntu on the 2tb drive. [06:40] I've figured out how to get my 100 or so recordings from the 8.10 drive to 10.04 but the database is another issue. I've seen a lot of different recommendations for this process I hoped I could find a definitive solution to get my 8.10 table data into the 10.04 db. The biggest catch is the possibility that the schema changed (and I think it did) from 8.10 to 10.04; my 8.10 DBSchemaVer is 1214. I took partial and full [06:40] If these tables had no schema changes-- I *think* I oughtta be able to do something like insert into NEWDB.TABLE select * from OLDDB.TABLE ...for each table containing recording info. But I suspect it won't be that simple. Based on some of the articles I saw, I need to get the data from these tables: record recorded oldrecorded recordedprogram recordedrating recordedmarkup recordedseek I've already copied the 3 [06:41] I know I need to bak the 10.04 db first. [06:41] Someone said if the schema changed you could use the -c parm on the db backup to keep it from getting fouled up on the insert. Not sure how that'd work, but did one backup like that. I did 3 variations of db backup (which I will admit I am not that familiar with; I figured "it's only TV shows" but now that I have some history I spose it's time to reconsider the importance of regular backups). Here are the 3 variation [06:42] --bak a few tables mysqldump -u mythtv -pXXXXXXXXX -t mythconverg record recorded \ oldrecorded recordedprogram recordedrating \ recordedmarkup recordedseek > old_myth_sometbls.sql --as above with -c parm mysqldump -u mythtv -pXXXXXXXXX -t -c mythconverg record recorded \ oldrecorded recordedprogram recordedrating \ recordedmarkup recordedseek > old_myth_sometbls_cparm.sql --bak entire db mysqldump -u mythtv -pXXXXXXX [06:42] finding "doUpgradeTVDatabaseSchema" in dbcheck.cpp; I didn't find the file on my 8.10 install; but it suggested applying the sql code to upgrade from your old schema to the new... my 8.10 DBSchemaVer is 1214; I don't know the version for 10.04. [07:38] !help [07:38] !help For a complete list of my knowledge visit: http://www.baablogic.net/Zinn.cgi Other available commands: !status, !about, !bug [bug_number]. [07:38] !status [07:38] I am alive. [07:44] ok...looks like I already fouled up... I shoulda used "pastebin" for my largeish question. Sorry. [07:46] I'm using the web based irc client... when I came back after about an hour it appeared to have disconnected or timed out. But that could have been because of the large inline question... was it a timeout or a "rtfm"-out? [08:00] !help [08:00] !help For a complete list of my knowledge visit: http://www.baablogic.net/Zinn.cgi Other available commands: !status, !about, !bug [bug_number]. [08:00] !about [08:00] I am an IRC bot written in perl, but my code is not yet released. I am named after Howard Zinn, you can learn more about him here: http://en.wikipedia.org/wiki/Howard_Zinn [08:01] !bug === _Metoer is now known as Metoer [18:59] I am getting the following error trying to create a DVD [18:59] Failed while running mytharchivehelper to get stream [19:26] Is it possible to force mirobridge to run? Where would that command be located [19:44] I found it deeply nested in the docs folder for mythtv. So it's working now. [21:48] Hi, I have just upgraded my mythtv backend server to ubuntu server 10.04 using a fresh install. I now have stutter problems which I'm 99% sure are related to the backend since they happen at the exact same time during Live TV or as a playback as well as synchronous on multiple frontends. [21:49] dae_: sounds like a tuner issue [21:49] bad signal, or something [21:49] I see glitches when my firewire or stb act up [21:50] rhpot1991, well video is received from a old bttv card (bt848) and there are no issues when receiving that using mplayer. [21:51] The really strange thing is that is I increase the loglevel of the backend to "all" the stuttering becomes significantly worse (more pauses then video actually). [21:52] The backend process has a dedicated disk for the recordings, not the same disk as the logfiles. [21:53] The backend process is sitting around 30-35% CPU when watching live TV, the CPU utilization does not depend on the log level (as expected). [21:55] dae_: it would prob be helpful to paste some logs [21:55] !logs [21:55] MythTV logs are stored in /var/log/mythtv/ You can use mythbuntu-log-grabber from the Applications menu to automatically post the most relevant logs to our pastebin. [21:55] rhpot1991, from loglevel "all" ? [23:21] Hi, trying to use mythnetvision in mythbuntu, on the wiki it says it has support for bbc iplayer, but I don't have that as an option under "Manage Site Subscriptions" [23:21] I have a few others, such as youtube and vimeo, I'd say about half of the stuff it supports is missing [23:29] ah, 0.24 only [23:30] must be time for an upgrade ;)