[mythtv-users] Nuvexport and re-importing

scott urban tsurban at comcast.net
Thu Jun 9 04:27:46 UTC 2005

On Thu, Jun 09, 2005 at 00:16:03, Chris Clarke spake thusly:
> Hi All,
>     Here's my problem, I used nuvexport to export 300ish recordings
> and so I've got 300+ .nuv files and 300+ .sql files.  I understand
> that if I move the .nuv file and then run the command "mysql -u root
> -p mythconverg < XXXX.sql" it will reinsert it into the database, I
> just don't feel like doing it 300+ times :)  Is there some way I can
> either combine the .sql files into 1 giant .sql file with all the info
> or tell mysql to import all the .sql files?  (Excuse the newbie
> question, I couldn't find the answer in the archives....)

I'm no SQL wiz, but this seems like a shell problem:

  sh%> for f in *.sql ; do 
  for> echo $f
  for> mysql -u root -p mythconverg < $f
  for> done

More information about the mythtv-users mailing list