You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
35 lines
837 B
35 lines
837 B
#
|
|
# Task: export
|
|
#
|
|
# @author Björn Hase <herrhase@node001.net>
|
|
#
|
|
|
|
- name: name of database for Export
|
|
pause:
|
|
prompt: "Dbname?"
|
|
register: mariadb_dbname
|
|
|
|
- name: locale-Path for SQL-file
|
|
pause:
|
|
prompt: "Locale Path?"
|
|
register: mariadb_sql_path
|
|
|
|
- name: dump SQL from Db to file
|
|
community.mysql.mysql_db:
|
|
state: dump
|
|
name: "{{ mariadb_dbname.user_input }}"
|
|
login_user: "{{ mariadb_admin_user }}"
|
|
login_unix_socket: "{{ mariadb_socket }}"
|
|
target: "/tmp/{{ mariadb_dbname.user_input }}.sql"
|
|
|
|
- name: copy SQL-file from Db-Server to locale
|
|
fetch:
|
|
src: "/tmp/{{ mariadb_dbname.user_input }}.sql"
|
|
dest: "{{ mariadb_sql_path.user_input }}"
|
|
when: mariadb_sql_path.user_input
|
|
|
|
- name: Delete SQL-file from Db-Server
|
|
file:
|
|
path: "/tmp/{{ mariadb_dbname.user_input }}.sql"
|
|
state: absent
|