I am sure someone has thought of this before...
Can someone create a module that would automatically backup the OpenCart database at a specified time of day.
Example: automated backup the database at 2:00 AM CST everyday (or backup however many times a day). The key part is that it would be an automated process that would run however many times a day to backup the database.
As a user of this module, all you would do is
1) Login to the admin website
2) Set the time or times for the database backup
3) Specify the folder location for the destination of the database backup file
4) The database would be backed up and saved to a file on the web server in the specified folder
Can someone create a module that would automatically backup the OpenCart database at a specified time of day.
Example: automated backup the database at 2:00 AM CST everyday (or backup however many times a day). The key part is that it would be an automated process that would run however many times a day to backup the database.
As a user of this module, all you would do is
1) Login to the admin website
2) Set the time or times for the database backup
3) Specify the folder location for the destination of the database backup file
4) The database would be backed up and saved to a file on the web server in the specified folder
Can a cron job be *automatically* be scheduled by the module script itself? vTiger seems to be able to handle crons without needing users to exit the admin panel...
OC2PS
OC 3.0.3.7, vQmod 2.6.2, Journal3 theme
Arcfesték, Csillámtetoválás, Henna
Check out: All my extensions | My FREE extensions
Come to think of it, what about all these "webcalendar" scripts that let you schedule "reminders" from their web interfaces?
OC2PS
OC 3.0.3.7, vQmod 2.6.2, Journal3 theme
Arcfesték, Csillámtetoválás, Henna
Check out: All my extensions | My FREE extensions
True, Windows will make it trickier, since you'll need to use the scheduled tasks editor (or task scheduler in windows 7). Getting a module to have access to something that advanced really isn't something I would advise. Pretty sure you would need to have a script running as a particular user with certain rights to the /etc/crontab. This is something that people should be able to do fairly easily with cpanel and maybe plesk (although last time I looked it wasn't that simple), but other than that, I think its going to be more hassle than it's worth
As for the logins being more frequent than what I put, it really depends on the store IMO, not all stores get sales in mass volumes or even every day, and people go on holidays etc, so their admin doesn't get used during these periods. I realise that these aren't things that happen all the time, but they do happen. I'd personally want my backups done at regular intervals rather than the first time I used my admin panel after 24 hours from the previous backup, preferably at a time where users are at their lowest during the day, to risk any issues or db overloading
As for the logins being more frequent than what I put, it really depends on the store IMO, not all stores get sales in mass volumes or even every day, and people go on holidays etc, so their admin doesn't get used during these periods. I realise that these aren't things that happen all the time, but they do happen. I'd personally want my backups done at regular intervals rather than the first time I used my admin panel after 24 hours from the previous backup, preferably at a time where users are at their lowest during the day, to risk any issues or db overloading
Autocratic or what!Qphoria wrote:Silence! It is much more likely that you will login to your store more than that.
I'll add a vote for this idea too. I don't know enough to be let loose with a cron job, but like the idea of a backup triggered by admin or front office event.
I assume (hope) admin module logins are less frequent than frontend visits. To reduce database queries (shared hosts usually cap them), I would prefer triggering backup based on admin module login....i.e. when I log into admin, the script checks if it has been 24 hrs since last backup, etc
OC2PS
OC 3.0.3.7, vQmod 2.6.2, Journal3 theme
Arcfesték, Csillámtetoválás, Henna
Check out: All my extensions | My FREE extensions
I use this;
http://www.dagondesign.com/articles/aut ... up-script/
Then I wrote a bash script (called from cron) that also zips my website, encrypts the database output from the script and the website directory tree (with gpg) and emails it at 1:00am each night to an offsite email account.
At the end of the day I have a local copy of last nights backup and an offsite backup. Its actually saved my bacon once.
http://www.dagondesign.com/articles/aut ... up-script/
Then I wrote a bash script (called from cron) that also zips my website, encrypts the database output from the script and the website directory tree (with gpg) and emails it at 1:00am each night to an offsite email account.
At the end of the day I have a local copy of last nights backup and an offsite backup. Its actually saved my bacon once.
When usıng a VPS wıth Plex (or maybe cPanel) there are some tools that wıll let you backup you mySQL automatıcly.
Contact you hoster and ask what they can offer you.
Contact you hoster and ask what they can offer you.
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
Who is online
Users browsing this forum: No registered users and 5 guests