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 <f.bag...@gmail.com> 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 h2-database+unsubscr...@googlegroups.com > <javascript:_e(%7B%7D,'cvml','h2-database%2bunsubscr...@googlegroups.com');> > . > To post to this group, send email to h2-database@googlegroups.com > <javascript:_e(%7B%7D,'cvml','h2-database@googlegroups.com');>. > 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
