50 lines
973 B
YAML
50 lines
973 B
YAML
---
|
|
- name: apbase
|
|
hosts: web
|
|
become: yes
|
|
|
|
- name: Installer mariadb
|
|
apt:
|
|
name:
|
|
- mariadb-server
|
|
- python3-PyMySQL
|
|
state: present
|
|
|
|
- name: s'assurer que mariadb est en fonctionnement
|
|
service:
|
|
name: mariadb-server
|
|
state: started
|
|
|
|
- name: Creer un utilisateur 'admin' lui attribuer tous les droits
|
|
community.mysql.mysql_user:
|
|
name: admin
|
|
password: admin
|
|
priv: '*.*:ALL'
|
|
state: present
|
|
|
|
- name: Creation de la base de donnee 'sdis2023'
|
|
mysql_db:
|
|
name: sdis2023
|
|
state: present
|
|
|
|
# Copy database dump file to remote host and restore it to database 'sdis2023'
|
|
- name: Copie du dump de la BDD
|
|
copy:
|
|
src: sdis2023.sql
|
|
dest: /tmp/
|
|
|
|
- name: Restore database
|
|
community.mysql.mysql_db:
|
|
name: sdis2023
|
|
state: import
|
|
target: /tmp/sdis2023
|
|
|
|
#- name: Restore d
|
|
#community.mysql.mysql_db:
|
|
#name: my_db
|
|
#state: import
|
|
#target: /tmp/dump.sql.bz2
|
|
#force: true
|
|
|
|
|