[mythtv-users] searching previously recorded stuff

[Clay]

--- On Mon, 11/3/08, Brad DerManouelian <myth at dermanouelian.com> wrote:

> From: Brad DerManouelian <myth at dermanouelian.com>
> Subject: Re: [mythtv-users] searching previously recorded stuff
> To: "Discussion about mythtv" <mythtv-users at mythtv.org>
> Date: Monday, November 3, 2008, 4:44 PM
> On Nov 3, 2008, at 2:41 PM, Clay wrote:
> 
> > --- On Mon, 11/3/08, Brad DerManouelian
> <myth at dermanouelian.com>  
> > wrote:
> >>
> >> It's dangerously easy to screw up your
> data/database
> >> with phpmyadmin.
> >
> > I've been using it (carefully, but not shyly) for
> everything from  
> > removing orphans, stuck transcode, commflag jobs,
> etc., to changing  
> > tuner card numbers, adding channels, lineups,
> avi's and mpg's to  
> > recorded... for over two years, and now you tell me
> it's dangerous?
> > Wish I'd heard this long ago...
> > Had I been doing these things via the command line, I
> can guarantee  
> > I would have broken it dozens of times.
> > Haven't had to resort to a backup yet, (you do
> make backups?) using  
> > phpmyadmin.
> 
> I'm glad you've been using it carefully. I'm
> sure no one recklessly  
> changes the data in their database but mistakes are easy to
> make when  
> there is no data validation. As an example, not long ago
> someone was  
> complaining that their data was corrupt because they were
> "fixing"  
> unsupported characters in the database by pasting in new
> ones with  
> phpmyadmin.
> 
> You could easily render your enter mythtv system broken by
> changing  
> the data in a single row in your database in the wrong way.

Agreed. And thanks for taking my post in the spirit it was intended... slightly tongue in cheek, and not a flame.
Apparently, phpmyadmin does some validation though. Occasionally a change gets failed and phpmyadmin shows what I did wrong.
I've never figured out how to get my (oh, what the heck do you call those cards? The ones that capture the stream direct to the hard drive?) AVER A180 and Kworld ATSC115 to grab a lineup so I have them scan all channels, then manually remove hundreds of empty carriers and manually edit the remaining channel numbers and callsigns. Tedious work using phpmyadmin. A thousand times more so using MythTV's interface. Impossible (for me) using the command line.