[mythtv-users] reverting database schema

Nick Morrott knowledgejunkie at gmail.com
Mon Nov 2 20:10:54 UTC 2009

2009/11/2 Richard Morton <richard.e.morton at gmail.com>:
> 2009/11/2 Mike McMullin <mwmcmlln at mnsi.net>
>> I've managed to upgrade my back end database to a schema that even it
>> does not handle (most likely do a prompt when doing an up grade to 9.10
>> of ubuntu on a remote system).  Is there a simple way of reverting to
>> the old database schema or should I trash it and redo it all by hand?
> Hi Mike,
> I take it you haven't got a backup? there is a script to complete sql
> backups that many people run daily on their backend to prevent such a
> thing... worth knowing for the future - its in the contrib folder, but you
> can easily do it from mysql itself or phpmyadmin

If it's a recent version of MythTV, the schema upgrade process creates
a pre-upgrade backup of the database (default location is in your
recordings directory).


Nick Morrott

MythTV Official wiki:
MythTV users list archive:

"An investment in knowledge always pays the best interest." - Benjamin Franklin

More information about the mythtv-users mailing list