how backup and restore mysql database using ansible

1 min read - https://www.techrunnr.com/how-backup-and-restore-mysql-database-using-ansible/?utm_source=WhatsApp%26utm_medium=IM%26amp;utm_campaign=share%20button" class="wabtn">Share this on WhatsApp

He is Technical professional. He is a person who loves to share tricks and tips on the Internet. He Posts what he does!

Prabhin Prabharkaran Administrator

DevOps Engineer

He is a Technical professional. He is a person who loves to share tricks and tips on the Internet. He Posts what he does!

web

https://www.techrunnr.com

prabhin@techrunnr.com

call

8129739773

Hi All, This document shows you how backup and restore MySQL database using ansible.
Ansible is a Provisioning and configuration management tool which can be used for both Linux and windows platform. Ansible has reached the best place under the best DevOps tools because it is very is easy and simple.
Ansible playbook is written in YAML file which is human readable and understandable which makes ansible popular.

Step 1: Create a YAML file
vi backup-restore.yml

Paste the below contents, explanations are given below.

---
- hosts: cloud-replica
  gather_facts: true
  tasks:
     - name: backup  DB
       mysql_db:
        name: wordpress_db
        state: dump
        target: /opt/backup.sql
        login_host: 192.168.10.22
        login_user: root
        login_password: 'password'
      - name: start the importing
        mysql_db:
         name: restoredb
         state: import
         target: /opt/backup.sql"
         login_host: 192.168.10.2
         login_user: root
         login_password: 'Password'

First task perform DB backup to /opt/backup.sql file of wordpress_db with above mentioned DB username and password where 192.168.10.22 is the DB host.

The second task restore database from /opt/backup.sql to restoredb database with above mentioned DB username and password.