[mythtv-users] Database backup failing

[Bob Sully]

Hi all -

I have been having issues with Mysql since the latest update.  First, 
the update itself failed and I had to ask Dr. Google how to MacGyver a 
fix for that (yes, it worked, got it installed).  However, since then I 
have not been able to get mythconverg_backup.pl to work.  If fails as 
follows:

rcs at vader: ~]$ /usr/share/mythtv/mythconverg_backup.pl -verbose

Configuring environment:
   -    username: rcs
   -        HOME: /home/rcs
   - MYTHCONFDIR: /home/rcs/.mythtv

Parsing configuration files:
   - checking: /home/rcs/.mythtv/config.xml
      parsing: /home/rcs/.mythtv/config.xml
   - checking: /home/rcs/.mythtv/backuprc
      parsing: /home/rcs/.mythtv/backuprc

Applying command-line arguments.

Checking configuration.

No DBSchemaVer specified, querying database.
Found DBSchemaVer: 1344.

Database Information:
          DBHostName: 192.168.1.9
              DBPort: 3306
          DBUserName: mythtv
          DBPassword: XXX
              DBName: mythconverg
         DBSchemaVer: 1344
   DBBackupDirectory: /misc/dbbackup
    DBBackupFilename: mythconverg-1344-20180711231352.sql

Executables:
           mysqldump: mysqldump
            compress: gzip

Attempting to use supplied password for mysqldump.
Any [client] or [mysqldump] password specified in the MySQL options file 
will
take precedence.

Executing command:
'/usr/bin/mysqldump' --defaults-extra-file='/tmp/aVusmdWS2l' 
--host='192.168.1.9' --port='3306' --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>'/misc/dbbackup/mythconverg-1344-20180711231352.sql'

mysqldump exited with status: 2
mysqldump output:
mysqldump: Got error: 1812: Tablespace is missing for table 
`mythconverg`.`music_albumart`. when using LOCK TABLES



Running 0.28.x-fixes (via mythbuntu repo) on Ubuntu 16.04 LTS, all 
currently updated.

I'm not even using mythmusic (not a fan of the interface...I use vlc or 
Rhythmbox to play music files on this machine).

Is there an easy way to fix this?  I am by no means a Mysql guru.  
Thanks in advance!  I definitely am not happy with not like not having a 
current DB backup (though I back up the whole system every couple of 
weeks).

-- 
Regards,
Bob