Package: file Version: 1:5.19-1 Severity: wishlist The /etc/magic attached to this bug report has better matches for MySQL database files which provide all the information I could find. The matches for old versions of MySQL files are based on data from mysql.com and the matches for current versions are based on mysql.com data verified by tests against databases I run.
In the section for the MyISAM index file I have two commented lines which are based on data from mysql.com but don't provide intelligible results when I run it against my own databases. I think it might be worth including them as comments to help the next person who works in this area, that data would be REALLY useful in detecting crashed databases if I could make sense of it. -- System Information: Debian Release: jessie/sid APT prefers unstable APT policy: (500, 'unstable'), (1, 'experimental') Architecture: amd64 (x86_64) Kernel: Linux 3.14-1-amd64 (SMP w/4 CPU cores) Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages libmagic1 depends on: ii libc6 2.19-1 ii multiarch-support 2.19-1 ii zlib1g 1:1.2.8.dfsg-1 libmagic1 recommends no packages. Versions of packages libmagic1 suggests: ii file 1:5.19-1 Versions of packages file depends on: ii libc6 2.19-1 ii zlib1g 1:1.2.8.dfsg-1 -- Configuration Files: /etc/magic changed: 0 beshort 0xfe01 MySQL table definition file >2 byte x Version %d, >3 byte 0 Type UNKNOWN, >3 byte 1 Type DIAM_ISAM, >3 byte 2 Type HASH, >3 byte 3 Type MISAM, >3 byte 4 Type PISAM, >3 byte 5 Type RMS_ISAM, >3 byte 6 Type HEAP, >3 byte 7 Type ISAM, >3 byte 8 Type MRG_ISAM, >3 byte 9 Type MYISAM, >3 byte 10 Type MRG_MYISAM, >3 byte 11 Type BERKELEY_DB, >3 byte 12 Type INNODB, >3 byte 13 Type GEMINI, >3 byte 14 Type NDBCLUSTER, >3 byte 15 Type EXAMPLE_DB, >3 byte 16 Type CSV_DB, >3 byte 17 Type FEDERATED_DB, >3 byte 18 Type BLACKHOLE_DB, >3 byte 19 Type PARTITION_DB, >3 byte 20 Type BINLOG, >3 byte 21 Type SOLID, >3 byte 22 Type PBXT, >3 byte 23 Type TABLE_FUNCTION, >3 byte 24 Type MEMCACHE, >3 byte 25 Type FALCON, >3 byte 26 Type MARIA, >3 byte 27 Type PERFORMANCE_SCHEMA, >3 byte 127 Type DEFAULT, >0x0033 ulong x MySQL version %d. 0 belong&0xffffff00 0xfefe0700 MySQL MyISAM index file >3 byte x Version %d, >14 beshort x %d key parts, >16 beshort x %d unique key parts, >18 byte x %d keys, >28 bequad x %lld records, >36 bequad x %lld deleted records 0 string \376bin MySQL replication log, >9 long x server id %d, >8 byte 1 >>13 long 69 MySQL V3.2.3, >>>19 string x server version %s >>13 long 75 MySQL V4.0.2-V4.1, >>>25 string x server version %s >8 byte 15 MySQL V5+, >>25 string x server version %s -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org