[mythtv-users] mythfilldatabase fails on mariadb

Michael T. Dean mtdean at thirdcontact.com
Tue Nov 25 14:32:49 UTC 2014


On 11/25/2014 09:24 AM, Michael T. Dean wrote:
> You could convert them or--since your schema definition is corrupt (at 
> minimum, it's using InnoDB engine, but may have other unidentified 
> corruption)

Oh, I should have said I'm assuming that your MythTV database is using 
InnoDB tables since you said that the server only crashes when MythTV is 
using it and since it's the InnoDB engine that's crashing the server.  
You should check to ensure your MythTV database is using InnoDB storage 
before doing a partial restore.

You can do something like:

SELECT TABLE_NAME, ENGINE
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'mythconverg';

to find out for sure.  Only the weather* tables should be InnoDB.

Mike


More information about the mythtv-users mailing list