=== 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 | ||
qwebirc17000 | hello? complete irc newbie here | 06:36 |
---|---|---|
qwebirc17000 | I hope I do this right. I've composed a question... I will paste it here and hopefully it will show up right... | 06:38 |
qwebirc17000 | 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:39 |
qwebirc17000 | 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 |
qwebirc17000 | 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 |
qwebirc17000 | 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:40 |
qwebirc17000 | I know I need to bak the 10.04 db first. | 06:41 |
qwebirc17000 | 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:41 |
qwebirc17000 | --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 |
qwebirc17000 | 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. | 06:42 |
qwebirc18870 | !help | 07:38 |
Zinn | !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 |
qwebirc18870 | !status | 07:38 |
Zinn | I am alive. | 07:38 |
qwebirc18870 | ok...looks like I already fouled up... I shoulda used "pastebin" for my largeish question. Sorry. | 07:44 |
qwebirc18870 | 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? | 07:46 |
qwebirc18870 | !help | 08:00 |
Zinn | !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 |
qwebirc18870 | !about | 08:00 |
Zinn | 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:00 |
qwebirc18870 | !bug | 08:01 |
=== _Metoer is now known as Metoer | ||
qwebirc4833 | I am getting the following error trying to create a DVD | 18:59 |
qwebirc4833 | Failed while running mytharchivehelper to get stream | 18:59 |
achew22 | Is it possible to force mirobridge to run? Where would that command be located | 19:26 |
achew22 | I found it deeply nested in the docs folder for mythtv. So it's working now. | 19:44 |
dae_ | 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:48 |
rhpot1991 | dae_: sounds like a tuner issue | 21:49 |
rhpot1991 | bad signal, or something | 21:49 |
rhpot1991 | I see glitches when my firewire or stb act up | 21:49 |
dae_ | rhpot1991, well video is received from a old bttv card (bt848) and there are no issues when receiving that using mplayer. | 21:50 |
dae_ | 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:51 |
dae_ | The backend process has a dedicated disk for the recordings, not the same disk as the logfiles. | 21:52 |
dae_ | 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:53 |
rhpot1991 | dae_: it would prob be helpful to paste some logs | 21:55 |
rhpot1991 | !logs | 21:55 |
Zinn | 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 |
dae_ | rhpot1991, from loglevel "all" ? | 21:55 |
Azelphur | 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 |
Azelphur | I have a few others, such as youtube and vimeo, I'd say about half of the stuff it supports is missing | 23:21 |
Azelphur | ah, 0.24 only | 23:29 |
Azelphur | must be time for an upgrade ;) | 23:30 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!