Then load it then alter the table. On Nov 3, 2012 7:02 PM, "Erez D" <[email protected]> wrote:
> > > On Sat, Nov 3, 2012 at 12:48 AM, Amos Shapira <[email protected]>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" <[email protected]> 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 >>> [email protected] >>> http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il >>> >>> >
_______________________________________________ Linux-il mailing list [email protected] http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
