Compare commits
10 Commits
pkg/stable
...
144375c761
Author | SHA1 | Date | |
---|---|---|---|
144375c761 | |||
fc706a56e7 | |||
b1bcd05792 | |||
b3b39fc4a4 | |||
efc3f5848c | |||
d34670a998 | |||
2f5f17adc4 | |||
d19bfdebf9 | |||
a199b9182d | |||
d87c9ee307 |
2
debian/control
vendored
2
debian/control
vendored
@ -10,7 +10,7 @@ Vcs-Browser: https://forge.cadoles.com/Cadoles/eole-mariadb
|
|||||||
|
|
||||||
Package: eole-mariadb
|
Package: eole-mariadb
|
||||||
Architecture: all
|
Architecture: all
|
||||||
Depends: ${misc:Depends}, mariadb-server
|
Depends: ${misc:Depends}, mariadb-server, mariadb-backup
|
||||||
Conflicts: eole-mysql
|
Conflicts: eole-mysql
|
||||||
Provides: eole-mysql
|
Provides: eole-mysql
|
||||||
Description: Dictionnaires et templates pour la configuration d'un serveur MariaDB, testée uniquement avec eolebase
|
Description: Dictionnaires et templates pour la configuration d'un serveur MariaDB, testée uniquement avec eolebase
|
||||||
|
27
schedule/scripts/mariadb
Normal file
27
schedule/scripts/mariadb
Normal file
@ -0,0 +1,27 @@
|
|||||||
|
#!/bin/bash
|
||||||
|
|
||||||
|
set -e
|
||||||
|
|
||||||
|
DESC="Exportation des bases MariaDB"
|
||||||
|
|
||||||
|
. /usr/share/eole/schedule/config.sh
|
||||||
|
|
||||||
|
MYSQLSAVDIR=$SAVDIR/sql
|
||||||
|
OPTION="--lock-tables"
|
||||||
|
|
||||||
|
rm -f $MYSQLSAVDIR/*.sql || true
|
||||||
|
mkdir -p $MYSQLSAVDIR
|
||||||
|
|
||||||
|
DATABASES=$(mysql --defaults-file=/etc/mysql/debian.cnf -e 'show databases' | grep -v '^Database$')
|
||||||
|
for databasename in $DATABASES; do
|
||||||
|
case "$databasename" in
|
||||||
|
information_schema|performance_schema|bareos)
|
||||||
|
continue
|
||||||
|
;;
|
||||||
|
*)
|
||||||
|
mysqldump --defaults-file=/etc/mysql/debian.cnf --databases $databasename --flush-privileges --create-options -Q -c $OPTION > $MYSQLSAVDIR/$databasename.sql
|
||||||
|
;;
|
||||||
|
esac
|
||||||
|
done
|
||||||
|
|
||||||
|
exit 0
|
@ -1,7 +0,0 @@
|
|||||||
# Configuration commune aux scripts schedule
|
|
||||||
# Configuration de base modifiée pour copier dans le partage nfs plutôt que /home
|
|
||||||
|
|
||||||
SAVDIR=/mnt/sauvegardes/
|
|
||||||
# pour que l'affichage de [ ok ] soit ok
|
|
||||||
export TERM='dumb'
|
|
||||||
umask 0077
|
|
@ -1,27 +0,0 @@
|
|||||||
#!/bin/bash
|
|
||||||
|
|
||||||
set -e
|
|
||||||
|
|
||||||
DESC="Exportation des bases MariaDB"
|
|
||||||
|
|
||||||
. /usr/share/eole/schedule/config.sh
|
|
||||||
|
|
||||||
MYSQLSAVDIR=$SAVDIR/sql
|
|
||||||
OPTION="--lock-tables"
|
|
||||||
|
|
||||||
rm -f $MYSQLSAVDIR/*.sql
|
|
||||||
mkdir -p $MYSQLSAVDIR
|
|
||||||
|
|
||||||
CMD="mysql --defaults-file=/etc/mysql/mariadbBackup.cnf -e 'show databases' | grep -v '^Database$'"
|
|
||||||
DATABASES=$(CreoleRun "$CMD" mysql)
|
|
||||||
for databasename in $DATABASES; do
|
|
||||||
case "$databasename" in
|
|
||||||
information_schema|performance_schema|bareos)
|
|
||||||
continue
|
|
||||||
;;
|
|
||||||
*)
|
|
||||||
CMD="mysqldump --defaults-file=/etc/mysql/mariadbBackup.cnf --databases $databasename --flush-privileges --create-options -Q -c $OPTION 2>/dev/null"
|
|
||||||
CreoleRun "$CMD" mysql > $MYSQLSAVDIR/$databasename.sql
|
|
||||||
;;
|
|
||||||
esac
|
|
||||||
done
|
|
Reference in New Issue
Block a user