[mythtv-users] Fw: Re: major db problem upgrading from 0.21-fixes to 0.22

[Michael T. Dean]

On 03/07/2010 05:56 AM, Audio Phile wrote:
> BTW, I just restored a total machine image of my fully functional 0.21-fixes machine (entire root partition) and I get the following when I check the db as described on the wiki.  Could the corruption happen when it tries to upgrade the schema or...?
>
> mysql -umythtv -p mythconverg -e 'status;'
> Enter password:
> --------------
> mysql  Ver 14.12 Distrib 5.0.75, for pc-linux-gnu (i686) using readline 5.2
>
> Connection id:		233
> Current database:	mythconverg
> Current user:		mythtv at localhost
> SSL:			Not in use
> Current pager:		stdout
> Using outfile:		''
> Using delimiter:	;
> Server version:		5.0.75 Source distribution
> Protocol version:	10
> Connection:		Localhost via UNIX socket
> Server characterset:	latin1
> Db     characterset:	latin1
> Client characterset:	latin1
> Conn.  characterset:	latin1
> UNIX socket:		/tmp/mysql.sock
> Uptime:			21 min 52 sec
>
> Threads: 6  Questions: 342129  Slow queries: 0  Opens: 1261  Flush tables: 1  Open tables: 64  Queries per second avg: 260.769
> --------------
>    

That's not the problem.  See my last response to you in the original 
thread (without the Fw:).

Mike