Topic: Backup module

 
User
Gravatar
Joined: 2010-05-20
Posts: 20
Hello.
This is indeed a VERY needed addon. +1 from me

Since I'm not amazon user I think that FTP upload would be really lovely.
I have done smth like this for one of my projects (it's FuelPHP based).

a screenshot looks like this: http://d.pr/yHkW

It's not something very feature-rich.

It's very simple, but does the job I needed for the project.

What it does:
when I press the 'Create snapshot' it asks for a snapshot comment. Later:
Creates table snapshot and puts it into a subdirectory with table name (bziped).

Later I can delete this snapshot, or revert from it .. Thats basicaly all

All backups I have done via exec(mysqldump..).
Because I could not figure out some things to work with PDO mysql driver.

One more comment to add, I think it's better to move to github.. since PyroCMS is on github

So basically I think:
ftp upload
comments
posibility to make/restore a backup directly from admin panel
cron job backups
 
 
User
Gravatar
Joined: 2010-12-02
Posts: 60
@huglester; I wanted to to Amazon S3 at first, but saw it's a paid service (monthly)? Therefore I switched to Dropbox, which I already have a couple of years and completely free of use (4GB currently). Uploading to there works like a charm. Successfully uploaded 10MB there in a matter of seconds.

About restore a backup in the admin, I haven't figured out how to import the .sql file correctly. I have no experience with exec() and some of my test didn't work so I have that on the to-do list.

You can create own settings of what to backup. The created backups can be deleted afterwards, so no files remain on the server but only in your inbox (database backup) and Dropbox (files backup). Multiple settings can be created.

What is it you mean with comments? Where do you want to put comments?

Cron jobs can be done, enter the url http://www.yoursite.com/backup/run/setting-slug/setting-password. In the admin is a quick

@James Norman; I just created a bitbucket account (ramonleenders). As we're both working on a backup module, I would like to see how you do/did things smile
 
 
User
Gravatar
Joined: 2010-12-08
Posts: 7
Thanks for all the suggestions guys! Just so your aware, the initial release will not support restoring from a database backup because of several contributing factors (security, DB privileges, etc.). IMO, this should be the responsibility of the DBA/Systems Admin.

When i've completed the module (nearly done) and documentation i'll be adding some accounts to the BitBucket repo. I'll let people know when they've been added.

If you want updates, you can follow me on Twitter where i'll be posting some snippets smile

Cheers,
James
 
 
User
Gravatar
Joined: 2011-01-16
Posts: 26
"this should be the responsibility of the DBA/Systems Admin". I totally agree.
 
 
User
Gravatar
Joined: 2010-12-02
Posts: 60

Osvaldo Brignoni - 2012-02-05

"this should be the responsibility of the DBA/Systems Admin". I totally agree.



Yeah, it should actually. But.. it would be a nice feature anyway. James, are you sending over a backup of the files to a FTP or how are you handling this? Too bad I hadn't heard about your project earlier, otherwise we could have collaborated wink
 
 
User
Gravatar
Joined: 2010-12-08
Posts: 7
Yeah, it should actually. But.. it would be a nice feature anyway. James, are you sending over a backup of the files to a FTP or how are you handling this? Too bad I hadn't heard about your project earlier, otherwise we could have collaborated


Totally agree, I would rather have it than not. Perhaps time will tell smile It's currently built for delivery via Email and to Amazon S3, and I've designed it so it's quite modular in terms of adding new Backup method, so I could extend it if there's enough demand.
 
 
User
Gravatar
Joined: 2010-12-02
Posts: 60
Quite a few options have been build in since the last edit. A maximum file backups has been implemented (maximum number of files in your backup folder, second safety if a slug and password has been "cracked" ) and changable quick backup configuration and other minor but usefull things.
The configurations can be viewed directly in the backup/index or backup/settings/index, so you see directly what each settings does (including the quick backup function, determined in the backup_c.php file, rather than according to the setting saved in the database).

I'll be making screenshots later this week for those that are interested. Suggestions will be considered to be implemented! Stay tuned..
 
 
User
Gravatar
Joined: 2010-12-02
Posts: 60
For those still following, I've made a couple of screenshots of the backup module. Everything is working pretty well right now, so I will be extending bit by bit now. FTP upload (and Amazon S3 if possible) will be one of the extensions.

http://imageshack.us/g/833/backupmodulescreenshot3.jpg/
 
 
User
Gravatar
Joined: 2010-12-08
Posts: 7
Hi everyone,

Thank you all for your interest in PyroBackup. The module has now been released onto the PyroCMS add-on store, and you can get to using this link:
http://www.pyrocms.com/store/details/pyrobackup_1

Cheers
James
 
 
User
Gravatar
Joined: 2010-12-02
Posts: 60
My backup module also needs some testing, for it's first release. If there are some people willing to test, send an email to info[at]ramon-leenders[dot]nl. You can also send a request at Twitter if you like (ramon_leenders).
I'd be glad to have some motivated people to do a good detailed review to make it as good as possible. I know, there already is a backup module in the store now, but don't we already have things already twice or more in life? ( who doesn't have two razors nowadays )