There are issues (especially with older versions of Mysql) in exporting and importing a database.
When importing, look for this error (or something like it):
When starting Grouper you get this error:
If you look in the database you might see views that are tables:
The reason for this is the mysqldump will create temporary tables that look like views, but even so the views which are based on other views and created in alphabetical order do not work right. Mysql cannot create views if the underlying objects are not there, which makes things complicated and delicate.
Create a database and a user and password (note the character set and collation)
Note: you should lock down the user to only be able to connect from wherever they should be able to connect from
Generate the Grouper SQL to create the database, but dont run it
- Mysqldump from the database to copy from. Do not include views. If you include views, it difficult to edit the file since peppered throughout the file is creating temporary tables for views. So you need to create without views. sqlyog can do this, maybe other gui tools too
Edit the sql dump file with the new database at top
Import the database into the new database
Import the views sql from the gsh script
- Start Grouper!