MySQL database automatic periodic backup

[Bruno Busco]

Hi list,
I would like to have OFBiz automatically backup its own database at regular
time intervals.
Has someone already done something similar or could offer me some idea on
the best way to implement it?

Many thanks,
-Bruno

[BJ Freeman]

if you talking about the actual database no.
this would require a class that is specific to each database that would
be specified in the entityengine.xml

however if you look at webtools, you can export the data as entities.
using that as a model you can export and add date-time to the files.
this then can be run as a re-occurring service.


Bruno Busco sent the following on 12/7/2008 8:03 AM:
> Hi list,
> I would like to have OFBiz automatically backup its own database at regular
> time intervals.
> Has someone already done something similar or could offer me some idea on
> the best way to implement it?
>
> Many thanks,
> -Bruno
>

[Bruno Busco]

Hi BJ,
sometime I read in the list that the OFBiz export fuctionality was not
intended to be used to perform a system administration database backup.
I was thinking to run through an OFBiz re-occurring service an external
mysql dump command or similar.

Are somewhere examples of running similar external applications from OFBiz?

Many thanks,
-Bruno

2008/12/7 BJ Freeman <[hidden email]>

> if you talking about the actual database no.
> this would require a class that is specific to each database that would
> be specified in the entityengine.xml
>
> however if you look at webtools, you can export the data as entities.
> using that as a model you can export and add date-time to the files.
> this then can be run as a re-occurring service.
>
>
> Bruno Busco sent the following on 12/7/2008 8:03 AM:
> > Hi list,
> > I would like to have OFBiz automatically backup its own database at
> regular
> > time intervals.
> > Has someone already done something similar or could offer me some idea on
> > the best way to implement it?
> >
> > Many thanks,
> > -Bruno
> >
>

[BJ Freeman]

Each database has a different way to back up.
so yes, if you write the low level database dependent class
then write a general back service that call the back up class that has
been loaded for that database, you could do this.

Bruno Busco sent the following on 12/7/2008 10:26 AM:

> Hi BJ,
> sometime I read in the list that the OFBiz export fuctionality was not
> intended to be used to perform a system administration database backup.
> I was thinking to run through an OFBiz re-occurring service an external
> mysql dump command or similar.
>
> Are somewhere examples of running similar external applications from OFBiz?
>
> Many thanks,
> -Bruno
>
> 2008/12/7 BJ Freeman <[hidden email]>
>
>> if you talking about the actual database no.
>> this would require a class that is specific to each database that would
>> be specified in the entityengine.xml
>>
>> however if you look at webtools, you can export the data as entities.
>> using that as a model you can export and add date-time to the files.
>> this then can be run as a re-occurring service.
>>
>>
>> Bruno Busco sent the following on 12/7/2008 8:03 AM:
>>> Hi list,
>>> I would like to have OFBiz automatically backup its own database at
>> regular
>>> time intervals.
>>> Has someone already done something similar or could offer me some idea on
>>> the best way to implement it?
>>>
>>> Many thanks,
>>> -Bruno
>>>
>

[David E Jones-3]

It sounds like it would be better to keep this out of OFBiz if you  
don't want the data running through the Entity Engine and the  
applications.

Yes, the service engine supports scheduled services and you can use  
"hack-ish" things to call command-line programs, but cron is way more  
direct and because it can more easily run on the same machine and is  
much smaller and has less "moving parts" than OFBiz, it would be more  
reliable.

-David


On Dec 7, 2008, at 11:26 AM, Bruno Busco wrote:

> Hi BJ,
> sometime I read in the list that the OFBiz export fuctionality was not
> intended to be used to perform a system administration database  
> backup.
> I was thinking to run through an OFBiz re-occurring service an  
> external
> mysql dump command or similar.
>
> Are somewhere examples of running similar external applications from  
> OFBiz?
>
> Many thanks,
> -Bruno
>
> 2008/12/7 BJ Freeman <[hidden email]>
>
>> if you talking about the actual database no.
>> this would require a class that is specific to each database that  
>> would
>> be specified in the entityengine.xml
>>
>> however if you look at webtools, you can export the data as entities.
>> using that as a model you can export and add date-time to the files.
>> this then can be run as a re-occurring service.
>>
>>
>> Bruno Busco sent the following on 12/7/2008 8:03 AM:
>>> Hi list,
>>> I would like to have OFBiz automatically backup its own database at
>> regular
>>> time intervals.
>>> Has someone already done something similar or could offer me some  
>>> idea on
>>> the best way to implement it?
>>>
>>> Many thanks,
>>> -Bruno
>>>
>>

