[mythtv-users] mythtconverg_backup.pl fails to backup video and setup info

[Michael T. Dean]

On 12/17/2012 04:47 PM, Joseph Flack wrote:
> I am trying to upgrade my box from version 0.25.2 on a fedora 15 box 
> installed via atrpms.  I want to backup my database.  I get the 
> following output using verbose:
> mysqldump exited with status: 2
> mysqldump output:
> mysqldump: Got error: 130: Incorrect file format 'videocollection' 
> when using LOCK TABLES
> (see below for full output)
> Any thoughts?
> Help is appreciated.
> ----------------------
>
> [mythtvhm at MYTHTVNEW ~]$ /usr/share/mythtv/mythconverg_backup.pl --verbose
>
> Configuring environment:
>   -    username: mythtvhm
>   -        HOME: /home/mythtvhm
>   - MYTHCONFDIR: /home/mythtvhm/.mythtv
>
> Parsing configuration files:
>   - checking: /home/mythtvhm/.mythtv/config.xml
>      parsing: /home/mythtvhm/.mythtv/config.xml
>   - checking: /home/mythtvhm/.mythtv/backuprc
>      parsing: /home/mythtvhm/.mythtv/backuprc
>
> Applying command-line arguments.
>
> Checking configuration.
>
> No DBSchemaVer specified, querying database.
> Found DBSchemaVer: 1299.
>
> Database Information:
>          DBHostName: 192.168.2.30
>              DBPort: 3306
>          DBUserName: mythtv
>          DBPassword: XXX
>              DBName: mythconverg
>         DBSchemaVer: 1299
>   DBBackupDirectory: /storage/backup
>    DBBackupFilename: mythconverg-1299-20121216221844.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/ioixewhCQd' 
> --host='192.168.2.30' --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>'/storage/backup/mythconverg-1299-20121216221844.sql'
>
> mysqldump exited with status: 2
> mysqldump output:
> mysqldump: Got error: 130: Incorrect file format 'videocollection' 
> when using LOCK TABLES
>
> [mythtvhm at MYTHTVNEW ~]$
>

You almost definitely have corrupt (possibly beyond repair) MySQL 
table(s).  Start out with a mysqlcheck and see where that takes you.

Mike