Skip to content
Snippets Groups Projects
Select Git revision
  • 447297ac0d490290ed0a09fb02779349cca178bf
  • master default protected
2 results

sql-backup

  • Clone with SSH
  • Clone with HTTPS
  • user avatar
    root authored
    447297ac
    History

    Logo of the project

    Automated SQL Backup Script

    A simple bash script, to automatically create sql dumps on a daily basis, scheduled by systemd. It comes with a built in mechanism to check and delete old backups.

    Installing / Getting started

    Clone the repository and execute the install script.

    git clone https://git.slub-dresden.de/dbod/sql-backup.git
    cd sql-backup
    sudo bash install.sh
    systemctl enable sql-backup.service

    After the repository is cloned, the install script is executed. The script first checks for repository updates. After that it is copying the systemd service files (.service and .timer) to the systemd path. It then edits the .service file with sed, to properly define the path to the backup script.

    Initial Configuration

    The backup script needs an SQL User, capable to lock and dump the databases, which should be backuped. In the standard configuration, the script trys to backup every single database on the server "localhost", using the user "root" without a password. This will most probably result in an error.

    Developing

    To participate in the development of the project, you just need to clone the repository.

    git clone https://git.slub-dresden.de/dbod/sql-backup.git
    cd sql-backup

    Features

    What's all the bells and whistles this project can perform?

    • What's the main functionality
    • You can also do another thing
    • If you get really randy, you can even do this

    Configuration

    Here you should write what are all of the configurations a user can enter when using the project.

    Argument 1

    Type: String Default: 'default value'

    State what an argument does and how you can use it. If needed, you can provide an example below.

    Example:

    awesome-project "Some other value"  # Prints "You're nailing this readme!"

    Argument 2

    Type: Number|Boolean Default: 100

    Copy-paste as many of these as you need.

    Contributing

    "If you'd like to contribute, please fork the repository and use a feature branch. Pull requests are warmly welcome."

    Links

    Licensing

    "The code in this project is licensed under MIT license."