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

Joseph Flack jflackmd at hotmail.com
Mon Dec 17 21:47:56 UTC 2012


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 ~]$  		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121217/50183d32/attachment.html>


More information about the mythtv-users mailing list