[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