Re: forum vs email

2014-12-12 Thread Lucio Chiappetti
True; and before that there was yahoo groups, and others. Those are not fora, however, merely web interfaces to mailing lists / newsgroups. as a lurker on this list, I jump in. It is curious that newsgroups are mentioned only en passant, and NNTP is not mentioned at all. Still vastly prefer

Re: command is not allowed with this MySQL version

2014-12-12 Thread Johan De Meersman
- Original Message - From: yoku ts. yoku0...@gmail.com Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new version. It'd be fun to know what the OLD version was,

Re: Xml data import

2014-12-12 Thread Johan De Meersman
- Original Message - From: Sayth Renshaw flebber.c...@gmail.com Subject: Xml data import I have an xml data feed with xsd, it's complex in elements not size. Wray are the best way to get data into mysql, do I have to hack with xquery? That's going to depend on the complexity of

Re: Re: signal handling in mysql cli

2014-12-12 Thread rafal somla
Hello Sebastein, On 2014-12-03 17:25, Sebastien FLAESCH wrote: Hi all, I have a similar question regarding KILL QUERY usage: We have a C client program using libmysqlclient.so, it is a single-threaded program. When running a long query, how can I send the KILL QUERY command when a SIGINT

[Solved] Re: command is not allowed with this MySQL version

2014-12-12 Thread Christophe
Hi, Le 12/12/2014 11:51, Johan De Meersman a écrit : - Original Message - From: yoku ts. yoku0...@gmail.com Subject: Re: command is not allowed with this MySQL version Christophe has already told, The used MySQL version is 5.5.40 from Debian Wheezy package. No, that's the new

Re: signal handling in mysql cli

2014-12-12 Thread Sebastien FLAESCH
Thank you Rafal for your answer! We do not use threads, it's a single threaded program. So we cannot set a flag to exec the KILL QUERY later on in another thread. The only flag I use is to avoid subsequent KILL QUERY attempts when one has already been sent... The code in the sigint handler is

Re: How to retrieve next record?

2014-12-12 Thread Trianon 33
Thanks Martin, But loading ALL the records sums up to (now) 10 mio records and further on in future up to 100 mio records. H, don't think that's wise. Nevertheless, thanks for thinking alog. BR, Hans. Martin Gainty schreef op 11-12-14 om 23:33: If you *dont* mind implementing your

Re: How to retrieve next record?

2014-12-12 Thread Trianon 33
Thanks Johan, You're partly right in your interpretation, but not in total :-) Later on in time I'll lift a tip. I need some time to process your answer and do my homework. Nevertheless I've got already something that works, but maybe isn't the most efficient. Nevertheless a good start,

Re: command is not allowed with this MySQL version

2014-12-12 Thread hsv
2014/12/12 02:10 +0100, Christophe When the app tries to do this, it raises an error : 'The used command is not allowed with this MySQL version' The used MySQL version is 5.5.40 from Debian Wheezy package. I found that some parameters or variables (local_infile for instance) can be used to

Function

2014-12-12 Thread Alexander Syvak
Hello! How is actually a function done internally in MySQL after CREATE FUNCTION statement? Why can't there be a dynamic SQL inside a function?

Re: Xml data import

2014-12-12 Thread Sayth Renshaw
So it is definitely achievable, I see other db's converting xml2json etc to get it in. Sends odd that xml had done great document qualities but as a data format it seems rather hard to work with. Sayth On Fri, 12 Dec 2014 9:55 PM Johan De Meersman vegiv...@tuxera.be wrote: - Original

Re: Xml data import

2014-12-12 Thread Larry Martell
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com wrote: So it is definitely achievable, I see other db's converting xml2json etc to get it in. I use this https://github.com/hay/xml2json Sends odd that xml had done great document qualities but as a data format it seems

Re: Xml data import

2014-12-12 Thread Sayth Renshaw
And does that then lead you to use Fabric? http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding Sayth On Sat, 13 Dec 2014 9:06 AM Larry Martell larry.mart...@gmail.com wrote: On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw flebber.c...@gmail.com wrote: So