Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DB Backup With Audit Table Changes
02-17-2018, 11:42 PM, (This post was last modified: 02-18-2018, 01:32 AM by VortecCPI.)
#1
DB Backup With Audit Table Changes
I make a snapshot of the DB every time I enter a big set of transactions. I do this because I am a webERP novice and I want (need) the ability to roll back should I do something wrong or just plain stupid.

It would be nice if we had a setting to snapshot the DB every time the audit table is changed. In my opinion this would be very handy for testing and what-if scenarios for new users as well as current users.

Of course this would not be good in an enterprise situation with many transactions occurring but it could be okay for a small business.

And yes... I have had to roll back the DB many times during my errors and experimentation!

Just an idea...
https://www.linkedin.com/in/eclipsepaulbecker
Reply
02-18-2018, 01:09 AM,
#2
RE: DB Backup With Audit Table Changes
Or perhaps after N transactions or transactions of type N from the SysTypes table...
https://www.linkedin.com/in/eclipsepaulbecker
Reply
02-19-2018, 11:59 PM,
#3
RE: DB Backup With Audit Table Changes
I like the idea an 'activity' based backup condition.
I guess many system administrators will desire a time-based backup schedule.
Perhaps we could make provision for both?

How would the backup script be triggered? At user logon?
It could be annoying to users if the systems 'hangs' during a database dump just after logon.
Is there anyway to make the database backups run in the background?

I currently backup databases and directories via a cronjob every 24 hours, and also send the backup files to remote online storage via webDAV.

There are probably many users on shared hosting who don't have access to cronjob scheduling.
https://www.linkedin.com/in/andrewcouling
Reply
02-20-2018, 12:28 AM,
#4
RE: DB Backup With Audit Table Changes
I create DB backups every hour via CRON but I also make a DB backup before every large transaction or set of transactions.

As network admins we can do all sorts of cool and neat things but others, to your point above, may not be able.
https://www.linkedin.com/in/eclipsepaulbecker
Reply
02-20-2018, 02:27 AM,
#5
RE: DB Backup With Audit Table Changes
I found this stackoverflow post regarding scheduled backups without the use on cronjobs, and request time.
https://www.linkedin.com/in/andrewcouling
Reply
02-20-2018, 03:10 AM,
#6
RE: DB Backup With Audit Table Changes
QuickBooks has a setting that allows for backups based upon frequency. When the count reaches the setting QB prompts for a backup and resets the counter.

Very simple but effective.
https://www.linkedin.com/in/eclipsepaulbecker
Reply
02-21-2018, 09:44 PM,
#7
RE: DB Backup With Audit Table Changes
I noticed that Tim has a 'Scheduled Jobs' script in his code.

Other than backups, I wonder what other scripts people may need to run a regular basis? Do you have others?

Andy.
https://www.linkedin.com/in/andrewcouling
Reply
02-21-2018, 11:48 PM,
#8
RE: DB Backup With Audit Table Changes
Hi Andy, that was written in order to synchronise with open cart. Ricard and I were doing some work on this synchronisation and I was playing with ways to schedule this. Of course it could also be used for backups, and report printing Smile

Tim
Reply
02-22-2018, 12:01 AM,
#9
RE: DB Backup With Audit Table Changes
Thanks Tim. Interesting.
It seems there may be more than a few popular uses for scheduled tasks.
I spotted a piece about the EDI functionality requiring a cron job on the wiki.

Andy.
https://www.linkedin.com/in/andrewcouling
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)