[mythtv-users] mythconverg_backup.pl choking on mythweather tables

Mark Boyum mark at boyum.us
Fri Oct 7 18:33:35 UTC 2011


I would like to backup my database but find that the script dies as
below.  I know next to nothing about mySQL and would appreciate any
assistance.

How do I remove any trace of mythweatther as we no longer use it?  I'd
like to clean it out of the database entirely and assume that would
allow the backup script to run.


./mythconverg_backup.pl --verbose
<--- SNIP --->
Executing command:
'/usr/bin/mysqldump' --defaults-extra-file='/tmp/b1lBxr5u54'
--host='localhost' --user='mythtv' --add-drop-table --add-locks
--allow-keywords --complete-insert --extended-insert --lock-tables
--no-create-db --quick --add-drop-table 'mythconverg' 2>&1
1>'/home/mark/mythtv_backup/mythconverg-1264-20111007131620.sql'

mysqldump exited with status: 2
mysqldump output:
mysqldump: Got error: 1146: Table
'mythconverg.mythconverg.weatherscreens' doesn't exist when using LOCK
TABLES


show tables
+--------------------------------+
| Tables_in_mythconverg          |
+--------------------------------+
| archiveitems                   |
| callsignnetworkmap             |
| capturecard                    |
| cardinput                      |
| channel                        |
| channelgroup                   |
| channelgroupnames              |
| channelscan                    |
| channelscan_channel            |
| channelscan_dtv_multiplex      |
| codecparams                    |
| credits                        |
| customexample                  |
| diseqc_config                  |
| diseqc_tree                    |
| displayprofilegroups           |
| displayprofiles                |
| dtv_multiplex                  |
| dtv_privatetypes               |
| dvdbookmark                    |
| dvdinput                       |
| dvdtranscode                   |
| eit_cache                      |
| filemarkup                     |
| gallerymetadata                |
| gamemetadata                   |
| gameplayers                    |
| housekeeping                   |
| inputgroup                     |
| internetcontent                |
| internetcontentarticles        |
| inuseprograms                  |
| jobqueue                       |
| jumppoints                     |
| keybindings                    |
| keyword                        |
| movies_movies                  |
| movies_showtimes               |
| movies_theaters                |
| music_albumart                 |
| music_albums                   |
| music_artists                  |
| music_directories              |
| music_genres                   |
| music_playlists                |
| music_smartplaylist_categories |
| music_smartplaylist_items      |
| music_smartplaylists           |
| music_songs                    |
| music_stats                    |
| mythconverg.weatherscreens     |
| mythexport                     |
| mythexport_job_queue           |
| mythlog                        |
| mythnettv_archive              |
| mythnettv_category             |
| mythnettv_group                |
| mythnettv_log                  |
| mythnettv_programs             |
| mythnettv_proxies              |
| mythnettv_proxy_usage          |
| mythnettv_settings             |
| mythnettv_subscriptions        |
| mythweb_sessions               |
| netflix                        |
| netvisionrssitems              |
| netvisionsearchgrabbers        |
| netvisionsites                 |
| netvisiontreegrabbers          |
| netvisiontreeitems             |
| networkiconmap                 |
| newssites                      |
| oldfind                        |
| oldflix                        |
| oldprogram                     |
| oldrecorded                    |
| people                         |
| pidcache                       |
| playgroup                      |
| powerpriority                  |
| profilegroups                  |
| program                        |
| programgenres                  |
| programrating                  |
| recgrouppassword               |
| record                         |
| record_tmp                     |
| recorded                       |
| recordedcredits                |
| recordedfile                   |
| recordedmarkup                 |
| recordedprogram                |
| recordedrating                 |
| recordedseek                   |
| recordingprofiles              |
| recordmatch                    |
| romdb                          |
| schemalock                     |
| settings                       |
| storagegroup                   |
| tvchain                        |
| tvosdmenu                      |
| upnpmedia                      |
| videocast                      |
| videocategory                  |
| videocountry                   |
| videogenre                     |
| videometadata                  |
| videometadatacast              |
| videometadatacountry           |
| videometadatagenre             |
| videosource                    |
| videotypes                     |
| weatherdatalayout              |
| weatherscreens                 |
| weathersourcesettings          |
| websites                       |
+--------------------------------+

-Mark


More information about the mythtv-users mailing list