On Sat, Nov 3, 2012 at 10:08 AM, Amos Shapira <[email protected]>wrote:
> Then load it then alter the table. > actually that was a good idea originally i didn't want it as i needed to merge two tables with different widths in the end, i created a new database, imported the table, dropped some columns, and exported it again then appended it to mythtv's db thanks. > 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
