---
- name: MySQL Database Migration
  hosts: all
  become: yes
  vars:
    mysql_user: 'root'
    mysql_password: 'your_password'
    mysql_host: 'localhost'
    mysql_port: '3306'
    mysql_database: 'your_database'

  tasks:
    - name: Create database if not exists
      mysql_db:
        name: "{{ mysql_database }}"
        state: present

    - name: Dump MySQL database
      command: mysqldump -u {{ mysql_user }} -p{{ mysql_password }} -h {{ mysql_host }} -P {{ mysql_port }} {{ mysql_database }} > /tmp/{{ mysql_database }}.sql

    - name: Copy dump file to target server
      copy:
        src: /tmp/{{ mysql_database }}.sql
        dest: /tmp/{{ mysql_database }}.sql
        owner: root
        group: root
        mode: '0644'

    - name: Import MySQL database on target server
      command: mysql -u {{ mysql_user }} -p{{ mysql_password }} -h {{ mysql_host }} -P {{ mysql_port }} {{ mysql_database }} < /tmp/{{ mysql_database }}.sql