projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
backup the schema for tables we don't need the data from. RT#85959
[freeside.git]
/
FS
/
FS
/
Cron
/
backup.pm
diff --git
a/FS/FS/Cron/backup.pm
b/FS/FS/Cron/backup.pm
index
5276565
..
65d7acb
100644
(file)
--- a/
FS/FS/Cron/backup.pm
+++ b/
FS/FS/Cron/backup.pm
@@
-25,7
+25,11
@@
sub backup {
my $ext;
if ( driver_name eq 'Pg' ) {
my $ext;
if ( driver_name eq 'Pg' ) {
- system("pg_dump -Fc -T h_cdr -T h_queue -T h_queue_arg $database >/var/tmp/$database.Pg");
+ system('pg_dump -Fc '. join(' ', map { "--exclude-table-data $_" }
+ qw( h_cdr h_queue h_queue_arg sessions )
+ ).
+ " $database >/var/tmp/$database.Pg"
+ );
$ext = 'Pg';
} elsif ( driver_name eq 'mysql' ) {
system("mysqldump $database >/var/tmp/$database.sql");
$ext = 'Pg';
} elsif ( driver_name eq 'mysql' ) {
system("mysqldump $database >/var/tmp/$database.sql");