[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