Grouper 2.3.0 from demo server migrate to another server. Note, I used SQLyog community for all this
- Create a schema
- utf8 charset
- utf8_bin collation
- Create user, and grant all to that user on that schema
- Exporting MYSQL structure and data did not work. So startup grouper against the new schema, and create tables with
- gsh -registry -runscript
- truncate the database, so there is no data
- Export data to SQL from existing server, note, include option to disable and re-enable foreign keys
- Import into new database
- Turn on Grouper