[mythtv-users] OT: Mysql DB backups don't produce same results?

[Chad]

> I hate to state the obvious, but isn't the 18.3MB difference due to
> the fact that you're compressing the output with the 2nd command?
> 
> --
> Chris
> 
> 


:)

Yes, but the difference are in the actual file, for example, here are
the 'same' lines from the 2 files:

File 1 (the uncompressed):

-- Dumping data for table `capturecard`
--

INSERT INTO capturecard VALUES (1,'/dev/v4l/video0','/dev/dsp','/dev/vbi0','V4L'
,'Television',0,'64bitmyth',0,0,0,1,8192,8192,0,0,NULL,0,2,0,NULL,0,0);


File 2 (bzip2) from the same section:

-- Dumping data for table `capturecard`
--

INSERT INTO capturecard (cardid, videodevice, audiodevice, vbidevice, cardtype, 
defaultinput, audioratelimit, hostname, dvb_swfilter, dvb_recordts, dvb_sat_type
, dvb_wait_for_seqstart, dvb_dmx_buf_size, dvb_pkt_buf_size, skipbtaudio, dvb_on
_demand, dvb_diseqc_type, firewire_port, firewire_node, firewire_speed, firewire
_model, firewire_connection, dvb_hw_decoder) VALUES (1,'/dev/v4l/video0','/dev/d
sp','/dev/vbi0','V4L','Television',0,'64bitmyth',0,0,0,1,8192,8192,0,0,NULL,0,2,
0,NULL,0,0);

:)

Hopefully that describes it a bit better.

Thanks for the reply!  And the obvious is sometimes the thing that is
hardest to see, so I really don't mind.

Cool