[mythtv] where to configure datadirect?

Bruce Markey bjm at lvcm.com
Thu May 6 16:11:25 EDT 2004


bobnvic at everestkc.net wrote:
> Bruce Markey wrote:
> 
>>Robert, I've since found that "TRUNCATE TABLE videosource;" will
>>delete and reset the auto_increment without having to manually
>>drop and re-create the table. 
> 
> 
>>http://dev.mysql.com/doc/mysql/en/TRUNCATE.html
>>
> 
> 
> Do you suppose this would work for resetting the auto_increment
> on cardid from the capturecard table?

Uh-huh. But if you do, make sure to also clear your cardinput
table at the same time because it refers to the cardids. 

--  bjm


More information about the mythtv-dev mailing list