Grouper Users - Open Discussion List

[Chris Hyzer <>]

If you do a reset, it shouldn't drop and create table, just truncates the 
data...

But yes, just take that file, edit it, and run it.  You can run with any 
mysql client, or with gsh with:

gsh  -registry -runsqlfile grouperDdl_20090109_16_20_43_723.sql

Regards,
Chris

> -----Original Message-----
> From: Scott Koranda 
> [mailto:]
> Sent: Thursday, February 19, 2009 10:48 AM
> To: Grouper Users Mailing List
> Subject: [grouper-users] forcing InnoDB for MySQL
> 
> Hi,
> 
> With my deployment I am not in a position to force all MySQL
> tables to be InnoDB by default by starting MySQL with
> 
> --default-table-type=InnoDB
> 
> I need another solution.
> 
> In my 1.4.0 deployment I see this file:
> 
> grouperDdl_20090109_16_20_43_723.sql
> 
> It appears to be the file that creates the necessary Grouper
> tables in the database.
> 
> Is it the file that is used to create the Grouper tables when I run
> 
> ./bin/gsh.sh -registry -reset
> 
> ?
> 
> If so then I plan to edit that file by hand and add
> 
> ENGINE=InnoDB
> 
> to the CREATE TABLE statements.
> 
> Thanks,
> 
> Scott