[mythtv-users] Trouble importing old recordings
adeffs.mythtv at gmail.com
Tue Jan 2 15:55:58 UTC 2007
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
which ultimately will add the file to the DB but not use the exported SQL.
Before you ask, read the FAQ!
then search the Wiki, and this list,
Mailinglist etiquette -
More information about the mythtv-users