<div dir="ltr"><br><br><div class="gmail_quote">On Sat, Nov 3, 2012 at 10:08 AM, Amos Shapira <span dir="ltr"><<a href="mailto:amos.shapira@gmail.com" target="_blank">amos.shapira@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p>Then load it then alter the table.</p></blockquote><div>actually that was a good idea<br><br>originally i didn't want it as i needed to merge two tables with different widths<br><br>in the end, i created a new database, imported the table, dropped some columns, and exported it again<br>
then appended it to mythtv's db<br><br><br>thanks. <br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">
<div class="gmail_quote">On Nov 3, 2012 7:02 PM, "Erez D" <<a href="mailto:erez0001@gmail.com" target="_blank">erez0001@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><br><br><div class="gmail_quote">On Sat, Nov 3, 2012 at 12:48 AM, Amos Shapira <span dir="ltr"><<a href="mailto:amos.shapira@gmail.com" target="_blank">amos.shapira@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<p>(Off the top of my head on the phone)<br>
"ALTER TABLE DROP COLUMN..."?</p></blockquote><div>i do not have the old table, just the mysqldump file ...<br> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="gmail_quote"><div><div>On Nov 3, 2012 5:24 AM, "Erez D" <<a href="mailto:erez0001@gmail.com" target="_blank">erez0001@gmail.com</a>> wrote:<br type="attribution"></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>
<div dir="ltr">hello,<div><br></div><div>i am downgrading mythtv. to keep my data, i need to import my recording table</div><div>however in the older version the table has less columns</div><div>i have a mysqldump of the wider table and need to insert into older version with narrower table.</div>
<div><br></div><div>i thought about using awk to delete the non relevant fields. however there are man "," inside strings, so splitting fields by "," is not simple</div><div><br></div><div><br></div><div>
any simple idea ? some sql magic ?</div><div><br></div><div>thanks,</div><div>erez.</div></div>
<br></div></div>_______________________________________________<br>
Linux-il mailing list<br>
<a href="mailto:Linux-il@cs.huji.ac.il" target="_blank">Linux-il@cs.huji.ac.il</a><br>
<a href="http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il" target="_blank">http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il</a><br>
<br></blockquote></div>
</blockquote></div><br></div>
</blockquote></div>
</div></div></blockquote></div><br></div>