inserting a wide table into a narrower table

[Erez D]

hello,

i am downgrading mythtv. to keep my data, i need to import my recording
table
however in the older version the table has less columns
i have a mysqldump of the wider table and need to insert into older version
with narrower table.

i thought about using awk to delete the non relevant fields. however there
are man "," inside strings, so splitting fields by "," is not simple


any simple idea ? some sql magic ?

thanks,
erez.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.cs.huji.ac.il/pipermail/linux-il/attachments/20121102/52078cb8/attachment.html>