[mythtv-users] no seek table after upgrade to 0.27

[Michael T. Dean]

On 08/21/2013 02:08 AM, Michael Watson wrote:
> On 21/08/2013 3:53 PM, Mark Perkins wrote:
>> //snip//  it appears that the seek table on existing recordings are 
>> wiped.
>> //snip//
>>
>> //snip//
>> Table './mythconverg/recordedseek' is marked as crashed and last
>> (automatic?) repair failed
>>
>> 2013-08-21 14:27:55.483170 E  DB Error (delta position map insert):
>> Query was:
>> INSERT INTO recordedseek (chanid, starttime, mark, type, offset)  
>> VALUES (
>> :CHANID , :STARTTIME , :MARK , :TYPE , :OFFSET ) Bindings were:
>> :CHANID=1022, :MARK=48996, :OFFSET=1959840, 
>> :STARTTIME=2013-08-20T22:25:00Z,
>> :TYPE=33
>> Driver error was [2/1064]:
>> QMYSQL: Unable to execute query
>> Database error was:
>> You have an error in your SQL syntax; check the manual that 
>> corresponds to
>> your MySQL server version for the right syntax to use near ':CHANID ,
>> :STARTTIME , :MARK , :TYPE , :OFFSET )' at line 1
>> //snip//
>>
>> RESOLVED (I think)
>> Ran the following command which appears to have resolved the missing 
>> seek
>> entries.
>>      mysqlcheck --auto-repair -A -u mythtv -pmysqlpassword
>>
>> Mark.
>>
> I think the preferred command is "optimize_mythdb.pl".
> (On a ubuntu system, it is located in 
> "/usr/share/doc/mythtv-backend/contrib/maintenance/"

You can use either mysqlcheck /if/ you get all the right command-line 
arguments, or--much more easily--just run optimize_mythdb.pl (or the 
repair in MythWeb or the backend) and you don't have to worry about 
learning all of mysqlcheck's crazy command-line arguments.  So, 
optimize_mythdb.pl is much easier.

Mike