Hi, So, it is working for H2 but not MySQL. I would probably ask this question at StackOverflow.com, with the tags MySQL, Gerrit, and H2.
Regards, Thomas On Thursday, September 4, 2014, Fabien Bagard <[email protected]> wrote: > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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.
