Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15075

mariabackup with specified --host option does not backup data from remote MariaDB Server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.2.12
    • Fix Version/s: 10.2
    • Component/s: Backup
    • Labels:
    • Environment:
      CentOS 7.4

      Description

      mariabackup with specified --host option does not backup data from remote MariaDB Server

      expected :
      backup data from remote MariaDB Server via mariabackup --host option

      how to repeat :
      1.backup data of remote MariaDB Server t4w6 using mariabackup --host option
      2.check the content of the backup-ed data – although the backup started with message
      "Connecting to MySQL server host: t4w6" , it's done local backup

      note: the same occurs if specify the ip address of the remote MariaDB Server,
      backup is starting with message " Connecting to MySQL server host: 192.168.104.196, user: root, passwor..." , but it's done local backup

      1

      [root@t4w3 mariadb]# mariabackup --host=t4w6 -u root --backup --history=ccc   --target-dir=/var/mariadb/backupRw6
      180125 19:19:27 Connecting to MySQL server host: t4w6, user: root, password: not set, port: not set, socket: not set
      Using server version 10.2.12-MariaDB
      mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
      mariabackup: uses posix_fadvise().
      mariabackup: cd to /var/lib/mysql/
      mariabackup: open files limit requested 0, set to 1024
      mariabackup: using the following InnoDB configuration:
      mariabackup:   innodb_data_home_dir = .
      mariabackup:   innodb_data_file_path = ibdata1:12M:autoextend
      mariabackup:   innodb_log_group_home_dir = ./
      2018-01-25 19:19:27 139836746336384 [Note] InnoDB: Number of pools: 1
      mariabackup: Can't create/write to file '/var/mariadb/backupRw6/ib_logfile0' (Errcode: 17 "File exists")
      mariabackup: error: failed to open the target stream for 'ib_logfile0'.
      [root@t4w3 mariadb]# mariabackup --host=t4w6 -u root --backup --history=ccc   --target-dir=/var/mariadb/backupR4w6
      180125 19:19:45 Connecting to MySQL server host: t4w6, user: root, password: not set, port: not set, socket: not set
      Using server version 10.2.12-MariaDB
      mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
      mariabackup: uses posix_fadvise().
      mariabackup: cd to /var/lib/mysql/
      mariabackup: open files limit requested 0, set to 1024
      mariabackup: using the following InnoDB configuration:
      mariabackup:   innodb_data_home_dir = .
      mariabackup:   innodb_data_file_path = ibdata1:12M:autoextend
      mariabackup:   innodb_log_group_home_dir = ./
      2018-01-25 19:19:45 140481951557760 [Note] InnoDB: Number of pools: 1
      180125 19:19:45 >> log scanned up to (1041449671)
      mariabackup: Generating a list of tablespaces
      2018-01-25 19:19:45 140481951557760 [Warning] InnoDB: Allocated tablespace ID 3 for mysql/gtid_slave_pos, old maximum was 0
      180125 19:19:46 [01] Copying ./ibdata1 to /var/mariadb/backupR4w6/ibdata1
      180125 19:19:46 >> log scanned up to (1041449671)
      180125 19:19:48 [01]        ...done
      180125 19:19:48 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/mariadb/backupR4w6/mysql/gtid_slave_pos.ibd
      180125 19:19:48 [01]        ...done
      180125 19:19:48 [01] Copying ./mysql/innodb_index_stats.ibd to /var/mariadb/backupR4w6/mysql/innodb_index_stats.ibd
      180125 19:19:48 [01]        ...done
      180125 19:19:48 [01] Copying ./mysql/innodb_table_stats.ibd to /var/mariadb/backupR4w6/mysql/innodb_table_stats.ibd
      180125 19:19:48 [01]        ...done
      180125 19:19:48 [01] Copying ./boxoffice_mdb/dim_showtime.ibd to /var/mariadb/backupR4w6/boxoffice_mdb/dim_showtime.ibd
      180125 19:19:50 [01]        ...done
      180125 19:19:50 [01] Copying ./boxoffice_mdb/fact_tickets.ibd to /var/mariadb/backupR4w6/boxoffice_mdb/fact_tickets.ibd
      180125 19:19:56 [01]        ...done
      180125 19:19:56 [01] Copying ./PERCONA_SCHEMA/xtrabackup_history.ibd to /var/mariadb/backupR4w6/PERCONA_SCHEMA/xtrabackup_history.ibd
      180125 19:19:56 [01]        ...done
      180125 19:19:57 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
      180125 19:19:57 Executing FLUSH TABLES WITH READ LOCK...
      180125 19:19:57 Starting to backup non-InnoDB tables and files
      180125 19:19:57 [01] Copying ./mysql/roles_mapping.MYI to /var/mariadb/backupR4w6/mysql/roles_mapping.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/column_stats.MYD to /var/mariadb/backupR4w6/mysql/column_stats.MYD
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/table_stats.MYI to /var/mariadb/backupR4w6/mysql/table_stats.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/column_stats.MYI to /var/mariadb/backupR4w6/mysql/column_stats.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/table_stats.frm to /var/mariadb/backupR4w6/mysql/table_stats.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/column_stats.frm to /var/mariadb/backupR4w6/mysql/column_stats.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/procs_priv.MYI to /var/mariadb/backupR4w6/mysql/procs_priv.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/func.MYD to /var/mariadb/backupR4w6/mysql/func.MYD
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/columns_priv.MYI to /var/mariadb/backupR4w6/mysql/columns_priv.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/func.frm to /var/mariadb/backupR4w6/mysql/func.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/db.frm to /var/mariadb/backupR4w6/mysql/db.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/event.frm to /var/mariadb/backupR4w6/mysql/event.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/host.MYD to /var/mariadb/backupR4w6/mysql/host.MYD
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/user.MYI to /var/mariadb/backupR4w6/mysql/user.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/procs_priv.frm to /var/mariadb/backupR4w6/mysql/procs_priv.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/user.MYD to /var/mariadb/backupR4w6/mysql/user.MYD
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone.MYD to /var/mariadb/backupR4w6/mysql/time_zone.MYD
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/general_log.CSM to /var/mariadb/backupR4w6/mysql/general_log.CSM
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone.MYI to /var/mariadb/backupR4w6/mysql/time_zone.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/general_log.CSV to /var/mariadb/backupR4w6/mysql/general_log.CSV
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone.frm to /var/mariadb/backupR4w6/mysql/time_zone.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/general_log.frm to /var/mariadb/backupR4w6/mysql/general_log.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/mariadb/backupR4w6/mysql/time_zone_leap_second.MYD
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/gtid_slave_pos.frm to /var/mariadb/backupR4w6/mysql/gtid_slave_pos.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/mariadb/backupR4w6/mysql/time_zone_leap_second.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone_leap_second.frm to /var/mariadb/backupR4w6/mysql/time_zone_leap_second.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/help_category.MYD to /var/mariadb/backupR4w6/mysql/help_category.MYD
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone_name.MYD to /var/mariadb/backupR4w6/mysql/time_zone_name.MYD
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/help_category.MYI to /var/mariadb/backupR4w6/mysql/help_category.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone_name.MYI to /var/mariadb/backupR4w6/mysql/time_zone_name.MYI
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/help_category.frm to /var/mariadb/backupR4w6/mysql/help_category.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/time_zone_name.frm to /var/mariadb/backupR4w6/mysql/time_zone_name.frm
      180125 19:19:57 [01]        ...done
      180125 19:19:57 [01] Copying ./mysql/help_keyword.MYD to /var/mariadb/backupR4w6/mysql/help_keyword.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/time_zone_transition.MYD to /var/mariadb/backupR4w6/mysql/time_zone_transition.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/help_keyword.MYI to /var/mariadb/backupR4w6/mysql/help_keyword.MYI
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/time_zone_transition.MYI to /var/mariadb/backupR4w6/mysql/time_zone_transition.MYI
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/help_keyword.frm to /var/mariadb/backupR4w6/mysql/help_keyword.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/time_zone_transition.frm to /var/mariadb/backupR4w6/mysql/time_zone_transition.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/help_relation.MYD to /var/mariadb/backupR4w6/mysql/help_relation.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/help_relation.MYI to /var/mariadb/backupR4w6/mysql/help_relation.MYI
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/help_relation.frm to /var/mariadb/backupR4w6/mysql/help_relation.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/help_topic.MYD to /var/mariadb/backupR4w6/mysql/help_topic.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/help_topic.MYI to /var/mariadb/backupR4w6/mysql/help_topic.MYI
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/help_topic.frm to /var/mariadb/backupR4w6/mysql/help_topic.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/user.frm to /var/mariadb/backupR4w6/mysql/user.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/host.frm to /var/mariadb/backupR4w6/mysql/host.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/index_stats.MYD to /var/mariadb/backupR4w6/mysql/index_stats.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/index_stats.MYI to /var/mariadb/backupR4w6/mysql/index_stats.MYI
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/index_stats.frm to /var/mariadb/backupR4w6/mysql/index_stats.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/mariadb/backupR4w6/mysql/time_zone_transition_type.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/innodb_index_stats.frm to /var/mariadb/backupR4w6/mysql/innodb_index_stats.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/proxies_priv.MYI to /var/mariadb/backupR4w6/mysql/proxies_priv.MYI
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/proxies_priv.frm to /var/mariadb/backupR4w6/mysql/proxies_priv.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/innodb_table_stats.frm to /var/mariadb/backupR4w6/mysql/innodb_table_stats.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/roles_mapping.MYD to /var/mariadb/backupR4w6/mysql/roles_mapping.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/plugin.MYI to /var/mariadb/backupR4w6/mysql/plugin.MYI
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/proc.MYD to /var/mariadb/backupR4w6/mysql/proc.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/proc.MYI to /var/mariadb/backupR4w6/mysql/proc.MYI
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/proc.frm to /var/mariadb/backupR4w6/mysql/proc.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/proxies_priv.MYD to /var/mariadb/backupR4w6/mysql/proxies_priv.MYD
      180125 19:19:58 [01]        ...done
      180125 19:19:58 [01] Copying ./mysql/roles_mapping.frm to /var/mariadb/backupR4w6/mysql/roles_mapping.frm
      180125 19:19:58 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/servers.MYD to /var/mariadb/backupR4w6/mysql/servers.MYD
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/servers.MYI to /var/mariadb/backupR4w6/mysql/servers.MYI
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/servers.frm to /var/mariadb/backupR4w6/mysql/servers.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/slow_log.CSM to /var/mariadb/backupR4w6/mysql/slow_log.CSM
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/slow_log.CSV to /var/mariadb/backupR4w6/mysql/slow_log.CSV
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/slow_log.frm to /var/mariadb/backupR4w6/mysql/slow_log.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/table_stats.MYD to /var/mariadb/backupR4w6/mysql/table_stats.MYD
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/mariadb/backupR4w6/mysql/time_zone_transition_type.MYI
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/time_zone_transition_type.frm to /var/mariadb/backupR4w6/mysql/time_zone_transition_type.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/tables_priv.MYD to /var/mariadb/backupR4w6/mysql/tables_priv.MYD
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/tables_priv.frm to /var/mariadb/backupR4w6/mysql/tables_priv.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/columns_priv.MYD to /var/mariadb/backupR4w6/mysql/columns_priv.MYD
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/plugin.MYD to /var/mariadb/backupR4w6/mysql/plugin.MYD
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/event.MYD to /var/mariadb/backupR4w6/mysql/event.MYD
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/host.MYI to /var/mariadb/backupR4w6/mysql/host.MYI
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/columns_priv.frm to /var/mariadb/backupR4w6/mysql/columns_priv.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/plugin.frm to /var/mariadb/backupR4w6/mysql/plugin.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/event.MYI to /var/mariadb/backupR4w6/mysql/event.MYI
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/tables_priv.MYI to /var/mariadb/backupR4w6/mysql/tables_priv.MYI
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/procs_priv.MYD to /var/mariadb/backupR4w6/mysql/procs_priv.MYD
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/db.MYI to /var/mariadb/backupR4w6/mysql/db.MYI
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/db.MYD to /var/mariadb/backupR4w6/mysql/db.MYD
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./mysql/func.MYI to /var/mariadb/backupR4w6/mysql/func.MYI
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./boxoffice_mdb/db.opt to /var/mariadb/backupR4w6/boxoffice_mdb/db.opt
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./boxoffice_mdb/dim_showtime.frm to /var/mariadb/backupR4w6/boxoffice_mdb/dim_showtime.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./boxoffice_mdb/fact_tickets.frm to /var/mariadb/backupR4w6/boxoffice_mdb/fact_tickets.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./test/db.opt to /var/mariadb/backupR4w6/test/db.opt
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./performance_schema/db.opt to /var/mariadb/backupR4w6/performance_schema/db.opt
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./PERCONA_SCHEMA/db.opt to /var/mariadb/backupR4w6/PERCONA_SCHEMA/db.opt
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying ./PERCONA_SCHEMA/xtrabackup_history.frm to /var/mariadb/backupR4w6/PERCONA_SCHEMA/xtrabackup_history.frm
      180125 19:19:59 [01]        ...done
      180125 19:19:59 Finished backing up non-InnoDB tables and files
      180125 19:19:59 [01] Copying aria_log.00000001 to /var/mariadb/backupR4w6/aria_log.00000001
      180125 19:19:59 [01]        ...done
      180125 19:19:59 [01] Copying aria_log_control to /var/mariadb/backupR4w6/aria_log_control
      180125 19:19:59 [01]        ...done
      180125 19:19:59 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
      mariabackup: The latest check point (for incremental): '1041449608'
      mariabackup: Stopping log copying thread.
       
      180125 19:19:59 >> log scanned up to (1041449671)
      180125 19:19:59 Executing UNLOCK TABLES
      180125 19:19:59 All tables unlocked
      180125 19:19:59 [00] Copying ib_buffer_pool to /var/mariadb/backupR4w6/ib_buffer_pool
      180125 19:19:59 [00]        ...done
      180125 19:20:00 Backup created in directory '/var/mariadb/backupR4w6/'
      180125 19:20:00 [00] Writing backup-my.cnf
      180125 19:20:00 [00]        ...done
      180125 19:20:00 [00] Writing xtrabackup_info
      180125 19:20:00 [00]        ...done
      mariabackup: Redo log (from LSN 1041449662 to 1041449671) was copied.
      180125 19:20:00 completed OK!
      

      [root@t4w3 mariadb]# ls /var/mariadb/backupR4w6
      aria_log.00000001  backup-my.cnf  ib_buffer_pool  ib_logfile0  PERCONA_SCHEMA      test                    xtrabackup_info
      aria_log_control   boxoffice_mdb  ibdata1         mysql        performance_schema  xtrabackup_checkpoints
       
      [root@t4w3 mariadb]# ls /var/mariadb/backupR4w6/boxoffice_mdb/
      db.opt  dim_showtime.frm  dim_showtime.ibd  fact_tickets.frm  fact_tickets.ibd
      

      2 .check the content of the backuped data – although the backup started with message
      "Connecting to MySQL server host: t4w6" , it's done local backup

      2

      [root@t4w3 mariadb]# ls /var/mariadb/backupR4w6/boxoffice_mdb/
      db.opt  dim_showtime.frm  dim_showtime.ibd  fact_tickets.frm  fact_tickets.ibd
      

      [root@t4w3 mariadb]# mysql -h t4w6 -u root
      Welcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 339
      Server version: 10.2.12-MariaDB MariaDB Server
       
      Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
       
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> show tables from boxoffice_mdb  ;
      +-------------------------+
      | Tables_in_boxoffice_mdb |
      +-------------------------+
      | dim_showtime            |
      | dim_theater             |
      | dim_theater_mdc         |
      | dim_ticket_type         |
      | dim_title               |
      | fact_tickets            |
      +-------------------------+
      6 rows in set (0.00 sec)
      

      note: the same occurs of specify the ip address of the MariaDB Server,
      backup is starting with message " Connecting to MySQL server host: 192.168.104.196, user: root, passwor..." , but it's done local backup

      mariabackup --host=192.168.104.196 -u root --backup --history=ccc   --target-dir=/var/mariadb/backupRt4w6
      180125 19:21:26 Connecting to MySQL server host: 192.168.104.196, user: root, password: not set, port: not set, socket: not set
      Using server version 10.2.12-MariaDB
      mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
      ~~~~~~
      [root@t4w3 mariadb]# ls /var/mariadb/backupRt4w6/boxoffice_mdb/
      db.opt  dim_showtime.frm  dim_showtime.ibd  fact_tickets.frm  fact_tickets.ibd
      

        Attachments

          Activity

            People

            Assignee:
            vlad.lesin Vladislav Lesin
            Reporter:
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            3 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.