# MySQL Backup

A basic script to backup mysql instance

## How it work

MySQL backup list your databases.
On each database, MySQL Backup lists tables, dumps schemas and data on two separate files on each tables.

In `databases` folder, you will find the structure for each database and each table.
In `extras` folder, you will find the routine, trigger and event of your database.
In `schemas` folder, you will find each table structure per file.
In `datas` folder, you will find each table data per file.

You need to configure a user with somes permissions like this : 

For all tables : 
```
*.*:SELECT,SHOW VIEW,RELOAD,REPLICATION CLIENT,EVENT,TRIGGER,LOCK TABLES
```
For `sys` table (MariaDB 10.11 on Debian 12) : 
```
sys.*:LOCK TABLES,SHOW VIEW,EXECUTE
```

## How use it ?

Create a backup user with these grants : `SELECT, RELOAD, LOCK TABLES, REPLICATION CLIENT, SHOW VIEW, EVENT, TRIGGER`

Download `mysqlbackup.sh`.
Execute script with good parameters
Take a coffee

```
su - mysqlbackup
cd ~
wget https://git.drycat.fr/Dryusdan/mysql-backup/raw/branch/master/mysqlbackup.sh
chmod +x mysqlbackup.sh
./mysqlbackup.sh /empty/folder/for/mysqldump 7 backup S3c4ET 127.0.0.1
```


| Parameters | Explain |
| -------- | -------- | 
| Folder    | Folder where dumps were stored. This folder must be empty |
| Retention | Time on the day before dropping a dump | 
| Username | Username of you're mysql's backup user |
| Password | Password of you're mysql's backup user |
| Host  | You're MySQL Host. Default is 127.0.0.1 |
| Port  | You're MySQL Port. Default is 3306 |