[HowTo] How can I keep my backups for x days?

[miklosandras]

Version 1.4 updated: 2010-01-25 compatible with ISPCP 1.03

First, we should make sql table for define, how long do you want to keep backups / domain.

Code:

CREATE TABLE IF NOT EXISTS `domain_backup` (
  `id` int(5) NOT NULL auto_increment,
  `domain_name` varchar(200) character set utf8 collate utf8_unicode_ci NOT NULL,
  `site_backup_days` smallint(2) NOT NULL,
  `db_backup_days` smallint(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Next, please make this file:

/var/www/ispcp/engine/backup/archive_backups

check in the Attachment! or this txt:

http://yoursitehosting.net/archive_backups.txt

Make exec:

Code:

chmod +x /var/www/ispcp/engine/backup/archive_backups

Go and add this new line to crontab (/etc/cron.d/ispcp):

Code:

0 4 * * * root /var/www/ispcp/engine/backup/archive_backups > /dev/null

Please do a backup first about these files:

/var/www/ispcp/gui/reseller/domain_edit.php
/var/www/ispcp/gui/themes/omega_original/reseller/domain_edit.tpl

Code:

cp -p /var/www/ispcp/gui/themes/omega_original/reseller/domain_edit.tpl /var/www/ispcp/gui/themes/omega_original/reseller/domain_edit.tpl_backup
cp -p /var/www/ispcp/gui/reseller/domain_edit.php /var/www/ispcp/gui/reseller/domain_edit.php_backup

And if you never edited that files, then please replace them with the attachment files or these txts:

http://yoursitehosting.net/domain_edit_php.txt
http://yoursitehosting.net/domain_edit.tpl.txt

I created an instruction for manually edit these files if you don't want to repleace them:

http://yoursitehosting.net/domain_edit.p...y_line.txt
http://yoursitehosting.net/domain_edit.t...y_line.txt

And if you want custom days of keep backups per domain, then just update it at reseller level via edit domain, also you can set if you want to keep your site and/or your database backups:



If you want to turn off the this new directory (/var/www/virtual/$domain_name/archive_backups) from quota, then please edit this file:

/var/www/ispcp/engine/quota/ispcp-dsk-quota (line 118):

Code:

my $s = `$cmd_du --exclude="backups/$domain_name-*.lzma" --exclude="backups/$domain_name-*.bz2" --exclude="backups/$domain_name-*.gz" --exclude="backups/*.sql.lzma" --exclude="backups/*.sql.bz2" --exclude="backups/*.sql.gz" --exclude="logs/*.log" -s -B1 $main::cfg{APACHE_WWW_DIR}/$domain_name`;

change to:

Code:

my $s = `$cmd_du --exclude="archive_backups" --exclude="backups/$domain_name-*.lzma" --exclude="backups/$domain_name-*.bz2" --exclude="backups/$domain_name-*.gz" --exclude="backups/*.sql.lzma" --exclude="backups/*.sql.bz2" --exclude="backups/*.sql.gz" --exclude="logs/*.log" -s -B1 $main::cfg{APACHE_WWW_DIR}/$domain_name`;

And we should edit the backup script too (/var/www/ispcp/engine/backup/ispcp-backup-all):

find this line: 269

Code:

$backup_cmd = "$cmd_tar --create --directory=$dmn_dir --$zip --file=$dmn_dir/$backup_filename --exclude=logs --exclude=phptmp --exclude=backups --exclude=$backup_filename --exclude=$backup_filename.log . 2> $dmn_dir/$backup_filename.log";

and change to:

Code:

$backup_cmd = "$cmd_tar --create --directory=$dmn_dir --$zip --file=$dmn_dir/$backup_filename --exclude=logs --exclude=phptmp --exclude=backups --exclude=archive_backups --exclude=$backup_filename --exclude=$backup_filename.log . 2> $dmn_dir/$backup_filename.log";

If you have any question, just pm me

Script will create the directories (if not exist) and will create an entry to database too.

ps:at attachments, domain_edit.tpl.txt needed to rename to domain_edit.tpl
and also be carefully, if you will use online (txt) versions.

sitebackups renamed to archive_backups due to the script not only contain the site backups.

Thanks all to Kami and all other members, who help me.

[FISA4]

What to do if i want to keep only databases for some days?

Greets

FISA4

[miklosandras]

(03-20-2009 10:35 AM)FISA4 Wrote:  What to do if i want to keep only databases for some days?

Greets

FISA4

I updated the script

added addon to keep only database backups or keep only sitebackups or keep both backups:

PHP Code:

// $keep_db = "yes"; it is mean you can enable to keep database backups ( to disable: $keep_db = "no"; )
// $keep_site = "yes"; it is mean you can enable to keep site backups( to disable: $keep_site = "no"; ) 


First post will be update soon.

Attachment added to the first post!

[FISA4]

great,

now we have to create a script which autoupdate the database

something like that:

PHP Code:

$sql = "SELECT `domain` FROM `domain`";
$query=mysql_query($sql);
while($rs = mysql_fetch_array($query))
{
$sql2 = "INSERT INTO `domain_backup` (`id`, `domain_name`, `backup_days`) VALUES ("", '$rs['domain']', 8);";
$query2 = mysql_query($sql2);
} 


change "domain_add.php" and "domain_add.tpl" (i don´t know the real name of the files ) in reseller to automatic create the entry.

and

change

"domain_edit.php" and "domain_edit.tpl" to change the value of `backup_days`

and make a patch-file for the changes.

Then we have a great enhancement for ispCP

Greets

FISA4

[FISA4]

i followed the HowTo and i got an error:

alpha:~# /var/www/ispcp/engine/backup/./sitebackups.php
rm: fehlender Operand
ârm --helpâ gibt weitere Informationen.
X-Powered-By: PHP/5.2.6-1+lenny2
Content-type: text/html

the site backup and the sql backup are OK

[miklosandras]

(03-23-2009 07:59 PM)FISA4 Wrote:  i followed the HowTo and i got an error:

alpha:~# /var/www/ispcp/engine/backup/./sitebackups.php
rm: fehlender Operand
ârm --helpâ gibt weitere Informationen.
X-Powered-By: PHP/5.2.6-1+lenny2
Content-type: text/html

the site backup and the sql backup are OK

Yes, may it show some error, but it is working fine, and now released 1.0

Check the first post!

[FISA4]

(07-07-2009 04:52 AM)miklosandras Wrote:  

(03-23-2009 07:59 PM)FISA4 Wrote:  i followed the HowTo and i got an error:

alpha:~# /var/www/ispcp/engine/backup/./sitebackups.php
rm: fehlender Operand
ârm --helpâ gibt weitere Informationen.
X-Powered-By: PHP/5.2.6-1+lenny2
Content-type: text/html

the site backup and the sql backup are OK

Yes, may it show some error, but it is working fine, and now released 1.0

Check the first post!

Great work,

it would be nice to have:

different values for site and database backups.
set the value(s) if you create a new user.



in ispCP 1.0.1 we have the choice to switch off backups.
it would be nice, if you could build your add-on new with the latest nightly version because
the backup on/off is functionally since r1707 -> http://www.isp-control.net/ispcp/changeset/1707
and there are some changes in ispcp-backup-all, domain_edit.php and domain_edit.tpl


greets

FISA4

[ephigenie]

Nice addon & and candidate for builtin

One more thing : since there'is not only one Backup anymore,
it would be nice if the user can decide to which one he wants to fall back in case he needs to
jump over a day or 2 ...

[BeNe]

Good Point! So the user should have the ability to select a Backup with a Radio-Button ?!

If miklosandras can create a Patch for the current trunk, we can add this also in the SVN or ? Anyone against it ?

Greez BeNe

[ephigenie]

I think so - from a first view it seems ok for me.

There might be still some issues regarding quota calculation (are ALL the Backups excluded)
I mean if a reseller might set "keep backups" to lets say 60 days and one of the pages of his customers is some kind of bigger online shop with maybe 2 gb - then this'll add up to 120 gb.
And maybe only 2 gb is counted ... so there should be a switch for admins to allow their resellers to have quota with and without backups .