[Sven Wesley]

Agree on not putting the backup inside the backuped system. Run it either
cold or hot, I run mysqldump every day and the backups are nicely restored
with load (set constraints off, load, set constraints on).

Regards,
Sven

2008/12/7 David E Jones <[hidden email]>

>
> It sounds like it would be better to keep this out of OFBiz if you don't
> want the data running through the Entity Engine and the applications.
>
> Yes, the service engine supports scheduled services and you can use
> "hack-ish" things to call command-line programs, but cron is way more direct
> and because it can more easily run on the same machine and is much smaller
> and has less "moving parts" than OFBiz, it would be more reliable.
>
> -David
>
>
>
> On Dec 7, 2008, at 11:26 AM, Bruno Busco wrote:
>
>  Hi BJ,
>> sometime I read in the list that the OFBiz export fuctionality was not
>> intended to be used to perform a system administration database backup.
>> I was thinking to run through an OFBiz re-occurring service an external
>> mysql dump command or similar.
>>
>> Are somewhere examples of running similar external applications from
>> OFBiz?
>>
>> Many thanks,
>> -Bruno
>>
>> 2008/12/7 BJ Freeman <[hidden email]>
>>
>>  if you talking about the actual database no.
>>> this would require a class that is specific to each database that would
>>> be specified in the entityengine.xml
>>>
>>> however if you look at webtools, you can export the data as entities.
>>> using that as a model you can export and add date-time to the files.
>>> this then can be run as a re-occurring service.
>>>
>>>
>>> Bruno Busco sent the following on 12/7/2008 8:03 AM:
>>>
>>>> Hi list,
>>>> I would like to have OFBiz automatically backup its own database at
>>>>
>>> regular
>>>
>>>> time intervals.
>>>> Has someone already done something similar or could offer me some idea
>>>> on
>>>> the best way to implement it?
>>>>
>>>> Many thanks,
>>>> -Bruno
>>>>
>>>>
>>>
>

[Bruno Busco]

Many thanks for the clarification.
I will definitively go with cron.
-Bruno

2008/12/7 Sven Wesley <[hidden email]>

> Agree on not putting the backup inside the backuped system. Run it either
> cold or hot, I run mysqldump every day and the backups are nicely restored
> with load (set constraints off, load, set constraints on).
>
> Regards,
> Sven
>
> 2008/12/7 David E Jones <[hidden email]>
>
> >
> > It sounds like it would be better to keep this out of OFBiz if you don't
> > want the data running through the Entity Engine and the applications.
> >
> > Yes, the service engine supports scheduled services and you can use
> > "hack-ish" things to call command-line programs, but cron is way more
> direct
> > and because it can more easily run on the same machine and is much
> smaller
> > and has less "moving parts" than OFBiz, it would be more reliable.
> >
> > -David
> >
> >
> >
> > On Dec 7, 2008, at 11:26 AM, Bruno Busco wrote:
> >
> >  Hi BJ,
> >> sometime I read in the list that the OFBiz export fuctionality was not
> >> intended to be used to perform a system administration database backup.
> >> I was thinking to run through an OFBiz re-occurring service an external
> >> mysql dump command or similar.
> >>
> >> Are somewhere examples of running similar external applications from
> >> OFBiz?
> >>
> >> Many thanks,
> >> -Bruno
> >>
> >> 2008/12/7 BJ Freeman <[hidden email]>
> >>
> >>  if you talking about the actual database no.
> >>> this would require a class that is specific to each database that would
> >>> be specified in the entityengine.xml
> >>>
> >>> however if you look at webtools, you can export the data as entities.
> >>> using that as a model you can export and add date-time to the files.
> >>> this then can be run as a re-occurring service.
> >>>
> >>>
> >>> Bruno Busco sent the following on 12/7/2008 8:03 AM:
> >>>
> >>>> Hi list,
> >>>> I would like to have OFBiz automatically backup its own database at
> >>>>
> >>> regular
> >>>
> >>>> time intervals.
> >>>> Has someone already done something similar or could offer me some idea
> >>>> on
> >>>> the best way to implement it?
> >>>>
> >>>> Many thanks,
> >>>> -Bruno
> >>>>
> >>>>
> >>>
> >
>