[mythtv-users] MySQL help w/deleting a row[entry]

R. G. Newbury newbury at mandamus.org
Wed Nov 25 22:08:56 UTC 2009


Bobby Gill wrote:
> Have been googling and found the MySQL reference manual as well as some 
> blogs, but out of sheer fear for accidentally deleting the wrong 
> thing(s) (if not my entire database lol, though I do have it backed up 
> nightly), just wondering how I can remove this entry:
> 
> mysql> select * from recorded where starttime IS NULL;
> +--------+---------------------+---------------------+---------------------------------+---------------------------------+-----------------------------------------+----------+----------+----------+---------+---------+------------+-------------+----------------------------------+----------+----------+-----------+---------------------+----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+--------------------------------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
> | chanid | starttime           | endtime             | 
> title                           | subtitle                        | 
> description                             | category | hostname | bookmark 
> | editing | cutlist | autoexpire | commflagged | 
> recgroup                         | recordid | seriesid | programid | 
> lastmodified        | filesize | stars | previouslyshown | 
> originalairdate | preserve | findid | deletepending | transcoder | 
> timestretch | recpriority | 
> basename                                         | progstart           | 
> progend             | playgroup | profile | duplicate | transcoded | 
> watched | storagegroup |
> +--------+---------------------+---------------------+---------------------------------+---------------------------------+-----------------------------------------+----------+----------+----------+---------+---------+------------+-------------+----------------------------------+----------+----------+-----------+---------------------+----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+--------------------------------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
> |   1024 | 0000-00-00 00:00:00 | 1969-12-31 19:00:00 | 
> john.mayer-clarity.vho.sessions |     Title: 'The Colbert Report' | 
> Found a match between file and database |          | mythbox  |        0 
> |       0 |       0 |          0 |           0 |     Title: 'The Daily 
> Show with  |     NULL |          |           | 2009-11-16 19:47:44 
> |        0 |     0 |               0 | NULL            |        0 |      
> 0 |             0 |          0 |           1 |           0 | 
> 1024_File'/media/myth/44_20080905230000.avi'.avi | 0000-00-00 00:00:00 | 
> 1969-12-31 19:00:00 | Default   |         |         0 |          0 
> |       0 | Default      |
> +--------+---------------------+---------------------+---------------------------------+---------------------------------+-----------------------------------------+----------+----------+----------+---------+---------+------------+-------------+----------------------------------+----------+----------+-----------+---------------------+----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+--------------------------------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
> 1 row in set (0.03 sec)
> 
> It's a .avi file that I added to the recordings directory but I kinda 
> fudged up on entering myth.rebuilddatabase.pl 
> <http://myth.rebuilddatabase.pl> info (starttime, chanid, etc.) and I 
> would like to remove it completely anyhow. Everytime I delete from the 
> FE, it shows up again, can't get rid of it...
> 

 From the mysql console, using mythconverg. You can check that you are 
getting only the one record with:

Select * from recorded where description "Found a match between file and 
database";


then use:

delete * from recorded where description "Found a match between file and 
database" limit 1;


Geoff




-- 
         Please let me know if anything I say offends you.
          I may wish to offend you again in the future.

          Tux says: "Be regular. Eat cron flakes."


More information about the mythtv-users mailing list