A. Backup with mariabackup
1. install mariabackup
yum install -y MariaDB-backup -y
2. check data before testing
select * from teguhth.barang;
select * from teguhth.pembelian;
3. backup full database
# disable & cron optional
# systemctl stop crond
mariabackup --backup --target-dir=/backup --user=admin --password=admin
log
[root@teguhth ~]# mariabackup --backup --target-dir=/backup --user=admin --password=admin
mariabackup: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-backup' instead
[00] 2024-02-23 16:31:32 Connecting to MariaDB server host: localhost, user: admin, password: set, port: not set, socket: not set
[00] 2024-02-23 16:31:32 Using server version 11.1.4-MariaDB-log
mariabackup based on MariaDB server 11.1.4-MariaDB Linux (x86_64)
[00] 2024-02-23 16:31:32 uses posix_fadvise().
[00] 2024-02-23 16:31:32 cd to /var/lib/mysql/
[00] 2024-02-23 16:31:32 open files limit requested 0, set to 1024
[00] 2024-02-23 16:31:32 mariabackup: using the following InnoDB configuration:
[00] 2024-02-23 16:31:32 innodb_data_home_dir =
[00] 2024-02-23 16:31:32 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2024-02-23 16:31:32 innodb_log_group_home_dir = ./
[00] 2024-02-23 16:31:32 InnoDB: Using Linux native AIO
2024-02-23 16:31:32 0 [Note] InnoDB: Number of transaction pools: 1
2024-02-23 16:31:32 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
[00] 2024-02-23 16:31:32 mariabackup: Generating a list of tablespaces
[01] 2024-02-23 16:31:33 Copying .//undo001 to /backup/undo001
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying .//undo002 to /backup/undo002
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying .//undo003 to /backup/undo003
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./mysql/innodb_table_stats.ibd to /backup/mysql/innodb_table_stats.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./mysql/innodb_index_stats.ibd to /backup/mysql/innodb_index_stats.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./mysql/transaction_registry.ibd to /backup/mysql/transaction_registry.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./mysql/gtid_slave_pos.ibd to /backup/mysql/gtid_slave_pos.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth/barang.ibd to /backup/teguhth/barang.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth/suplier.ibd to /backup/teguhth/suplier.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth/customer.ibd to /backup/teguhth/customer.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth/pasok.ibd to /backup/teguhth/pasok.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth/pembelian.ibd to /backup/teguhth/pembelian.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth_maria_dwh/barang.ibd to /backup/teguhth_maria_dwh/barang.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth_maria_dwh/suplier.ibd to /backup/teguhth_maria_dwh/suplier.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth_maria_dwh/customer.ibd to /backup/teguhth_maria_dwh/customer.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth_maria_dwh/pasok.ibd to /backup/teguhth_maria_dwh/pasok.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhth_maria_dwh/pembelian.ibd to /backup/teguhth_maria_dwh/pembelian.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./dbsf_nbc_teguhdb/barang.ibd to /backup/dbsf_nbc_teguhdb/barang.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./dbsf_nbc_teguhdb/customer.ibd to /backup/dbsf_nbc_teguhdb/customer.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./dbsf_nbc_teguhdb/pasok.ibd to /backup/dbsf_nbc_teguhdb/pasok.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./dbsf_nbc_teguhdb/pembelian.ibd to /backup/dbsf_nbc_teguhdb/pembelian.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./dbsf_nbc_teguhdb/suplier.ibd to /backup/dbsf_nbc_teguhdb/suplier.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ./teguhdb/barang.ibd to /backup/teguhdb/barang.ibd
[01] 2024-02-23 16:31:33 ...done
[01] 2024-02-23 16:31:33 Copying ibdata1 to /backup/ibdata1
[01] 2024-02-23 16:31:33 ...done
[00] 2024-02-23 16:31:34 Acquiring BACKUP LOCKS...
[00] 2024-02-23 16:31:34 Starting to backup non-InnoDB tables and files
[01] 2024-02-23 16:31:34 Copying ./mysql/db.opt to /backup/mysql/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/db.frm to /backup/mysql/db.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/db.MAI to /backup/mysql/db.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/db.MAD to /backup/mysql/db.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/global_priv.frm to /backup/mysql/global_priv.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/global_priv.MAI to /backup/mysql/global_priv.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/global_priv.MAD to /backup/mysql/global_priv.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/user.frm to /backup/mysql/user.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/roles_mapping.frm to /backup/mysql/roles_mapping.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/roles_mapping.MAI to /backup/mysql/roles_mapping.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/roles_mapping.MAD to /backup/mysql/roles_mapping.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/func.frm to /backup/mysql/func.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/func.MAI to /backup/mysql/func.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/func.MAD to /backup/mysql/func.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/plugin.frm to /backup/mysql/plugin.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/plugin.MAI to /backup/mysql/plugin.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/plugin.MAD to /backup/mysql/plugin.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/servers.frm to /backup/mysql/servers.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/servers.MAI to /backup/mysql/servers.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/servers.MAD to /backup/mysql/servers.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/tables_priv.frm to /backup/mysql/tables_priv.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/tables_priv.MAI to /backup/mysql/tables_priv.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/tables_priv.MAD to /backup/mysql/tables_priv.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/columns_priv.frm to /backup/mysql/columns_priv.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/columns_priv.MAI to /backup/mysql/columns_priv.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/columns_priv.MAD to /backup/mysql/columns_priv.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_topic.frm to /backup/mysql/help_topic.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_topic.MAI to /backup/mysql/help_topic.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_topic.MAD to /backup/mysql/help_topic.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_category.frm to /backup/mysql/help_category.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_category.MAI to /backup/mysql/help_category.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_category.MAD to /backup/mysql/help_category.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_relation.frm to /backup/mysql/help_relation.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_relation.MAI to /backup/mysql/help_relation.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_relation.MAD to /backup/mysql/help_relation.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_keyword.frm to /backup/mysql/help_keyword.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_keyword.MAI to /backup/mysql/help_keyword.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/help_keyword.MAD to /backup/mysql/help_keyword.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_name.frm to /backup/mysql/time_zone_name.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_name.MAI to /backup/mysql/time_zone_name.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_name.MAD to /backup/mysql/time_zone_name.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone.frm to /backup/mysql/time_zone.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone.MAI to /backup/mysql/time_zone.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone.MAD to /backup/mysql/time_zone.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_transition.frm to /backup/mysql/time_zone_transition.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_transition.MAI to /backup/mysql/time_zone_transition.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_transition.MAD to /backup/mysql/time_zone_transition.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_transition_type.frm to /backup/mysql/time_zone_transition_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_transition_type.MAI to /backup/mysql/time_zone_transition_type.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_transition_type.MAD to /backup/mysql/time_zone_transition_type.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_leap_second.frm to /backup/mysql/time_zone_leap_second.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_leap_second.MAI to /backup/mysql/time_zone_leap_second.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/time_zone_leap_second.MAD to /backup/mysql/time_zone_leap_second.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/proc.frm to /backup/mysql/proc.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/proc.MAI to /backup/mysql/proc.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/proc.MAD to /backup/mysql/proc.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/procs_priv.frm to /backup/mysql/procs_priv.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/procs_priv.MAI to /backup/mysql/procs_priv.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/procs_priv.MAD to /backup/mysql/procs_priv.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/general_log.frm to /backup/mysql/general_log.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/general_log.CSM to /backup/mysql/general_log.CSM
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/general_log.CSV to /backup/mysql/general_log.CSV
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/slow_log.frm to /backup/mysql/slow_log.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/slow_log.CSM to /backup/mysql/slow_log.CSM
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/slow_log.CSV to /backup/mysql/slow_log.CSV
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/event.frm to /backup/mysql/event.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/event.MAI to /backup/mysql/event.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/event.MAD to /backup/mysql/event.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/innodb_table_stats.frm to /backup/mysql/innodb_table_stats.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/innodb_index_stats.frm to /backup/mysql/innodb_index_stats.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/transaction_registry.frm to /backup/mysql/transaction_registry.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/proxies_priv.frm to /backup/mysql/proxies_priv.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/proxies_priv.MAI to /backup/mysql/proxies_priv.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/proxies_priv.MAD to /backup/mysql/proxies_priv.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/table_stats.frm to /backup/mysql/table_stats.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/table_stats.MAI to /backup/mysql/table_stats.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/table_stats.MAD to /backup/mysql/table_stats.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/column_stats.frm to /backup/mysql/column_stats.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/column_stats.MAI to /backup/mysql/column_stats.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/column_stats.MAD to /backup/mysql/column_stats.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/index_stats.frm to /backup/mysql/index_stats.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/index_stats.MAI to /backup/mysql/index_stats.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/index_stats.MAD to /backup/mysql/index_stats.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./mysql/gtid_slave_pos.frm to /backup/mysql/gtid_slave_pos.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth/db.opt to /backup/teguhth/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth/barang.frm to /backup/teguhth/barang.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth/suplier.frm to /backup/teguhth/suplier.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth/customer.frm to /backup/teguhth/customer.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth/pasok.frm to /backup/teguhth/pasok.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth/pembelian.frm to /backup/teguhth/pembelian.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth_maria_dwh/db.opt to /backup/teguhth_maria_dwh/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth_maria_dwh/barang.frm to /backup/teguhth_maria_dwh/barang.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth_maria_dwh/suplier.frm to /backup/teguhth_maria_dwh/suplier.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth_maria_dwh/customer.frm to /backup/teguhth_maria_dwh/customer.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth_maria_dwh/pasok.frm to /backup/teguhth_maria_dwh/pasok.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhth_maria_dwh/pembelian.frm to /backup/teguhth_maria_dwh/pembelian.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./dbsf_nbc_teguhdb/db.opt to /backup/dbsf_nbc_teguhdb/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./dbsf_nbc_teguhdb/barang.frm to /backup/dbsf_nbc_teguhdb/barang.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./dbsf_nbc_teguhdb/customer.frm to /backup/dbsf_nbc_teguhdb/customer.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./dbsf_nbc_teguhdb/pasok.frm to /backup/dbsf_nbc_teguhdb/pasok.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./dbsf_nbc_teguhdb/pembelian.frm to /backup/dbsf_nbc_teguhdb/pembelian.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./dbsf_nbc_teguhdb/suplier.frm to /backup/dbsf_nbc_teguhdb/suplier.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhdb/db.opt to /backup/teguhdb/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhdb/barang.frm to /backup/teguhdb/barang.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./performance_schema/db.opt to /backup/performance_schema/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/db.opt to /backup/sys/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/version.frm to /backup/sys/version.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/sys_config.frm to /backup/sys/sys_config.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/sys_config.MAI to /backup/sys/sys_config.MAI
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/sys_config.MAD to /backup/sys/sys_config.MAD
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/statements_with_sorting.frm to /backup/sys/statements_with_sorting.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/innodb_buffer_stats_by_schema.frm to /backup/sys/innodb_buffer_stats_by_schema.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /backup/sys/x@0024ps_schema_table_statistics_io.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /backup/sys/x@0024innodb_buffer_stats_by_schema.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024statements_with_sorting.frm to /backup/sys/x@0024statements_with_sorting.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/innodb_buffer_stats_by_table.frm to /backup/sys/innodb_buffer_stats_by_table.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_table_statistics_with_buffer.frm to /backup/sys/schema_table_statistics_with_buffer.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /backup/sys/x@0024innodb_buffer_stats_by_table.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/host_summary.frm to /backup/sys/host_summary.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/innodb_lock_waits.frm to /backup/sys/innodb_lock_waits.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024host_summary.frm to /backup/sys/x@0024host_summary.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024innodb_lock_waits.frm to /backup/sys/x@0024innodb_lock_waits.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/waits_by_user_by_latency.frm to /backup/sys/waits_by_user_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_object_overview.frm to /backup/sys/schema_object_overview.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/statements_with_temp_tables.frm to /backup/sys/statements_with_temp_tables.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_auto_increment_columns.frm to /backup/sys/schema_auto_increment_columns.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/user_summary_by_file_io_type.frm to /backup/sys/user_summary_by_file_io_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024schema_flattened_keys.frm to /backup/sys/x@0024schema_flattened_keys.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/user_summary_by_file_io.frm to /backup/sys/user_summary_by_file_io.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_redundant_indexes.frm to /backup/sys/schema_redundant_indexes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024user_summary_by_file_io.frm to /backup/sys/x@0024user_summary_by_file_io.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/ps_check_lost_instrumentation.frm to /backup/sys/ps_check_lost_instrumentation.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/latest_file_io.frm to /backup/sys/latest_file_io.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/waits_by_host_by_latency.frm to /backup/sys/waits_by_host_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024latest_file_io.frm to /backup/sys/x@0024latest_file_io.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/waits_global_by_latency.frm to /backup/sys/waits_global_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/io_by_thread_by_latency.frm to /backup/sys/io_by_thread_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/user_summary_by_statement_type.frm to /backup/sys/user_summary_by_statement_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024io_by_thread_by_latency.frm to /backup/sys/x@0024io_by_thread_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/user_summary_by_stages.frm to /backup/sys/user_summary_by_stages.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/io_global_by_file_by_bytes.frm to /backup/sys/io_global_by_file_by_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024schema_table_statistics.frm to /backup/sys/x@0024schema_table_statistics.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /backup/sys/x@0024io_global_by_file_by_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024user_summary_by_stages.frm to /backup/sys/x@0024user_summary_by_stages.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/io_global_by_file_by_latency.frm to /backup/sys/io_global_by_file_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_table_lock_waits.frm to /backup/sys/schema_table_lock_waits.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024io_global_by_file_by_latency.frm to /backup/sys/x@0024io_global_by_file_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/user_summary.frm to /backup/sys/user_summary.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/io_global_by_wait_by_bytes.frm to /backup/sys/io_global_by_wait_by_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024schema_table_lock_waits.frm to /backup/sys/x@0024schema_table_lock_waits.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /backup/sys/x@0024io_global_by_wait_by_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024user_summary.frm to /backup/sys/x@0024user_summary.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/io_global_by_wait_by_latency.frm to /backup/sys/io_global_by_wait_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/statement_analysis.frm to /backup/sys/statement_analysis.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /backup/sys/x@0024io_global_by_wait_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/host_summary_by_file_io_type.frm to /backup/sys/host_summary_by_file_io_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/memory_by_user_by_current_bytes.frm to /backup/sys/memory_by_user_by_current_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024statement_analysis.frm to /backup/sys/x@0024statement_analysis.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /backup/sys/x@0024memory_by_user_by_current_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/host_summary_by_file_io.frm to /backup/sys/host_summary_by_file_io.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/memory_by_host_by_current_bytes.frm to /backup/sys/memory_by_host_by_current_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/statements_with_errors_or_warnings.frm to /backup/sys/statements_with_errors_or_warnings.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /backup/sys/x@0024memory_by_host_by_current_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /backup/sys/x@0024statements_with_errors_or_warnings.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/memory_by_thread_by_current_bytes.frm to /backup/sys/memory_by_thread_by_current_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/statements_with_full_table_scans.frm to /backup/sys/statements_with_full_table_scans.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /backup/sys/x@0024memory_by_thread_by_current_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024host_summary_by_file_io.frm to /backup/sys/x@0024host_summary_by_file_io.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/memory_global_by_current_bytes.frm to /backup/sys/memory_global_by_current_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024statements_with_full_table_scans.frm to /backup/sys/x@0024statements_with_full_table_scans.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024memory_global_by_current_bytes.frm to /backup/sys/x@0024memory_global_by_current_bytes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/metrics.frm to /backup/sys/metrics.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/memory_global_total.frm to /backup/sys/memory_global_total.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/host_summary_by_statement_type.frm to /backup/sys/host_summary_by_statement_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024memory_global_total.frm to /backup/sys/x@0024memory_global_total.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/processlist.frm to /backup/sys/processlist.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_index_statistics.frm to /backup/sys/schema_index_statistics.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/host_summary_by_stages.frm to /backup/sys/host_summary_by_stages.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024schema_index_statistics.frm to /backup/sys/x@0024schema_index_statistics.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024processlist.frm to /backup/sys/x@0024processlist.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_table_statistics.frm to /backup/sys/schema_table_statistics.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/session.frm to /backup/sys/session.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /backup/sys/x@0024schema_table_statistics_with_buffer.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /backup/sys/x@0024ps_digest_avg_latency_distribution.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_tables_with_full_table_scans.frm to /backup/sys/schema_tables_with_full_table_scans.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/schema_unused_indexes.frm to /backup/sys/schema_unused_indexes.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /backup/sys/x@0024schema_tables_with_full_table_scans.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /backup/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /backup/sys/statements_with_runtimes_in_95th_percentile.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /backup/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024statements_with_temp_tables.frm to /backup/sys/x@0024statements_with_temp_tables.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024host_summary_by_stages.frm to /backup/sys/x@0024host_summary_by_stages.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024user_summary_by_file_io_type.frm to /backup/sys/x@0024user_summary_by_file_io_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024user_summary_by_statement_type.frm to /backup/sys/x@0024user_summary_by_statement_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/user_summary_by_statement_latency.frm to /backup/sys/user_summary_by_statement_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024user_summary_by_statement_latency.frm to /backup/sys/x@0024user_summary_by_statement_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024host_summary_by_file_io_type.frm to /backup/sys/x@0024host_summary_by_file_io_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024host_summary_by_statement_type.frm to /backup/sys/x@0024host_summary_by_statement_type.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/host_summary_by_statement_latency.frm to /backup/sys/host_summary_by_statement_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024host_summary_by_statement_latency.frm to /backup/sys/x@0024host_summary_by_statement_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/wait_classes_global_by_avg_latency.frm to /backup/sys/wait_classes_global_by_avg_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /backup/sys/x@0024wait_classes_global_by_avg_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/wait_classes_global_by_latency.frm to /backup/sys/wait_classes_global_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024wait_classes_global_by_latency.frm to /backup/sys/x@0024wait_classes_global_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024waits_by_user_by_latency.frm to /backup/sys/x@0024waits_by_user_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024waits_by_host_by_latency.frm to /backup/sys/x@0024waits_by_host_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024waits_global_by_latency.frm to /backup/sys/x@0024waits_global_by_latency.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/x@0024session.frm to /backup/sys/x@0024session.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./sys/session_ssl_status.frm to /backup/sys/session_ssl_status.frm
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./test/db.opt to /backup/test/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./tka/db.opt to /backup/tka/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./teguhthdb/db.opt to /backup/teguhthdb/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./dbsf_nbc_teguhdb_dmart/db.opt to /backup/dbsf_nbc_teguhdb_dmart/db.opt
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying ./dbsf_nbc_teguhdb_archive/db.opt to /backup/dbsf_nbc_teguhdb_archive/db.opt
[01] 2024-02-23 16:31:34 ...done
[00] 2024-02-23 16:31:34 Finished backing up non-InnoDB tables and files
[01] 2024-02-23 16:31:34 Copying /var/lib/mysql//aria_log_control to /backup/aria_log_control
[01] 2024-02-23 16:31:34 ...done
[01] 2024-02-23 16:31:34 Copying /var/lib/mysql//aria_log.00000001 to /backup/aria_log.00000001
[01] 2024-02-23 16:31:34 ...done
[00] 2024-02-23 16:31:34 Waiting for log copy thread to read lsn 329425
[00] 2024-02-23 16:31:34 Writing mariadb_backup_binlog_info
[00] 2024-02-23 16:31:34 ...done
[00] 2024-02-23 16:31:34 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
[00] 2024-02-23 16:31:34 mariabackup: The latest check point (for incremental): '329409'
mariabackup: Stopping log copying thread.
[00] 2024-02-23 16:31:34 Executing BACKUP STAGE END
[00] 2024-02-23 16:31:34 All tables unlocked
[00] 2024-02-23 16:31:34 Backup created in directory '/backup/'
[00] 2024-02-23 16:31:34 MySQL binlog position: filename 'mysql-bin.000002', position '1246', GTID of the last change '0-1-6'
[00] 2024-02-23 16:31:34 Writing backup-my.cnf
[00] 2024-02-23 16:31:34 ...done
[00] 2024-02-23 16:31:34 Writing mariadb_backup_info
[00] 2024-02-23 16:31:34 ...done
[00] 2024-02-23 16:31:34 Redo log (from LSN 329409 to 329425) was copied.
[00] 2024-02-23 16:31:34 completed OK!
[root@teguhth ~]#
# systemctl start crond
B. Testing delete
1. delete from table data
delete from teguhth.pembelian;
select * from teguhth.barang;
select * from teguhth.pembelian;
C. Restore mariabackup
1. check prepare mariadb
mariabackup --prepare --target-dir=/backup
[root@teguhth ~]# mariabackup --prepare --target-dir=/backup
mariabackup: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-backup' instead
mariabackup based on MariaDB server 11.1.4-MariaDB Linux (x86_64)
[00] 2024-02-23 16:33:07 cd to /backup/
[00] 2024-02-23 16:33:07 open files limit requested 0, set to 1024
[00] 2024-02-23 16:33:07 This target seems to be not prepared yet.
[00] 2024-02-23 16:33:07 mariabackup: using the following InnoDB configuration for recovery:
[00] 2024-02-23 16:33:07 innodb_data_home_dir = .
[00] 2024-02-23 16:33:07 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2024-02-23 16:33:07 innodb_log_group_home_dir = .
[00] 2024-02-23 16:33:07 InnoDB: Using Linux native AIO
[00] 2024-02-23 16:33:07 Starting InnoDB instance for recovery.
[00] 2024-02-23 16:33:07 mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2024-02-23 16:33:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-02-23 16:33:07 0 [Note] InnoDB: Number of transaction pools: 1
2024-02-23 16:33:07 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2024-02-23 16:33:07 0 [Note] InnoDB: Using Linux native AIO
2024-02-23 16:33:07 0 [Note] InnoDB: Initializing buffer pool, total size = 100.000MiB, chunk size = 100.000MiB
2024-02-23 16:33:07 0 [Note] InnoDB: Completed initialization of buffer pool
2024-02-23 16:33:07 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
2024-02-23 16:33:07 0 [Note] InnoDB: End of log at LSN=329425
[00] 2024-02-23 16:33:07 Last binlog file , position 0
[00] 2024-02-23 16:33:07 completed OK!
[root@teguhth ~]#
2. stop mariadb service
systemctl stop mariadb
[root@teguhth ~]# systemctl stop mariadb
[root@teguhth ~]#
3. delete & create directory mariadb
rm -rf /var/lib/mysql/
mkdir /var/lib/mysql/
[root@teguhth ~]# rm -rf /var/lib/mysql/
[root@teguhth ~]# mkdir /var/lib/mysql/
[root@teguhth ~]#
4. restore database mariabackup
mariabackup --copy-back --target-dir=/backup --user=admin --password=admin
[root@teguhth ~]# mariabackup --copy-back --target-dir=/backup --user=admin --password=admin
mariabackup: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-backup' instead
mariabackup based on MariaDB server 11.1.4-MariaDB Linux (x86_64)
[01] 2024-02-23 16:35:52 Copying ./aria_log_control to /var/lib/mysql/aria_log_control
[01] 2024-02-23 16:35:52 ...done
[01] 2024-02-23 16:35:52 Copying ./aria_log.00000001 to /var/lib/mysql/aria_log.00000001
[01] 2024-02-23 16:35:52 ...done
[01] 2024-02-23 16:35:52 Copying undo001 to /var/lib/mysql/undo001
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying undo002 to /var/lib/mysql/undo002
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying undo003 to /var/lib/mysql/undo003
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ib_logfile0 to /var/lib/mysql/ib_logfile0
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ibdata1 to /var/lib/mysql/./ibdata1
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/transaction_registry.ibd to /var/lib/mysql/mysql/transaction_registry.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/gtid_slave_pos.ibd to /var/lib/mysql/mysql/gtid_slave_pos.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/db.opt to /var/lib/mysql/mysql/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/db.MAI to /var/lib/mysql/mysql/db.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/db.MAD to /var/lib/mysql/mysql/db.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/global_priv.frm to /var/lib/mysql/mysql/global_priv.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/global_priv.MAI to /var/lib/mysql/mysql/global_priv.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/global_priv.MAD to /var/lib/mysql/mysql/global_priv.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/roles_mapping.frm to /var/lib/mysql/mysql/roles_mapping.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/roles_mapping.MAI to /var/lib/mysql/mysql/roles_mapping.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/roles_mapping.MAD to /var/lib/mysql/mysql/roles_mapping.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/func.MAI to /var/lib/mysql/mysql/func.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/func.MAD to /var/lib/mysql/mysql/func.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/plugin.MAI to /var/lib/mysql/mysql/plugin.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/plugin.MAD to /var/lib/mysql/mysql/plugin.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/servers.MAI to /var/lib/mysql/mysql/servers.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/servers.MAD to /var/lib/mysql/mysql/servers.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/tables_priv.MAI to /var/lib/mysql/mysql/tables_priv.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/tables_priv.MAD to /var/lib/mysql/mysql/tables_priv.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/columns_priv.MAI to /var/lib/mysql/mysql/columns_priv.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/columns_priv.MAD to /var/lib/mysql/mysql/columns_priv.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_topic.MAI to /var/lib/mysql/mysql/help_topic.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_topic.MAD to /var/lib/mysql/mysql/help_topic.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_category.MAI to /var/lib/mysql/mysql/help_category.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_category.MAD to /var/lib/mysql/mysql/help_category.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_relation.MAI to /var/lib/mysql/mysql/help_relation.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_relation.MAD to /var/lib/mysql/mysql/help_relation.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_keyword.MAI to /var/lib/mysql/mysql/help_keyword.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/help_keyword.MAD to /var/lib/mysql/mysql/help_keyword.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_name.MAI to /var/lib/mysql/mysql/time_zone_name.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_name.MAD to /var/lib/mysql/mysql/time_zone_name.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone.MAI to /var/lib/mysql/mysql/time_zone.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone.MAD to /var/lib/mysql/mysql/time_zone.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_transition.MAI to /var/lib/mysql/mysql/time_zone_transition.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_transition.MAD to /var/lib/mysql/mysql/time_zone_transition.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_transition_type.MAI to /var/lib/mysql/mysql/time_zone_transition_type.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_transition_type.MAD to /var/lib/mysql/mysql/time_zone_transition_type.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_leap_second.MAI to /var/lib/mysql/mysql/time_zone_leap_second.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/time_zone_leap_second.MAD to /var/lib/mysql/mysql/time_zone_leap_second.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/proc.MAI to /var/lib/mysql/mysql/proc.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/proc.MAD to /var/lib/mysql/mysql/proc.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/procs_priv.MAI to /var/lib/mysql/mysql/procs_priv.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/procs_priv.MAD to /var/lib/mysql/mysql/procs_priv.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/event.MAI to /var/lib/mysql/mysql/event.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/event.MAD to /var/lib/mysql/mysql/event.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/transaction_registry.frm to /var/lib/mysql/mysql/transaction_registry.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/proxies_priv.MAI to /var/lib/mysql/mysql/proxies_priv.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/proxies_priv.MAD to /var/lib/mysql/mysql/proxies_priv.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/table_stats.frm to /var/lib/mysql/mysql/table_stats.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/table_stats.MAI to /var/lib/mysql/mysql/table_stats.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/table_stats.MAD to /var/lib/mysql/mysql/table_stats.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/column_stats.frm to /var/lib/mysql/mysql/column_stats.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/column_stats.MAI to /var/lib/mysql/mysql/column_stats.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/column_stats.MAD to /var/lib/mysql/mysql/column_stats.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/index_stats.frm to /var/lib/mysql/mysql/index_stats.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/index_stats.MAI to /var/lib/mysql/mysql/index_stats.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/index_stats.MAD to /var/lib/mysql/mysql/index_stats.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mysql/gtid_slave_pos.frm to /var/lib/mysql/mysql/gtid_slave_pos.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/barang.ibd to /var/lib/mysql/teguhth/barang.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/suplier.ibd to /var/lib/mysql/teguhth/suplier.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/customer.ibd to /var/lib/mysql/teguhth/customer.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/pasok.ibd to /var/lib/mysql/teguhth/pasok.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/pembelian.ibd to /var/lib/mysql/teguhth/pembelian.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/db.opt to /var/lib/mysql/teguhth/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/barang.frm to /var/lib/mysql/teguhth/barang.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/suplier.frm to /var/lib/mysql/teguhth/suplier.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/customer.frm to /var/lib/mysql/teguhth/customer.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/pasok.frm to /var/lib/mysql/teguhth/pasok.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth/pembelian.frm to /var/lib/mysql/teguhth/pembelian.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/barang.ibd to /var/lib/mysql/teguhth_maria_dwh/barang.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/suplier.ibd to /var/lib/mysql/teguhth_maria_dwh/suplier.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/customer.ibd to /var/lib/mysql/teguhth_maria_dwh/customer.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/pasok.ibd to /var/lib/mysql/teguhth_maria_dwh/pasok.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/pembelian.ibd to /var/lib/mysql/teguhth_maria_dwh/pembelian.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/db.opt to /var/lib/mysql/teguhth_maria_dwh/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/barang.frm to /var/lib/mysql/teguhth_maria_dwh/barang.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/suplier.frm to /var/lib/mysql/teguhth_maria_dwh/suplier.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/customer.frm to /var/lib/mysql/teguhth_maria_dwh/customer.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/pasok.frm to /var/lib/mysql/teguhth_maria_dwh/pasok.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhth_maria_dwh/pembelian.frm to /var/lib/mysql/teguhth_maria_dwh/pembelian.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/barang.ibd to /var/lib/mysql/dbsf_nbc_teguhdb/barang.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/customer.ibd to /var/lib/mysql/dbsf_nbc_teguhdb/customer.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/pasok.ibd to /var/lib/mysql/dbsf_nbc_teguhdb/pasok.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/pembelian.ibd to /var/lib/mysql/dbsf_nbc_teguhdb/pembelian.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/suplier.ibd to /var/lib/mysql/dbsf_nbc_teguhdb/suplier.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/db.opt to /var/lib/mysql/dbsf_nbc_teguhdb/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/barang.frm to /var/lib/mysql/dbsf_nbc_teguhdb/barang.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/customer.frm to /var/lib/mysql/dbsf_nbc_teguhdb/customer.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/pasok.frm to /var/lib/mysql/dbsf_nbc_teguhdb/pasok.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/pembelian.frm to /var/lib/mysql/dbsf_nbc_teguhdb/pembelian.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb/suplier.frm to /var/lib/mysql/dbsf_nbc_teguhdb/suplier.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhdb/barang.ibd to /var/lib/mysql/teguhdb/barang.ibd
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhdb/db.opt to /var/lib/mysql/teguhdb/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhdb/barang.frm to /var/lib/mysql/teguhdb/barang.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/db.opt to /var/lib/mysql/sys/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/version.frm to /var/lib/mysql/sys/version.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/sys_config.frm to /var/lib/mysql/sys/sys_config.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/sys_config.MAI to /var/lib/mysql/sys/sys_config.MAI
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/sys_config.MAD to /var/lib/mysql/sys/sys_config.MAD
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/statements_with_sorting.frm to /var/lib/mysql/sys/statements_with_sorting.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/innodb_buffer_stats_by_schema.frm to /var/lib/mysql/sys/innodb_buffer_stats_by_schema.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /var/lib/mysql/sys/x@0024ps_schema_table_statistics_io.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /var/lib/mysql/sys/x@0024innodb_buffer_stats_by_schema.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024statements_with_sorting.frm to /var/lib/mysql/sys/x@0024statements_with_sorting.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/innodb_buffer_stats_by_table.frm to /var/lib/mysql/sys/innodb_buffer_stats_by_table.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_table_statistics_with_buffer.frm to /var/lib/mysql/sys/schema_table_statistics_with_buffer.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /var/lib/mysql/sys/x@0024innodb_buffer_stats_by_table.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/host_summary.frm to /var/lib/mysql/sys/host_summary.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/innodb_lock_waits.frm to /var/lib/mysql/sys/innodb_lock_waits.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024host_summary.frm to /var/lib/mysql/sys/x@0024host_summary.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024innodb_lock_waits.frm to /var/lib/mysql/sys/x@0024innodb_lock_waits.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/waits_by_user_by_latency.frm to /var/lib/mysql/sys/waits_by_user_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_object_overview.frm to /var/lib/mysql/sys/schema_object_overview.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/statements_with_temp_tables.frm to /var/lib/mysql/sys/statements_with_temp_tables.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_auto_increment_columns.frm to /var/lib/mysql/sys/schema_auto_increment_columns.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/user_summary_by_file_io_type.frm to /var/lib/mysql/sys/user_summary_by_file_io_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024schema_flattened_keys.frm to /var/lib/mysql/sys/x@0024schema_flattened_keys.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/user_summary_by_file_io.frm to /var/lib/mysql/sys/user_summary_by_file_io.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_redundant_indexes.frm to /var/lib/mysql/sys/schema_redundant_indexes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024user_summary_by_file_io.frm to /var/lib/mysql/sys/x@0024user_summary_by_file_io.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/ps_check_lost_instrumentation.frm to /var/lib/mysql/sys/ps_check_lost_instrumentation.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/latest_file_io.frm to /var/lib/mysql/sys/latest_file_io.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/waits_by_host_by_latency.frm to /var/lib/mysql/sys/waits_by_host_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024latest_file_io.frm to /var/lib/mysql/sys/x@0024latest_file_io.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/waits_global_by_latency.frm to /var/lib/mysql/sys/waits_global_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/io_by_thread_by_latency.frm to /var/lib/mysql/sys/io_by_thread_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/user_summary_by_statement_type.frm to /var/lib/mysql/sys/user_summary_by_statement_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024io_by_thread_by_latency.frm to /var/lib/mysql/sys/x@0024io_by_thread_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/user_summary_by_stages.frm to /var/lib/mysql/sys/user_summary_by_stages.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/io_global_by_file_by_bytes.frm to /var/lib/mysql/sys/io_global_by_file_by_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024schema_table_statistics.frm to /var/lib/mysql/sys/x@0024schema_table_statistics.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /var/lib/mysql/sys/x@0024io_global_by_file_by_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024user_summary_by_stages.frm to /var/lib/mysql/sys/x@0024user_summary_by_stages.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/io_global_by_file_by_latency.frm to /var/lib/mysql/sys/io_global_by_file_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_table_lock_waits.frm to /var/lib/mysql/sys/schema_table_lock_waits.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024io_global_by_file_by_latency.frm to /var/lib/mysql/sys/x@0024io_global_by_file_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/user_summary.frm to /var/lib/mysql/sys/user_summary.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/io_global_by_wait_by_bytes.frm to /var/lib/mysql/sys/io_global_by_wait_by_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024schema_table_lock_waits.frm to /var/lib/mysql/sys/x@0024schema_table_lock_waits.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /var/lib/mysql/sys/x@0024io_global_by_wait_by_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024user_summary.frm to /var/lib/mysql/sys/x@0024user_summary.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/io_global_by_wait_by_latency.frm to /var/lib/mysql/sys/io_global_by_wait_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/statement_analysis.frm to /var/lib/mysql/sys/statement_analysis.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /var/lib/mysql/sys/x@0024io_global_by_wait_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/host_summary_by_file_io_type.frm to /var/lib/mysql/sys/host_summary_by_file_io_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/memory_by_user_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_user_by_current_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024statement_analysis.frm to /var/lib/mysql/sys/x@0024statement_analysis.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_user_by_current_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/host_summary_by_file_io.frm to /var/lib/mysql/sys/host_summary_by_file_io.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/memory_by_host_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_host_by_current_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/statements_with_errors_or_warnings.frm to /var/lib/mysql/sys/statements_with_errors_or_warnings.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_host_by_current_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /var/lib/mysql/sys/x@0024statements_with_errors_or_warnings.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/memory_by_thread_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_thread_by_current_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/statements_with_full_table_scans.frm to /var/lib/mysql/sys/statements_with_full_table_scans.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_thread_by_current_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024host_summary_by_file_io.frm to /var/lib/mysql/sys/x@0024host_summary_by_file_io.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/memory_global_by_current_bytes.frm to /var/lib/mysql/sys/memory_global_by_current_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024statements_with_full_table_scans.frm to /var/lib/mysql/sys/x@0024statements_with_full_table_scans.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024memory_global_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_global_by_current_bytes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/metrics.frm to /var/lib/mysql/sys/metrics.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/memory_global_total.frm to /var/lib/mysql/sys/memory_global_total.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/host_summary_by_statement_type.frm to /var/lib/mysql/sys/host_summary_by_statement_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024memory_global_total.frm to /var/lib/mysql/sys/x@0024memory_global_total.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/processlist.frm to /var/lib/mysql/sys/processlist.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_index_statistics.frm to /var/lib/mysql/sys/schema_index_statistics.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/host_summary_by_stages.frm to /var/lib/mysql/sys/host_summary_by_stages.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024schema_index_statistics.frm to /var/lib/mysql/sys/x@0024schema_index_statistics.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024processlist.frm to /var/lib/mysql/sys/x@0024processlist.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_table_statistics.frm to /var/lib/mysql/sys/schema_table_statistics.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/session.frm to /var/lib/mysql/sys/session.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /var/lib/mysql/sys/x@0024schema_table_statistics_with_buffer.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /var/lib/mysql/sys/x@0024ps_digest_avg_latency_distribution.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_tables_with_full_table_scans.frm to /var/lib/mysql/sys/schema_tables_with_full_table_scans.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/schema_unused_indexes.frm to /var/lib/mysql/sys/schema_unused_indexes.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /var/lib/mysql/sys/x@0024schema_tables_with_full_table_scans.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /var/lib/mysql/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /var/lib/mysql/sys/statements_with_runtimes_in_95th_percentile.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /var/lib/mysql/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024statements_with_temp_tables.frm to /var/lib/mysql/sys/x@0024statements_with_temp_tables.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024host_summary_by_stages.frm to /var/lib/mysql/sys/x@0024host_summary_by_stages.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024user_summary_by_file_io_type.frm to /var/lib/mysql/sys/x@0024user_summary_by_file_io_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024user_summary_by_statement_type.frm to /var/lib/mysql/sys/x@0024user_summary_by_statement_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/user_summary_by_statement_latency.frm to /var/lib/mysql/sys/user_summary_by_statement_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024user_summary_by_statement_latency.frm to /var/lib/mysql/sys/x@0024user_summary_by_statement_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024host_summary_by_file_io_type.frm to /var/lib/mysql/sys/x@0024host_summary_by_file_io_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024host_summary_by_statement_type.frm to /var/lib/mysql/sys/x@0024host_summary_by_statement_type.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/host_summary_by_statement_latency.frm to /var/lib/mysql/sys/host_summary_by_statement_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024host_summary_by_statement_latency.frm to /var/lib/mysql/sys/x@0024host_summary_by_statement_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/wait_classes_global_by_avg_latency.frm to /var/lib/mysql/sys/wait_classes_global_by_avg_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /var/lib/mysql/sys/x@0024wait_classes_global_by_avg_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/wait_classes_global_by_latency.frm to /var/lib/mysql/sys/wait_classes_global_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024wait_classes_global_by_latency.frm to /var/lib/mysql/sys/x@0024wait_classes_global_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024waits_by_user_by_latency.frm to /var/lib/mysql/sys/x@0024waits_by_user_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024waits_by_host_by_latency.frm to /var/lib/mysql/sys/x@0024waits_by_host_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024waits_global_by_latency.frm to /var/lib/mysql/sys/x@0024waits_global_by_latency.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/x@0024session.frm to /var/lib/mysql/sys/x@0024session.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./sys/session_ssl_status.frm to /var/lib/mysql/sys/session_ssl_status.frm
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./test/db.opt to /var/lib/mysql/test/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./tka/db.opt to /var/lib/mysql/tka/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./teguhthdb/db.opt to /var/lib/mysql/teguhthdb/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb_dmart/db.opt to /var/lib/mysql/dbsf_nbc_teguhdb_dmart/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./dbsf_nbc_teguhdb_archive/db.opt to /var/lib/mysql/dbsf_nbc_teguhdb_archive/db.opt
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./mariadb_backup_info to /var/lib/mysql/mariadb_backup_info
[01] 2024-02-23 16:35:53 ...done
[01] 2024-02-23 16:35:53 Copying ./xtrabackup_binlog_pos_innodb to /var/lib/mysql/xtrabackup_binlog_pos_innodb
[01] 2024-02-23 16:35:53 ...done
[00] 2024-02-23 16:35:53 completed OK!
[root@teguhth ~]#
5. change owner
chown -R mysql:mysql /var/lib/mysql/
[root@teguhth ~]# chown -R mysql:mysql /var/lib/mysql/
[root@teguhth ~]#
6. start mariadb
systemctl start mariadb
[root@teguhth ~]# systemctl start mariadb
[root@teguhth ~]#
D. check data after testing
select * from teguhth.barang;
select * from teguhth.pembelian;
No comments:
Post a Comment