5 Jul 2012
I am trying to compile for Win64, any luck anyone?
I was getting this "out of sync" error as well. I think that it is related to autocommit and using InnoDB tables. It happens in other languages (eg PHP and Python), so it may not be a bug of mYm. Actually the cpp source code is very neat!
To use my InnoDB table, I first send the following:
mym('SET autocommit = 1');
Then everything seems to work fine.
I also noticed that sending multiple SQL commands in one go, e.g.
mym('begin; insert ...; end;')
will not work well. It may execute, but if there is an error in the query, it won't be returned to you. Rather use
29 Jan 2012
This tool generally works, but I have encountered a number of bugs. For example, when I try to send multiple SELECT statements to the same server I get an "out of sync" error after the first statement. This requires re-opening the mysql connection, which is very slow.
15 Mar 2010
I have been able to compile this on mac 10.6.2 with the following command line:
/Applications/MATLAB_R2009b.app/bin/mex -v -maci64 -I../mysql-connector-c-6.0.2-osx10.5-x86-64bit/include/ -I/Applications/MATLAB_R2009b.app/extern/include/ -L/Applications/MATLAB_R2009b.app/bin/maci64/ -L../mysql-connector-c-6.0.2-osx10.5-x86-64bit/lib/ -lz -lmysqlclient_r -lSystemStubs -lpthread mym.cpp
Unfortuntely, upon running mym from matlab I get:
I think this is due to the whole @loader mechanism in OS X. I think this could be solved by linking the libraries statically. How do I do that with mex?
19 Jun 2009
mYm is a Matlab interface to MySQL server. It is based on the original 'MySQL and Matlab' by Robert Almgren and adds the support for Binary Large Object (BLOB). That is, it can insert matlab objects (e.g. array, structure, cell) into BLOB fields, as well retrieve from them. To save space, the matlab objects is first compressed (using zlib) before storing it into a BLOB field. Like Almgren's original, mYm supports multiple connections to MySQL server.