[mythtv-users] searching previously recorded stuff

Brad DerManouelian myth at dermanouelian.com
Mon Nov 3 22:44:48 UTC 2008


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.


More information about the mythtv-users mailing list