rasqlinsert and InnoDB

[Carter Bullard]

Hey John,
In argus-clients-3.0.5.x  (I just uploaded 36), we have two ways to change
the database table type.  On the command line for rasqlinsert.1, the option
is:
   rasqlinsert -M mysql_engine="whatever" ……..

In the .rarc file, there is the variable:

   MYSQL_DB_ENGINE="MyISAM"

You can change that to any of the supported values (InnoDB, Merge,
Memory, Archive, NDB, Federated, CSV, ….) and any new tables that
a rasql* program will create will get the new type.

As I mentioned before, we aren't doing a lot of error checking on table types,
schema definitions, etc… to ensure that any existing tables that would
be written to are "OK to go" so to speak.  We do have the "-M drop" option
so that if a database table exists, you will drop it and recreate it.

So I would recommend while testing, that on the command-line you use:

   rasqlinsert -M drop mysql_engine="whatever" ……..

To get started, and when happy, you can modify the .rarc file to get the
behavior you want.

Hope this helps, and if you have any problems, holler !!!!!

Carter


On Mar 15, 2012, at 7:26 PM, John Kennedy wrote:

> Hi Carter,
> 
> I am just curious what mysql engine is supported for rasqlinsert?  rasqlinsert works great on a mysql instance using a MyISAM engine; however, I get errors when using InnoDB.
> 
> Thanks
> 
> John

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4367 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20120319/13c7af58/attachment.bin>