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 |
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 > |
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 > > > |
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 >>> > |
In reply to this post by Bruno Busco
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 >>> >> |
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 >>>> >>>> >>> > |
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 > >>>> > >>>> > >>> > > > |
Free forum by Nabble | Edit this page |