#!/usr/bin/perl # backup.pl # Called by cron to backup a database, or all databases $no_acl_check++; require './mysql-lib.pl'; if ($ARGV[0] eq "--all") { $all = 1; $cmode = $config{'backup_cmode_'}; } else { $ARGV[0] || die "Missing database parameter"; $cmode = 0; } $extra_prefix = ""; if ($ARGV[1] eq "--prefix") { $extra_prefix = $ARGV[2]; } $email = $config{'backup_email_'.($all ? '' : $ARGV[0])}; $notify = $config{'backup_notify_'.($all ? '' : $ARGV[0])}; # Check if MySQL is running $ex = 0; ($r, $out) = &is_mysql_running(); if ($r != 1) { $failure = "MySQL does not appear to be running : $out\n". "Backups cannot be performed.\n"; $ex = 1; goto EMAIL; } # Get DBs if ($all) { @dbs = grep { &supports_backup_db($_) } &list_databases(); } else { @dbs = ( $ARGV[0] ); } if ($cmode) { # Run and check before-backup command (for all DBs) $bok = &execute_before(undef, STDOUT, 0, $config{'backup_'}, undef); if (!$bok) { $failure = "Before-backup command failed!\n"; $ex = 1; goto EMAIL; } } foreach $db (@dbs) { $sf = $all ? "" : $db; if ($all) { $dir = &date_subs($config{'backup_'}); $prefix = &date_subs($config{'backup_prefix_'}); &make_dir($dir, 0755) if ($config{'backup_mkdir_'}); $file = $dir."/".$extra_prefix.$prefix.$db.".sql". ($config{'backup_compress_'.$sf} == 1 ? ".gz" : $config{'backup_compress_'.$sf} == 2 ? ".bz2" : ""); } else { $file = &date_subs($config{'backup_'.$db}); } if (!$file) { push(@status, [ $db, $file, "No backup file set for $db" ]); $ex = 1; next; } @compat = $config{'backup_compatible_'.$sf} ? ( $config{'backup_compatible_'.$sf} ) : ( ); push(@compat, split(/\0/, $in{'backup_options_'.$sf})); @tables = split(/\s+/, $config{'backup_tables_'.$sf}); if (!$cmode) { # Run and check before-backup command (for one DB) $temp = &transname(); &open_tempfile(TEMP, ">$temp"); $bok = &execute_before($db, TEMP, 0, $file, $all ? undef : $db); &close_tempfile(TEMP); $err = &read_file_contents($temp); &unlink_file($temp); if (!$bok) { push(@status, [ $db, $file, "Before-backup command failed : $err" ]); $ex = 1; next; } } # Do the backup $err = &backup_database($db, $file, $config{'backup_compress_'.$sf}, $config{'backup_drop_'.$sf}, $config{'backup_where_'.$sf}, $config{'backup_charset_'.$sf}, \@compat, \@tables, "root", $config{'backup_single_'.$sf}, $config{'backup_quick_'.$sf}, undef, $config{'backup_parameters_'.$sf} ); if ($err) { $ex = 1; } @st = stat($file); push(@status, [ $db, $file, $err, $st[7] ]); if (!$cmode) { &execute_after($db, undef, 0, $file, $all ? undef : $db); } } if ($cmode) { &execute_after(undef, undef, 0, $config{'backup_'}, undef); } # Send status email EMAIL: if ($email && ($notify == 0 || $notify == 1 && $ex || $notify == 2 && !$ex) && &foreign_check("mailboxes")) { &foreign_require("mailboxes"); $host = &get_system_hostname(); $msg = $all ? 'backup_allsubject' : 'backup_subject'; $msg .= ($ex ? '_failed' : '_ok'); $subject = &text($msg, $dbs[0], scalar(@dbs) || $text{'backup_bodyall'}, &get_display_hostname()); $data = &text('backup_body', $host, scalar(@dbs) || $text{'backup_bodyall'})."\n\n"; if ($failure) { $data .= $failure."\n"; } $total = 0; foreach $s (@status) { $data .= &text('backup_bodydoing', $s->[0], $s->[1])."\n"; if ($s->[2]) { $data .= &text('backup_bodyfailed', $s->[2]); } else { $data .= &text('backup_bodyok', &nice_size($s->[3])); $total += $s->[3]; } $data .= "\n\n"; } if ($all && $total) { $data .= &text('backup_bodytotal', &nice_size($total))."\n\n"; } if (&foreign_check("mount")) { &foreign_require("mount"); $dir = $status[0]->[1]; while($dir ne "/" && !$total_space) { $dir =~ s/\/[^\/]*$//; $dir = "/" if (!$dir); ($total_space, $free_space) = &mount::disk_space(undef, $dir); } if ($total_space) { $data .= &text('backup_bodyspace', &nice_size($total_space*1024), &nice_size($free_space*1024))."\n\n"; } } &mailboxes::send_text_mail(&mailboxes::get_from_address(), $email, undef, $subject, $data); } exit($ex);
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
help | Folder | 0755 |
|
|
images | Folder | 0755 |
|
|
lang | Folder | 0755 |
|
|
CHANGELOG | File | 8.12 KB | 0644 |
|
acl_security.pl | File | 4.43 KB | 0755 |
|
backup.pl | File | 4.17 KB | 0755 |
|
backup_config.pl | File | 1.01 KB | 0755 |
|
backup_db.cgi | File | 8.07 KB | 0755 |
|
backup_form.cgi | File | 6.78 KB | 0755 |
|
cgi_args.pl | File | 577 B | 0755 |
|
config | File | 522 B | 0644 |
|
config-AlmaLinux-7.0-ALL | File | 418 B | 0644 |
|
config-Amazon-Linux-2-ALL | File | 403 B | 0644 |
|
config-CentOS-Linux-7.0-ALL | File | 418 B | 0644 |
|
config-CentOS-Stream-Linux-8.0-ALL | File | 418 B | 0644 |
|
config-CloudLinux-8.0-ALL | File | 418 B | 0644 |
|
config-Oracle-Linux-8.0-ALL | File | 418 B | 0644 |
|
config-Redhat-Enterprise-Linux-7.0-ALL | File | 418 B | 0644 |
|
config-Rocky-Linux-7.0-ALL | File | 418 B | 0644 |
|
config-Scientific-Linux-7.0-ALL | File | 403 B | 0644 |
|
config-Ubuntu-Linux-16.04-17.99 | File | 453 B | 0644 |
|
config-Ubuntu-Linux-18.04-ALL | File | 420 B | 0644 |
|
config-aix | File | 479 B | 0644 |
|
config-cobalt-linux | File | 417 B | 0644 |
|
config-coherent-linux | File | 419 B | 0644 |
|
config-debian-linux | File | 416 B | 0644 |
|
config-debian-linux-10.0-ALL | File | 420 B | 0644 |
|
config-debian-linux-2.2-9.0 | File | 436 B | 0644 |
|
config-freebsd | File | 479 B | 0644 |
|
config-freebsd-8-ALL | File | 516 B | 0644 |
|
config-gentoo-linux | File | 413 B | 0644 |
|
config-mandrake-linux | File | 399 B | 0644 |
|
config-mandrake-linux-10.1-ALL | File | 401 B | 0644 |
|
config-msc-linux | File | 421 B | 0644 |
|
config-netbsd | File | 431 B | 0644 |
|
config-open-linux | File | 417 B | 0644 |
|
config-openSUSE-Linux-15.0-ALL | File | 403 B | 0644 |
|
config-openmamba-linux | File | 417 B | 0644 |
|
config-pardus-linux | File | 346 B | 0644 |
|
config-redhat-linux | File | 417 B | 0644 |
|
config-redhat-linux-24.0 | File | 421 B | 0644 |
|
config-redhat-linux-25.0-ALL | File | 418 B | 0644 |
|
config-redhat-linux-7.0-23.0 | File | 419 B | 0644 |
|
config-slackware-linux-8.0-ALL | File | 449 B | 0644 |
|
config-sol-linux | File | 455 B | 0644 |
|
config-solaris-10 | File | 440 B | 0644 |
|
config-solaris-11-ALL | File | 490 B | 0644 |
|
config-solaris-9 | File | 498 B | 0644 |
|
config-suse-linux | File | 409 B | 0644 |
|
config-suse-linux-7.1-ALL | File | 407 B | 0644 |
|
config-syno-linux | File | 528 B | 0755 |
|
config-trustix-linux | File | 407 B | 0644 |
|
config-turbo-linux | File | 417 B | 0644 |
|
config-united-linux | File | 407 B | 0644 |
|
config-windows | File | 568 B | 0644 |
|
config.info | File | 1.58 KB | 0644 |
|
config.info.bg | File | 2.74 KB | 0644 |
|
config.info.ca | File | 1.7 KB | 0644 |
|
config.info.cs | File | 1.46 KB | 0644 |
|
config.info.de | File | 1.62 KB | 0644 |
|
config.info.es | File | 813 B | 0644 |
|
config.info.fi | File | 0 B | 0644 |
|
config.info.fr | File | 1.85 KB | 0644 |
|
config.info.hu | File | 1.32 KB | 0644 |
|
config.info.it | File | 1.54 KB | 0644 |
|
config.info.ja | File | 1.7 KB | 0644 |
|
config.info.nl | File | 1.67 KB | 0644 |
|
config.info.no | File | 1.54 KB | 0644 |
|
config.info.pl | File | 808 B | 0644 |
|
config.info.pt_BR | File | 1.68 KB | 0644 |
|
config.info.ru | File | 1.27 KB | 0644 |
|
config.info.sv | File | 677 B | 0644 |
|
config.info.tr | File | 1.13 KB | 0644 |
|
config.info.uk | File | 1.31 KB | 0644 |
|
config.info.zh | File | 320 B | 0644 |
|
config.info.zh_TW | File | 891 B | 0644 |
|
config_info.pl | File | 575 B | 0755 |
|
cpan_modules.pl | File | 84 B | 0755 |
|
create_table.cgi | File | 1.02 KB | 0755 |
|
csv.cgi | File | 2.26 KB | 0755 |
|
csv_form.cgi | File | 1.67 KB | 0755 |
|
defaultacl | File | 85 B | 0644 |
|
delete_cprivs.cgi | File | 1.15 KB | 0755 |
|
delete_dbs.cgi | File | 1.04 KB | 0755 |
|
delete_fields.cgi | File | 665 B | 0755 |
|
delete_hosts.cgi | File | 1018 B | 0755 |
|
delete_tprivs.cgi | File | 1.1 KB | 0755 |
|
delete_users.cgi | File | 941 B | 0755 |
|
download.cgi | File | 1.07 KB | 0755 |
|
drop_dbase.cgi | File | 1.86 KB | 0755 |
|
drop_dbases.cgi | File | 1.39 KB | 0755 |
|
drop_table.cgi | File | 1.27 KB | 0755 |
|
drop_tables.cgi | File | 1.75 KB | 0755 |
|
edit_cnf.cgi | File | 2.92 KB | 0755 |
|
edit_cpriv.cgi | File | 2.34 KB | 0755 |
|
edit_db.cgi | File | 1.73 KB | 0755 |
|
edit_dbase.cgi | File | 6.46 KB | 0755 |
|
edit_field.cgi | File | 4.99 KB | 0755 |
|
edit_host.cgi | File | 1.48 KB | 0755 |
|
edit_index.cgi | File | 1.83 KB | 0755 |
|
edit_manual.cgi | File | 952 B | 0755 |
|
edit_ssl.cgi | File | 1.59 KB | 0755 |
|
edit_table.cgi | File | 2.85 KB | 0755 |
|
edit_tpriv.cgi | File | 2.21 KB | 0755 |
|
edit_user.cgi | File | 4.64 KB | 0755 |
|
edit_view.cgi | File | 2.17 KB | 0755 |
|
exec.cgi | File | 1.53 KB | 0755 |
|
exec_file.cgi | File | 2.48 KB | 0755 |
|
exec_form.cgi | File | 3.63 KB | 0755 |
|
import.cgi | File | 1.99 KB | 0755 |
|
index.cgi | File | 10.83 KB | 0755 |
|
install_check.pl | File | 549 B | 0755 |
|
kill_procs.cgi | File | 385 B | 0755 |
|
list_cprivs.cgi | File | 2.21 KB | 0755 |
|
list_dbs.cgi | File | 1.89 KB | 0755 |
|
list_hosts.cgi | File | 1.76 KB | 0755 |
|
list_procs.cgi | File | 1.42 KB | 0755 |
|
list_tprivs.cgi | File | 2.03 KB | 0755 |
|
list_users.cgi | File | 2.73 KB | 0755 |
|
list_vars.cgi | File | 1.72 KB | 0755 |
|
log_parser.pl | File | 3.25 KB | 0755 |
|
login.cgi | File | 819 B | 0755 |
|
module.info | File | 190 B | 0644 |
|
module.info.af | File | 0 B | 0644 |
|
module.info.af.auto | File | 131 B | 0644 |
|
module.info.ar | File | 0 B | 0644 |
|
module.info.ar.auto | File | 211 B | 0644 |
|
module.info.be | File | 0 B | 0644 |
|
module.info.be.auto | File | 204 B | 0644 |
|
module.info.bg | File | 0 B | 0644 |
|
module.info.bg.auto | File | 215 B | 0644 |
|
module.info.ca | File | 127 B | 0644 |
|
module.info.ca.auto | File | 14 B | 0644 |
|
module.info.cs | File | 34 B | 0644 |
|
module.info.cs.auto | File | 103 B | 0644 |
|
module.info.da | File | 0 B | 0644 |
|
module.info.da.auto | File | 127 B | 0644 |
|
module.info.de | File | 127 B | 0644 |
|
module.info.de.auto | File | 14 B | 0644 |
|
module.info.el | File | 0 B | 0644 |
|
module.info.el.auto | File | 226 B | 0644 |
|
module.info.es | File | 40 B | 0644 |
|
module.info.es.auto | File | 110 B | 0644 |
|
module.info.eu | File | 0 B | 0644 |
|
module.info.eu.auto | File | 134 B | 0644 |
|
module.info.fa | File | 0 B | 0644 |
|
module.info.fa.auto | File | 198 B | 0644 |
|
module.info.fi | File | 0 B | 0644 |
|
module.info.fi.auto | File | 140 B | 0644 |
|
module.info.fr | File | 43 B | 0644 |
|
module.info.fr.auto | File | 138 B | 0644 |
|
module.info.he | File | 0 B | 0644 |
|
module.info.he.auto | File | 167 B | 0644 |
|
module.info.hr | File | 0 B | 0644 |
|
module.info.hr.auto | File | 153 B | 0644 |
|
module.info.hu | File | 35 B | 0644 |
|
module.info.hu.auto | File | 113 B | 0644 |
|
module.info.it | File | 33 B | 0644 |
|
module.info.it.auto | File | 102 B | 0644 |
|
module.info.ja | File | 43 B | 0644 |
|
module.info.ja.auto | File | 128 B | 0644 |
|
module.info.ko | File | 40 B | 0644 |
|
module.info.ko.auto | File | 128 B | 0644 |
|
module.info.lt | File | 0 B | 0644 |
|
module.info.lt.auto | File | 172 B | 0644 |
|
module.info.lv | File | 0 B | 0644 |
|
module.info.lv.auto | File | 133 B | 0644 |
|
module.info.ms | File | 142 B | 0644 |
|
module.info.ms.auto | File | 14 B | 0644 |
|
module.info.mt | File | 0 B | 0644 |
|
module.info.mt.auto | File | 137 B | 0644 |
|
module.info.nl | File | 30 B | 0644 |
|
module.info.nl.auto | File | 98 B | 0644 |
|
module.info.no | File | 29 B | 0644 |
|
module.info.no.auto | File | 98 B | 0644 |
|
module.info.pl | File | 34 B | 0644 |
|
module.info.pl.auto | File | 103 B | 0644 |
|
module.info.pt | File | 40 B | 0644 |
|
module.info.pt.auto | File | 116 B | 0644 |
|
module.info.pt_BR | File | 0 B | 0644 |
|
module.info.pt_BR.auto | File | 166 B | 0644 |
|
module.info.ro | File | 0 B | 0644 |
|
module.info.ro.auto | File | 155 B | 0644 |
|
module.info.ru | File | 47 B | 0644 |
|
module.info.ru.auto | File | 165 B | 0644 |
|
module.info.sk | File | 0 B | 0644 |
|
module.info.sk.auto | File | 141 B | 0644 |
|
module.info.sl | File | 0 B | 0644 |
|
module.info.sl.auto | File | 135 B | 0644 |
|
module.info.sv | File | 28 B | 0644 |
|
module.info.sv.auto | File | 104 B | 0644 |
|
module.info.th | File | 0 B | 0644 |
|
module.info.th.auto | File | 292 B | 0644 |
|
module.info.tr | File | 35 B | 0644 |
|
module.info.tr.auto | File | 110 B | 0644 |
|
module.info.uk | File | 0 B | 0644 |
|
module.info.uk.auto | File | 210 B | 0644 |
|
module.info.ur | File | 0 B | 0644 |
|
module.info.ur.auto | File | 229 B | 0644 |
|
module.info.vi | File | 0 B | 0644 |
|
module.info.vi.auto | File | 184 B | 0644 |
|
module.info.zh | File | 33 B | 0644 |
|
module.info.zh.auto | File | 92 B | 0644 |
|
module.info.zh_TW | File | 36 B | 0644 |
|
module.info.zh_TW.auto | File | 98 B | 0644 |
|
mysql-lib.pl | File | 51.37 KB | 0755 |
|
newdb.cgi | File | 1.07 KB | 0755 |
|
newdb_form.cgi | File | 1.45 KB | 0755 |
|
postinstall.pl | File | 192 B | 0644 |
|
prefs.info | File | 69 B | 0644 |
|
root_form.cgi | File | 855 B | 0755 |
|
save_cnf.cgi | File | 2.83 KB | 0755 |
|
save_cpriv.cgi | File | 2.67 KB | 0755 |
|
save_db.cgi | File | 2.68 KB | 0755 |
|
save_field.cgi | File | 4.72 KB | 0755 |
|
save_host.cgi | File | 2.35 KB | 0755 |
|
save_index.cgi | File | 1.39 KB | 0755 |
|
save_manual.cgi | File | 526 B | 0755 |
|
save_root.cgi | File | 1.04 KB | 0755 |
|
save_ssl.cgi | File | 2.03 KB | 0755 |
|
save_sync.cgi | File | 454 B | 0755 |
|
save_tpriv.cgi | File | 2.6 KB | 0755 |
|
save_user.cgi | File | 4.85 KB | 0755 |
|
save_vars.cgi | File | 755 B | 0755 |
|
save_view.cgi | File | 1.84 KB | 0755 |
|
search_form.cgi | File | 1.38 KB | 0755 |
|
start.cgi | File | 218 B | 0755 |
|
stop.cgi | File | 203 B | 0755 |
|
syslog_logs.pl | File | 1.11 KB | 0755 |
|
table_form.cgi | File | 1.95 KB | 0755 |
|
useradmin_update.pl | File | 2.6 KB | 0755 |
|
view-lib.pl | File | 3.56 KB | 0755 |
|
view_table.cgi | File | 15.06 KB | 0755 |
|