Re: ResultsTable to MySQL

Posted by Michael Doube on Feb 04, 2011; 10:14am
URL: http://imagej.273.s1.nabble.com/ResultsTable-to-MySQL-tp3685832p3685835.html

Hi Jaap

> Thank you very much for your responses. You can download the plugin from:
> http://sourceforge.net/projects/openpheno/files/ImageJ%20Plugins/ij_mysql.zip/download
>
> Let me know if it works. If it doesn't I'll get right on to fixing it!

Sorry it has taken a month to get around to trying this out.  It looks
like it can connect OK to my MySQL server, and I can get data straight
from the Results table into a MySQL table.  Nice!  I will be playing
with this some more...

One thing that would be useful is a configuration guide, especially with
regard to user and schema permissions.  I was slightly surprised to see
the plugin creating a table, rather than INSERTing into an existing one.
 I made a MySQL user called imagej, and I'd like to give it very limited
permissions: what are the minimum permissions needed for this to work?
(CREATE and INSERT?).

Is there a way to make the plugin a bit more compact, or are all the
classes needed? I see that ij_mysql.jar contains jdbc, and so does
mysql-connector-java-5.1.13-bin.jar, so this appears to be a bit redundant.

Otherwise, thanks!

Michael