Hi, Yep there were no errors or warnings just few records skipped.
Still need to figure out why its skipping those records.................. I think that is because of mySQL handles relationships differently than H2. On Thu, Aug 16, 2012 at 5:51 PM, Robin Boldt <[email protected]> wrote: > Hi, > > if the insertion worked without any warnings or errors, the migration > should have been successful ;) > > 2012/8/16 Tariq Mehmood <[email protected]> > >> Thanks, >> Way i did it was that i created .csv files of each table from H2 and >> inserted them into to mySQL. >> What do u think is this approach fine. >> Or will i loose the relationships this way. >> >> Seems you option of batch mode is better but have to research on this one >> know. >> >> On Thu, Aug 16, 2012 at 5:42 PM, Robin <[email protected]> wrote: >> >>> Hi Tariq, >>> >>> from my point of view, if everything works fine now, you shouldn't care >>> about the error any more ;). >>> >>> What I was trying to point out: >>> If you are migrating your data, it is important to insert at first the >>> tables without any foreign keys. Then while(tables left){ insert all >>> tables that have only already created foreign tables). And if this >>> algorithm ends up in an endless loop, you should try a batch insert mode >>> (probably batch insert will be allways better?). >>> >>> Greets Robin >>> >>> >>> On Thursday, August 16, 2012 6:34:12 PM UTC+2, Tariq Mehmood wrote: >>> >>>> Hi, Robin; >>>> >>>> Thanks for the reply, i finally got rid of this error by reinitializing >>>> the gerrit server. >>>> I donot see this error. >>>> Now i am trying to verify the data i imported from H2. >>>> Is there any easy way to verify that all the data was inserted >>>> correctly. >>>> >>>> BR Tariq >>>> >>>> and thanks again for looking into it. >>>> >>>> On Thu, Aug 16, 2012 at 5:23 PM, Robin <[email protected]> wrote: >>>> >>>>> Hi, >>>>> >>>>> probably you are inserting your Data in a wrong order? Like you want >>>>> to create data with a foreign key, but the linked data doesn't exist? >>>>> >>>>> So you should start with all Tables, that don't have any dependencies. >>>>> If this is not possible for you, I think there is a so called batch mode >>>>> or >>>>> something (Do a research if you need it), with this mode you can insert >>>>> your data and the dependencies will be checked after the whole batch is >>>>> finished. >>>>> >>>>> With best Regards >>>>> >>>>> >>>>> On Wednesday, August 15, 2012 3:33:36 PM UTC+2, Tariq Mehmood wrote: >>>>>> >>>>>> Hi all, >>>>>> >>>>>> I recently did a data transfer from H2 to mySql. >>>>>> >>>>>> 1. I copied all the tables from H2 using a bash script >>>>>> 2. Converted them into .csc files(each table has a .csv file) >>>>>> 3. Ran mysqlimport command to dump these .csv files >>>>>> into MySQL database(data transfer to MySQL was successful, it is >>>>>> skipping >>>>>> some records in some of the tables, which i believe because of >>>>>> relationships) >>>>>> 4. Gerrit is starting OK >>>>>> 5. First user was created in MySQL table and >>>>>> given administrative rights. >>>>>> >>>>>> I cannot see all the repos in Gerrit. >>>>>> Error log is as follows:Thanks for the reply, >>>>>> the error log looks like this in my case: >>>>>> >>>>>> [2012-08-15 11:46:33,637] WARN / : Error in allQueryNext >>>>>> java.lang.**IllegalStateExceptio**n: Missing project All-Projects >>>>>> at com.google.gerrit.server.**proje**ct.ProjectCacheImpl.** >>>>>> getAllProj**ects(**ProjectCacheImpl.java:90) >>>>>> at com.google.gerrit.server.**accou**nt.CapabilityControl.<** >>>>>> init>(**CapabilityControl.java:**55) >>>>>> at sun.reflect.**NativeConstructorA**ccessorImpl.**newInstance0(* >>>>>> *Native Method) >>>>>> at sun.reflect.**NativeConstructorA**ccessorImpl.**newInstance(** >>>>>> Native**ConstructorAccessorImpl.**java:**39) >>>>>> at sun.reflect.**DelegatingConstruc**torAccessorI** >>>>>> mpl.newInstance(**De**legatingConstructorAccessorI**mp**l.java:27) >>>>>> at java.lang.reflect.Constructor.**** >>>>>> newInstance(Constructor.java:**5**13) >>>>>> at com.google.inject.internal.**Def**aultConstructionProxyFactor* >>>>>> *y$**2.newInstance(**DefaultConstruct**ionProxyFactor**y.java:85) >>>>>> at com.google.inject.internal.**Con**structorInjector.construct(* >>>>>> *Con**structorInjector.java:85) >>>>>> at com.google.inject.internal.**Con**structorBindingImpl$** >>>>>> Factory.**get(**ConstructorBindingImpl.**java:**254) >>>>>> at com.google.inject.internal.**Inj**ectorImpl$4$1.call(** >>>>>> InjectorImp**l.java:978) >>>>>> at com.google.inject.internal.**Inj**ectorImpl.callInContext(** >>>>>> Inject**orImpl.java:1024) >>>>>> at com.google.inject.internal.**Inj**ectorImpl$4.get(** >>>>>> InjectorImpl.**java:974) >>>>>> at com.google.inject.**assistedinje**ct.** >>>>>> FactoryProvider2.invoke(**Fac**toryProvider2.java:632) >>>>>> at $Proxy35.create(Unknown Source) >>>>>> >>>>>> Any thoughts/pointer are welcome and Thanks in advance for your >>>>>> help. >>>>>> >>>>>> Althought iam getting Application error in the browser but it is >>>>>> authenticating the user which was created when i hit continue. >>>>>> >>>>>> Tariq >>>>>> >>>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "H2 Database" group. >>>>> To view this discussion on the web visit https://groups.google.com/d/* >>>>> *msg/h2-database/-/mtwTHdLmshkJ<https://groups.google.com/d/msg/h2-database/-/mtwTHdLmshkJ> >>>>> **. >>>>> >>>>> To post to this group, send email to [email protected]. >>>>> To unsubscribe from this group, send email to h2-database...@** >>>>> googlegroups.com. >>>>> >>>>> For more options, visit this group at http://groups.google.com/** >>>>> group/h2-database?hl=en<http://groups.google.com/group/h2-database?hl=en> >>>>> . >>>>> >>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "H2 Database" group. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msg/h2-database/-/NP5KEZdNaOMJ. >>> >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/h2-database?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
