You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Bruno Busco <br...@gmail.com> on 2008/12/07 17:03:38 UTC
MySQL database automatic periodic backup
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
Re: MySQL database automatic periodic backup
Posted by BJ Freeman <bj...@free-man.net>.
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 <bj...@free-man.net>
>
>> 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
>>>
>
Re: MySQL database automatic periodic backup
Posted by Bruno Busco <br...@gmail.com>.
Many thanks for the clarification.
I will definitively go with cron.
-Bruno
2008/12/7 Sven Wesley <sv...@gmail.com>
> 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 <da...@hotwaxmedia.com>
>
> >
> > 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 <bj...@free-man.net>
> >>
> >> 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
> >>>>
> >>>>
> >>>
> >
>
Re: MySQL database automatic periodic backup
Posted by Sven Wesley <sv...@gmail.com>.
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 <da...@hotwaxmedia.com>
>
> 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 <bj...@free-man.net>
>>
>> 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
>>>>
>>>>
>>>
>
Re: MySQL database automatic periodic backup
Posted by David E Jones <da...@hotwaxmedia.com>.
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 <bj...@free-man.net>
>
>> 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
>>>
>>
Re: MySQL database automatic periodic backup
Posted by Bruno Busco <br...@gmail.com>.
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 <bj...@free-man.net>
> 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
> >
>
Re: MySQL database automatic periodic backup
Posted by BJ Freeman <bj...@free-man.net>.
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
>