Hi Naveen, A database with the right schema is not enough. OFBiz needs seed data within the database as well.
I suggest you create a database in the usual OFBiz way. Once done, you could use mysqldump to make an SQL script that could recreate the database in future. Have a look at the following: https://cwiki.apache.org/confluence/display/OFBIZ/How+to+migrate+OFBiz+from+Derby+to+MySQL+database https://cwiki.apache.org/confluence/display/OFBENDUSER/How+to+Install+OFBiz+without+the+Demo+Data to create a database with seed data only. The first discusses how to configure OFBiz to use MySQL instead of Derby. The second says how to create a database with only seed data within it. Cheers Paul Foxworthy On Sat, 1 Dec 2018 at 08:39, Naveen Metta <[email protected]> wrote: > Sorry i missed ofbiz release. I need ofbiz database sql compatible with > Ofbiz 16.11 and Mysql 5.7 and above. > > Thank you. Sent from my iPhone. > > Navin K. Metta > 903-484-4097 > [email protected] > https://www.linkedin.com/in/naveenmetta > > > On Nov 30, 2018, at 7:13 AM, Naveen Metta <[email protected]> > wrote: > > > > MySQL 5.7 please. > > > > Thank you. Sent from my iPhone. > > > > Navin K. Metta > > 903-484-4097 > > [email protected] > > https://www.linkedin.com/in/naveenmetta > > > >> On Nov 30, 2018, at 2:11 AM, Pierre Smits <[email protected]> > wrote: > >> > >> Hi Naveen, > >> > >> Could you indicate for which OFBiz release and which RDBMS platform you > >> would like to have this? > >> > >> Best regards, > >> > >> Pierre Smits > >> > >> *Apache Trafodion <https://trafodion.apache.org>, Vice President* > >> *Apache Directory <https://directory.apache.org>, PMC Member* > >> Apache Incubator <https://incubator.apache.org>, committer > >> *Apache OFBiz <https://ofbiz.apache.org>, contributor (without > privileges) > >> since 2008* > >> Apache Steve <https://steve.apache.org>, committer > >> > >> > >>> On Fri, Nov 30, 2018 at 6:04 AM Naveen Metta <[email protected]> > wrote: > >>> > >>> Where can I find sql script to build out of box ofbiz database? > >>> > >>> Thank you > >>> Navin. > >>> > >>> Sent from my iPhone > >>> > -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Australia Phone: +61 3 9585 6788 Web: http://www.coherentsoftware.com.au/ Email: [email protected]
