Re: inserting a wide table into a narrower table
(Off the top of my head on the phone) "ALTER TABLE DROP COLUMN..."? On Nov 3, 2012 5:24 AM, "Erez D" 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
Re: Crossover give away
> On Wednesday 31 October 2012 08:55:17 Ori Idan wrote: > Have you noticed the following: http://www.codeweavers.com/about/general/press/20121029/ Yes. > Did someone try it? > Yes. I was a happy customer of Crossover for years, until I forgot to renew my subscription this summer. ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
inserting a wide table into a narrower table
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
Re: hacking the government, the British way
On Fri, Nov 2, 2012 at 12:21 PM, Oleg Goldshmidt wrote: > > Hi, > > We have elections on the horizon and a bunch of NGO members, from > Hamakor down, up, and sideways, on this list. And we often see - and > complained about - cluelessness in government IT, software, websites, > etc. > > So, it looks like the UK government is trying to do something that > sounds on the face of it, vaguely intelligent about IT projects, cf. > > http://www.theregister.co.uk/2012/11/02/cabinet_office_open_principles/ > > I am not trying to say this is going to be brilliant or workable or > not prone to subversion by "Sir Humphreys"[*], but given how gov.il is > always keen to look abroad to justify doing or not doing stuff, maybe > someone should point it out to some politicians looking for votes in > January? > > If ths generates any heated or prolonged discussions may I suggest > conducting them on the appropriate NGO lists and forums? I am not a > member of any, so it was easier for me to post here in the belief that > it is on topic. How to best influence the politicians, however, > probably isn't, unless someone hacks up a Linux-based AI to run the > country. > > [*] Some of the younger list members may need, e.g., > http://en.wikipedia.org/wiki/Yes_Minister to understand who "Sir > Humphrey" was. The rest of us may well be reminded that the > fictional Minister whose efforts to reform things were so often > thwarted by Sir Humphrey was called Jim Hacker. > > -- > Oleg Goldshmidt | p...@goldshmidt.org > > The people behind gov.il think that .doc is an open standard since after all it can be opened by every computer they know of. -- Ori Idan ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
hacking the government, the British way
Hi, We have elections on the horizon and a bunch of NGO members, from Hamakor down, up, and sideways, on this list. And we often see - and complained about - cluelessness in government IT, software, websites, etc. So, it looks like the UK government is trying to do something that sounds on the face of it, vaguely intelligent about IT projects, cf. http://www.theregister.co.uk/2012/11/02/cabinet_office_open_principles/ I am not trying to say this is going to be brilliant or workable or not prone to subversion by "Sir Humphreys"[*], but given how gov.il is always keen to look abroad to justify doing or not doing stuff, maybe someone should point it out to some politicians looking for votes in January? If ths generates any heated or prolonged discussions may I suggest conducting them on the appropriate NGO lists and forums? I am not a member of any, so it was easier for me to post here in the belief that it is on topic. How to best influence the politicians, however, probably isn't, unless someone hacks up a Linux-based AI to run the country. [*] Some of the younger list members may need, e.g., http://en.wikipedia.org/wiki/Yes_Minister to understand who "Sir Humphrey" was. The rest of us may well be reminded that the fictional Minister whose efforts to reform things were so often thwarted by Sir Humphrey was called Jim Hacker. -- Oleg Goldshmidt | p...@goldshmidt.org ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: monitor hours
On Thu, Nov 1, 2012 at 1:40 PM, Oleg Goldshmidt wrote: > > > On Thu, Nov 1, 2012 at 1:15 PM, Nadav Har'El wrote: > >> On Thu, Nov 01, 2012, Erez D wrote about "monitor hours": >> >> > maybe let the screensaver log when it started and when it ends, so i >> have a >> > rough estimate of the hours i was working on the computer >> >> I'm sure there's a way to do this, but how to do it obviously depends on >> your environment/screensaver. >> > > On top of that, one needs to ask what time should be tracked. If one is in > a meeting, discussing things with a colleague, or - G-d forbid - thinking > about a problem for a prolonged time, a screensaver is bound to kick in... > agreed, but there is nothing i can do about that, i can not log my thoughts, or lightbulb-on-time in the meeting room (unless it is computer contrtolled but, my meetings usually appear on my calendar ... i just need to know when i started and ended my work on the computer each day. > > -- > Oleg Goldshmidt | p...@goldshmidt.org > ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il
Re: monitor hours
On Thu, Nov 1, 2012 at 1:15 PM, Nadav Har'El wrote: > On Thu, Nov 01, 2012, Erez D wrote about "monitor hours": > > i am looking for a way to monitor the activity on my computer (i usually > > use it via vnc) > > I'm not sure how you use VNC - if you close VNC when you stop working, > you can look at the VNC server log on the remote machine. Assuming it's > Linux (it's linux-il after all ;-)), look at $HOME/.vnc/*.log. You'll > see entries like: > > Mon Oct 29 16:56:23 2012 > Connections: accepted: 1.2.3.4::2169 > > ... > > Mon Oct 29 18:19:09 2012 > Connections: closed: 1.2.3.4::2169 (Clean disconnection) > > > maybe let the screensaver log when it started and when it ends, so i > have a > > rough estimate of the hours i was working on the computer > > I'm sure there's a way to do this, but how to do it obviously depends on > your environment/screensaver. > > Two other options you can consider: > > 1. If you use a shell, tell it to keep history with timestamps (see your >shell's manual page on how to use it), then you can know when you ran >which command. > > 2. Turn on process accounting (a quick Google search turned up these >instructions: > > http://www.cyberciti.biz/tips/howto-log-user-activity-using-process-accounting.html >and see what commands were run, when. > > > looks interesting, but what if i have an open vnc connection from last week and open vi/eclipse/emacs and write new code. until i try to compile or do something else, none of the solutions above will work. the only way i see it is to catch kbd/mouse events ... how do i do that globaly for my display ? > -- > Nadav Har'El|Thursday, Nov 1 2012, 16 Heshvan > 5773 > n...@math.technion.ac.il > |- > Phone +972-523-790466, ICQ 13349191 |The space between my ears was > http://nadav.harel.org.il |intentionally left blank. > ___ Linux-il mailing list Linux-il@cs.huji.ac.il http://mailman.cs.huji.ac.il/mailman/listinfo/linux-il