Re: ssh basics

2015-03-10 Thread Johan De Meersman
- Original Message - > From: "Lucio Chiappetti" > > I may like a way to have a program (namely RSI IDL) to connect (bypassing > the line mode mysql client) to the mysqld socket and issuing commands to > it (essentially I want to issue a select into a table, and read back the > output in a

Re: ssh basics

2015-03-10 Thread Reindl Harald
Am 10.03.2015 um 19:06 schrieb Lucio Chiappetti: I guess all this very simple arrangements should cover the needs of the OP as they do for me. but that won't help as long the OP fires up blindly ssh-tunnel commands without understanding what a SSH tunnel and a TCP connection is and *that* i

Re: ssh basics

2015-03-10 Thread Lucio Chiappetti
On Mon, 9 Mar 2015, Johan De Meersman wrote: I'm interested in how ssh is used by MySQL. SSH is not used by MySQL at all :-) SSH is a way of connecting to a remote machine. MySQL is a database. You can use SSH to do things with the database, but they're not intrinsically related. True, how

MySQL Community Server 5.7.6 has been released (part 3/3)

2015-03-10 Thread Bjorn Munch
[This is part 3 (last) of the announcement ] * Partitioning: When multiple columns are used in KEY partitioning, their order may help determine the partition in which the row is placed. Changing this order by means of an ALTER TABLE that uses ALGORITHM=INPLACE can

MySQL Community Server 5.7.6 has been released (part 2/3)

2015-03-10 Thread Bjorn Munch
[This is part 2 of the announcement ] * The minimum value of the stored_program_cache system variable has been changed from 256 to 16, to enable configuration of a smaller amount of memory devoted to the stored program cache. (Bug #72451, Bug #18661573) * The code i

Re: Create Schema and repeatable import of XML

2015-03-10 Thread Iñigo Medina
You can have a look at XMLPipeDB. http://sourceforge.net/projects/xmlpipedb/ Iñigo On 03/09, Sayth Renshaw wrote: > Hi > > Hoping someone can help me work some information or direction to a good > resourc