Hi, I have a gerrit instance running with an h2 database. It is time for me to move to a new server with mysql database.
Here is what I did. On the mysql server : 1. Initialisation of database scheme with java -jar gerrit.war init -d /home/gerrit On the H2 server : 2. Get a backup of the DB content with java -cp h2-1.3.175.jar org.h2.tools.Script -url jdbc:h2:/home/gerrit/db/ReviewDB -user '' -password '' 3. edit of the backup.sql file to make it mysql understandable : - removed everything except insert into statements (Database scheme is already created on mysql) - removed all h2 specific keywords (*TIMESTAMP*, *PUBLIC*.<tablename>, ...) On the mysql server : 4. import of the edited backup.mysql. Returns no errors, data are present in the mysql DB. 5. Restart gerrit Gerrit seems to be working but : - My user is in administrator group, but I cannot create new project - Groups does not even shows up, except for the 5 defaults groups. They are in table account_group_names in the mysql DB. - Users shows up correctly when trying to add them to a group, and this works. What am I missing ? Any help is greatly appreciated Fabien Bagard -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
