On Sat, Nov 3, 2012 at 12:48 AM, Amos Shapira <amos.shap...@gmail.com>wrote:
> (Off the top of my head on the phone) > "ALTER TABLE DROP COLUMN..."? > i do not have the old table, just the mysqldump file ... > On Nov 3, 2012 5:24 AM, "Erez D" <erez0...@gmail.com> wrote: > >> 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. >> >> _______________________________________________ >> Linux-il mailing list >> Linux-il@cs.huji.ac.il >> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il >> >>
_______________________________________________ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
