[mythtv-users] Trouble importing old recordings

[Steven Adeff]

On 12/22/06, Chris Clarke <chrisjohn.clarke at gmail.com> wrote:
> Hi All,
>
>     I've got a bunch of old recordings that I backed up to an external
> hard drive.  I used nuvexport with the "extract nuv and sql" option
> (wording is approx I don't have nuvexport installed anymore) The
> recordings have all been transcoded with the commercials cut out.
> I've successfully imported stuff in the past by copying the .nuv file
> into my recordings directory and running the following command
>
> cat *.sql | mysql -u mythtv -p mythconverg
>
> I use the "cat *.sql" to allow me to import a bunch of shows at once.
> But now when I do this it gives me the following error
>
> ERROR 1048 (23000) at line 3: Column 'cutlist' cannot be null
>
>     I'm guessing the 'cutlist' is null because I've transcoded the
> file and cut the commercials, does any one know a way around this?

you can use
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions#Q:_How_do_I_import_recordings_from_other_sources_into_Myth.3F

which ultimately will add the file to the DB but not use the exported SQL.
-- 
Steve
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette