Request Sql script to build ofbiz database?

[Naveen Metta-2]

Where can I find sql script to build out of box ofbiz database?

Thank you
Navin.

Sent from my iPhone

[Deepak Dixit-4]

Hi Naveen,

Your email has been moderated, Please subscribe to the mailing list
http://ofbiz.apache.org/mailing-lists.html

Regarding your question, Please refer DatabaseUtil.java file for the
reference.


Thanks & Regards
--
Deepak Dixit



On Fri, Nov 30, 2018 at 10:34 AM Naveen Metta <[hidden email]> wrote:

> Where can I find sql script to build out of box ofbiz database?
>
> Thank you
> Navin.
>
> Sent from my iPhone
>

[Naveen Metta]

Thank you. Sent from my iPhone.
 
Navin K. Metta
903-484-4097
[hidden email]
https://www.linkedin.com/in/naveenmetta

> On Nov 29, 2018, at 11:12 PM, Deepak Dixit <[hidden email]> wrote:
>
> Hi Naveen,
>
> Your email has been moderated, Please subscribe to the mailing list
> http://ofbiz.apache.org/mailing-lists.html
>
> Regarding your question, Please refer DatabaseUtil.java file for the reference.
>
>
> Thanks & Regards
> --
> Deepak Dixit
>
>
>
>> On Fri, Nov 30, 2018 at 10:34 AM Naveen Metta <[hidden email]> wrote:
>> Where can I find sql script to build out of box ofbiz database?
>>
>> Thank you
>> Navin.
>>
>> Sent from my iPhone

[Pierre Smits-3]

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 <[hidden email]> wrote:

> Where can I find sql script to build out of box ofbiz database?
>
> Thank you
> Navin.
>
> Sent from my iPhone
>

[Naveen Metta]

MySQL 5.7 please.

Thank you. Sent from my iPhone.
 
Navin K. Metta
903-484-4097
[hidden email]
https://www.linkedin.com/in/naveenmetta

> On Nov 30, 2018, at 2:11 AM, Pierre Smits <[hidden email]> 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 <[hidden email]> wrote:
>>
>> Where can I find sql script to build out of box ofbiz database?
>>
>> Thank you
>> Navin.
>>
>> Sent from my iPhone
>>

[Naveen Metta]

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
[hidden email]
https://www.linkedin.com/in/naveenmetta

> On Nov 30, 2018, at 7:13 AM, Naveen Metta <[hidden email]> wrote:
>
> MySQL 5.7 please.
>
> Thank you. Sent from my iPhone.
>  
> Navin K. Metta
> 903-484-4097
> [hidden email]
> https://www.linkedin.com/in/naveenmetta
>
>> On Nov 30, 2018, at 2:11 AM, Pierre Smits <[hidden email]> 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 <[hidden email]> wrote:
>>>
>>> Where can I find sql script to build out of box ofbiz database?
>>>
>>> Thank you
>>> Navin.
>>>
>>> Sent from my iPhone
>>>

[Paul Foxworthy]

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 <[hidden email]> 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
> [hidden email]
> https://www.linkedin.com/in/naveenmetta
>
> > On Nov 30, 2018, at 7:13 AM, Naveen Metta <[hidden email]>
> wrote:
> >
> > MySQL 5.7 please.
> >
> > Thank you. Sent from my iPhone.
> >
> > Navin K. Metta
> > 903-484-4097
> > [hidden email]
> > https://www.linkedin.com/in/naveenmetta
> >
> >> On Nov 30, 2018, at 2:11 AM, Pierre Smits <[hidden email]>
> 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 <[hidden email]>
> 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: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]