Ticket #1081 (closed task: fixed)

Opened 3 years ago

Last modified 2 years ago

file name format update for sqlbackup script

Reported by: anonyme Owned by: anonymous
Priority: high Milestone: alternc-0.9.9
Component: Shell-scripts et binaires Version:
Severity: trivial Keywords: sql backup
Cc: informatique-nospam@…

Description

I've patch the sqlbackup.sh script few month ago to change the file name format for sql backup.

Instead of using a "logrotate" format such as file.X.sql, it's possible to include the date of the day in the file name like file.YYYYMMDD.sql

this option is useful when you backup alternc/html with rsync to avoid rsync all backup file after each backup name rotation.

Attachments

sqlbackup.sh (16.5 kB) - added by anonyme 3 years ago.
sqlbackup.sh scripts
sqlbackup.conf (1.3 kB) - added by anonyme 3 years ago.
sqlbackuo conf file

Change History

Changed 3 years ago by anonyme

sqlbackup.sh scripts

Changed 3 years ago by anonyme

sqlbackuo conf file

Changed 2 years ago by anarcat

  • priority changed from normal to high

Changed 2 years ago by anarcat

  • status changed from new to closed
  • resolution set to fixed

(In [2257]) complete rewrite of the sqlbackup.sh script, will be reworked and audited before release

Closes: #1081

Changed 2 years ago by anarcat

(In [2259]) add some of the sqlbackup options to the local.sh global configuration. note that we discarded some suggestions options:

F_LOG: replaced with syslog DAEMON: will be considered for inclusion later VERBOSE/DEBUG: available through command line flags

TYPE_NAME_BACKUP and ALLOW_OVERWRITE_BACKUP are being renamed to SQLBACKUP_TYPE and SQLBACKUP_OVERWRITE. this is to be more consistent with the global configurations

See: #1081

Changed 2 years ago by anarcat

I should also mention commit [2258] which gets rid of the F_LOG option. I will work a bit more on the code now.

Note: See TracTickets for help on using tickets.