[mythtv-users] mythconverg_restore.pl duplicate entry error

[Michael T. Dean]

On 06/03/2010 06:14 PM, Bill Meek wrote:
> On Thu, 2010-06-03 at 22:50 +0100, Keith Edmunds wrote:
>    
>> On Thu, 3 Jun 2010 17:45:04 -0400, adeffs said:
>>      
>>> I imagine I can use sed to remove a specific line
>>>        
>> $ sed --in-place=.bak -e "245d" dumpfile
>>
>> ....will delete line 245 from dumpfile preserving the original in
>> dumpfile.bak
>>      
> “Danger, Will Robinson!”
>
> Remember that one line of backup data can contain /all/ the records
> in one table.  The previously mentioned grep will show the format
> of the table of interest.
>    

Right, specifically, a mysqldump backup contains lines of up to 1MiB of 
characters (so, however many records will fit into a MiB of SQL for the 
given table).

Mike