[mythtv-users] Need database upgrade help
gravityhammer at gmail.com
Sun Dec 13 20:31:16 UTC 2009
On Sun, Dec 13, 2009 at 3:23 PM, Phil Bridges <gravityhammer at gmail.com> wrote:
> On Sun, Dec 13, 2009 at 2:20 PM, Phil Bridges <gravityhammer at gmail.com> wrote:
>> Hello, all.
>> I'm in the weekend-long process of upgrading my two backends and four
>> frontends (all on Gentoo). I backed up my database following the
>> directions: http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding
>> After getting the backend updated to .22, I started to restore my
>> database, but it didn't work.
>> I managed to get my "to-uncorrupt" database loaded, but it gives
>> faulty information. It doesn't show recordings I've made in a *long*
>> Here's my current mysql config (after I've updated to .22):
>> mysql Ver 14.12 Distrib 5.0.84, for pc-linux-gnu (x86_64) using readline 6.0
>> Connection id: 106
>> Current database: mythconverg
>> Current user: mythtv at localhost
>> SSL: Not in use
>> Current pager: stdout
>> Using outfile: ''
>> Using delimiter: ;
>> Server version: 5.0.84 Gentoo Linux mysql-5.0.84-r1
>> Protocol version: 10
>> Connection: Localhost via UNIX socket
>> Server characterset: utf8
>> Db characterset: latin1
>> Client characterset: utf8
>> Conn. characterset: utf8
>> UNIX socket: /var/run/mysqld/mysqld.sock
>> Uptime: 1 hour 44 min 24 sec
>> How can I use my mythconverg-to_uncorrupt.sql that I made on the wiki
>> page. How can I get my information dumped back into my database in a
>> form it can use?
> Well, I've looked at every .sql file I have on my system, and it
> appears that something screwy happened on my backup. The only data I
> have in my backup is from March of this year forward. Looks like I'm
> going to just delete all 4GB of recordings and start from scratch.
> Very irritating.
> Let this serve as a warning to everybody to confirm your backup is
> correct after you use a backup script.
Make that 4TB of recordings, not 4GB. I wouldn't worry about just a
couple of hours of high-def.
More information about the mythtv-users