convert instance of ofbiz/derby to ofbiz/mysql?

[rhodebump]

Hi Everyone.

I am currently running ofbiz/derby and seeing some scary stuff in the  
logs about locks, etc...  I was wondering if I have an option to  
convert to the mysql database, and if I should?

Is there a magical set of scripts that will migrate the data from  
derby into mysql?




Thanks!

[rajsaini]

I think the way out is take XML dump of data using webtool's
entity-engine xml export facility. Configure ofbiz to use
PostgreSQL(Recommended) or MySQL database and "run-install-seed" ant
task. Load the data back to Ofbiz using webtools entity-engine xml
import facility.

Raj

phillip rhodes wrote:

> Hi Everyone.
>
> I am currently running ofbiz/derby and seeing some scary stuff in the
> logs about locks, etc...  I was wondering if I have an option to
> convert to the mysql database, and if I should?
>
> Is there a magical set of scripts that will migrate the data from
> derby into mysql?
>
>
>
>
> Thanks!
>
>

[Jaki-2]

How do you configure ofbiz to use a different db (mysql in this case)?

Raj Saini wrote

I think the way out is take XML dump of data using webtool's
entity-engine xml export facility. Configure ofbiz to use
PostgreSQL(Recommended) or MySQL database and "run-install-seed" ant
task. Load the data back to Ofbiz using webtools entity-engine xml
import facility.

Raj

phillip rhodes wrote:
> Hi Everyone.
>
> I am currently running ofbiz/derby and seeing some scary stuff in the
> logs about locks, etc...  I was wondering if I have an option to
> convert to the mysql database, and if I should?
>
> Is there a magical set of scripts that will migrate the data from
> derby into mysql?
>
>
>
>
> Thanks!
>
>

[David E Jones]

http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide

-David


On Apr 29, 2008, at 11:06 PM, jaki wrote:

>
> How do you configure ofbiz to use a different db (mysql in this case)?
>
>
> Raj Saini wrote:
>>
>> I think the way out is take XML dump of data using webtool's
>> entity-engine xml export facility. Configure ofbiz to use
>> PostgreSQL(Recommended) or MySQL database and "run-install-seed" ant
>> task. Load the data back to Ofbiz using webtools entity-engine xml
>> import facility.
>>
>> Raj
>>
>> phillip rhodes wrote:
>>> Hi Everyone.
>>>
>>> I am currently running ofbiz/derby and seeing some scary stuff in  
>>> the
>>> logs about locks, etc...  I was wondering if I have an option to
>>> convert to the mysql database, and if I should?
>>>
>>> Is there a magical set of scripts that will migrate the data from
>>> derby into mysql?
>>>
>>>
>>>
>>>
>>> Thanks!
>>>
>>>
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/convert-instance-of-ofbiz-derby-to-ofbiz-mysql--tp16973844p16975476.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Jaki-2]

I changed the database to oracle but I suppose it's empty since webtools doesn't recognize my username and password. How do I run webtools then so that I can migrate data from derby to oracle?

rhodebump wrote

Hi Everyone.

I am currently running ofbiz/derby and seeing some scary stuff in the  
logs about locks, etc...  I was wondering if I have an option to  
convert to the mysql database, and if I should?

Is there a magical set of scripts that will migrate the data from  
derby into mysql?




Thanks!

[David E Jones]

Use the command line data loading tools described in the Technical  
Production Setup Guide (on docs.ofbiz.org).

-David


On May 2, 2008, at 5:32 AM, jaki wrote:

>
> I changed the database to oracle but I suppose it's empty since  
> webtools
> doesn't recognize my username and password. How do I run webtools  
> then so
> that I can migrate data from derby to oracle?
>
> rhodebump wrote:
>>
>> Hi Everyone.
>>
>> I am currently running ofbiz/derby and seeing some scary stuff in the
>> logs about locks, etc...  I was wondering if I have an option to
>> convert to the mysql database, and if I should?
>>
>> Is there a magical set of scripts that will migrate the data from
>> derby into mysql?
>>
>>
>>
>>
>> Thanks!
>>
>>
>>
>
> --
> View this message in context: http://www.nabble.com/convert-instance-of-ofbiz-derby-to-ofbiz-mysql--tp16973844p17015673.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[rhodebump]

I just wanted to report that this worked pretty good.

I did have to remove the ServerHits and Visitor related xml files  
since this huge amount of data was killing the import process, but  
after I moved these xml files out of the way, things took 2 minutes  
and I am up and running in mysql.

Very impressed!  I need to incorporate this type of import/export in  
all my apps cause data migrations are a pain!


On Apr 29, 2008, at 9:16 PM, phillip rhodes wrote:

> Hi Everyone.
>
> I am currently running ofbiz/derby and seeing some scary stuff in  
> the logs about locks, etc...  I was wondering if I have an option to  
> convert to the mysql database, and if I should?
>
> Is there a magical set of scripts that will migrate the data from  
> derby into mysql?
>
>
>
>
> Thanks!
>