[mythtv-users] Database error during mysqldump. "Incorrect file format 'jobqueue' when using Lock Tables" "Incorrect file format 'j'

Michael T. Dean mtdean at thirdcontact.com
Wed Jan 21 02:49:05 UTC 2009


On 01/20/2009 09:16 PM, tommo wrote:
> I'm about to embark on a hardware upgrade on my backend and am trying to
> perform a database backup. I'm running mythtv 0.21-200 on fedora 8, sql
> version 5.0.45-6.
>
> I'm getting the following error:
>
> mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup_20090121.sql
> mysqldump: Got error: 130: Incorrect file format 'jobqueue' when using
> LOCK TABLES

Don't use -c.  Or, try: 
http://www.mythtv.org/wiki/Database_Backup_and_Restore

Don't know what's messed up in your current DB config, but that might 
get around it (at least for now).

Mike


More information about the mythtv-users mailing list