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

[Mark Boyum]

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