You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by phillip rhodes <sp...@rhoderunner.com> on 2008/04/30 03:16:59 UTC
convert instance of ofbiz/derby to ofbiz/mysql?
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!
Re: convert instance of ofbiz/derby to ofbiz/mysql?
Posted by phillip rhodes <sp...@rhoderunner.com>.
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!
>
Re: convert instance of ofbiz/derby to ofbiz/mysql?
Posted by David E Jones <jo...@hotwaxmedia.com>.
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.
>
Re: convert instance of ofbiz/derby to ofbiz/mysql?
Posted by jaki <ja...@infosys.com>.
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.
Re: convert instance of ofbiz/derby to ofbiz/mysql?
Posted by Raj Saini <ra...@gmail.com>.
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!
>
>
Re: convert instance of ofbiz/derby to ofbiz/mysql?
Posted by David E Jones <jo...@hotwaxmedia.com>.
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.
>
Re: convert instance of ofbiz/derby to ofbiz/mysql?
Posted by jaki <ja...@infosys.com>.
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.