Backup your MySQL / MariaDB server ( structure, data, users, grants, views, triggers, routines, events )
curl -L -# -o sql-backup.zip https://github.com/code-lts/sql-backup/archive/refs/tags/v1.2.0.zipunzip sql-backup.zipcd sql-backup-1.2.0/cp .env.dist .envnano .envvi .envExecute this command to start the backup !
./backup.shTo use an external env file in a custom location, example :
export BACKUP_CONFIG_ENVFILE="/home/myuser/secretbackupconfig.env.txt"
./backup.sh
unset BACKUP_CONFIG_ENVFILEYou can use the variables of the env file in the ON_SUCCESS variable, example :
ON_SUCCESS="${BACKUP_DIR}/onsuccessscript.sh"| NAME | DEFAULT VALUE | OPTIONAL |
|---|---|---|
| BACKUP_DIR | NO | |
| MYSQL_HOST | NO | |
| MYSQL_USER | NO | |
| MYSQL_PASS | YES | |
| MYSQL_PORT | 3306 | YES |
| SKIP_DATABASES | YES | |
| EXPERT_ARGS | --default-character-set=utf8 --extended-insert=FALSE --single-transaction --skip-comments --skip-dump-date --hex-blob --tz-utc | YES |
| ON_SUCCESS | YES | |
| SKIP_OP | YES |
ON_SUCCESS is called on script success
BACKUP_DIR=/sql_backup
MYSQL_HOST=localhost
MYSQL_USER=root
MYSQL_PASS=root
MYSQL_PORT=3306
SKIP_DATABASES=mysql,sys,information_schema,performance_schema,phpmyadmin
SKIP_OP=users,grants| NAME | DESCRIPTION |
|---|---|
| database.sql | All the data |
| structure.sql | The structure of the databases and tables |
| grants.sql | The grants for all users except root |
| events.sql | The scheduled events |
| views.sql | The views |
| triggers.sql | The triggers |
| routines.sql | All the procedures & functions |
| users.sql | All MySQL users |
