MariaBackup 오류
mariabackup을 받은 후 , 테스트를 위해 복원하던 중
서버를 종료하지 않은채로 복원을 진행하였다.
복원 자체는 정상적으로 이루어져 데이터에 문제는 없었으나,
해당 서버에서 다시 mariabackup을 받을 때 오류가 발생하였다.
log scan up to - 가 종료되지 않고 계속 loop되는 문제이다.
2021-11-08 14:51:48 0 [Note] InnoDB: Read redo log up to LSN=3929524224
[00] 2021-11-08 14:51:48 >> log scanned up to (3929523736)
[00] 2021-11-08 14:51:49 >> log scanned up to (3929523736)
[00] 2021-11-08 14:51:50 >> log scanned up to (3929523736)하지만 지금 서버에서 LSN을 확인해보면 오류가 난 한참 이전의 lsn이였다.
SHOW ENGINE INNODB STATUS;
Log sequence number 4583407014
Log flushed up to 4583407014
Pages flushed up to 4492920277
Last checkpoint at 4492920277해결과정 -
운영중에 복원을 했기 때문에, ib_logfile0가 datadir에 존재하지 않았다.
( empty한 ib_logfile0가 생성된다고 하는데, 해당 서버에는 생성되지 않았다 )
따라서 shutdown 후 다시 기동했더니 ib_logfile0가 생성되긴 했다.
처음에는 특정 LSN을 계속 찾는게 반복되길래, redo logfile이 손상되어서 특정 lsn을 찾지 못해 발생한 오류로 생각했다.
복원하면서 datadir을 삭제하고 새로 복원했기 때문에, ib_logfile이 존재하지 X -> 운영중인서버에서 메모리 redo log가 logfile로 저장되지 못함 ( default로 commit시 해당 redolog가 logfile로 flush -> innodb_flush_log_at_trx_commit) -> 변경된 data에 대한 log(LSN) 유실되어 오류 발생하는 것으로 추측
그러나 한가지 의문은 mariabackup은 2가지 프로세스로 구성 (data를 copy하는 것과 해당 백업중 발생하는 log를 기록하는 프로세스 )
log를 기록하는 프로세스가 해당 LSN을 계속 찾는중이라는 오류 메세지 인데, 기존에 손실된 lsn은 지금 백업중에 발생하는 log가 아니기 때문에 영향을 주지 않을 것 같은데, 이게 문제가 맞는걸까 ?
아니면 checkpoint가 기록된 redolog가 손실되어 발생하는 오류인가 ?
그래서 운영중인 DATA 디렉토리에서 ib_logfile0를 삭제하고 서버를 내렸다가 다시 올렸다. ( 손상된 lsn 때문이라면 해당 부분을 삭제하기위해)
그리고 나서 다시 mariabackup 을 수행했지만 여전히 오류가 발생하였다.
해당 문제로 구글링을 해보니 log scan하는 프로세스가 lock이 걸려서 더이상 진행되지 않는 Bug라고 한다. 또는 xtrabackup_suspended 라는 파일이 남아있어서 안된다는 말도 있다.
https://bugs.launchpad.net/percona-xtrabackup/+bug/1007446
https://bugs.launchpad.net/percona-xtrabackup/+bug/1288165
하지만 둘 다 모두 maria10.5 버전에서는 패치가 완료된 상태이다.
또한 SET GLOBAL envent_scheduler = OFF 인것도 확인하였다.
mariabackup 진행시 show processlist를 통해 진행중인 프로세스를 확인해보면,
130987 apnpsgen1 10.50.109.73:60182 npsdb Query 48 Waiting for backup lock COMMIT 0.0
130987 apnpsgen1 10.50.109.73:60182 npsdb Query 4 Waiting for backup lock COMMIT 0.0이런식으로 backup으로 인해서 다른 프로세스들이 lock이 걸린 상태이다.
그치만 lock을 건 프로세스는 조회가 되지는 않았다.
또 xtrabackup_suspended 파일을 찾아봤지만 존재하지 않았다.
테스트로 AWS EC2에 생성한 mariadb에서 동일한 테스트를 진행해보려고 한다.
순서 :
- 신문제작 개발계 DB Mysqldump
mysqldump -u dbalkh -p --all-databases --routines --events > 20211109.sql- EC2에서 mysqldump로 복원
mysql -u dbalkh -p < allbackup.sql- EC2에서 mariabackup 백업 진행 -> 성공
mariabackup --backup --target-dir=${backup_dir}/full --user=dbacom --password=${db_pw}- 기존 maria_data 를 백업 한 후 운영중에 해당 directory 삭제
- mariabackup 복원 수행 -> 동일한 에러가 나는지 확인테스트
[root@ip-172-31-6-25 mysql]# mariabackup --prepare --target-dir=/backup/full[root@ip-172-31-6-25 mysql]# mariabackup --copy-back --target-dir=/backup/full-
복원수행 후 DB가 정상적으로 데이터 조회가 되는지 확인 -> 정상
-> ib_logfile이 X , log flush가 안되므로 buffer flush도 안될 것으로 예상 -
DB shutdown 후 다시 start 하기
-> shutdown시 무슨일이 생기는지 확인하기
#### shutdown시 innodb는 메모리 buffer pool을 disk로 flush 한다.
InnoDB flushes its buffer pool to disk (unless innodb_fast_shutdown is 2), writes the current LSN to the tablespace, and terminates its own internal thread
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html추측은 buffer pool 이 flush되기 전에 해당 redo log도 flush되어야하는데, ib_logfile이 없기때문에 log flush가 정상적으로 되지 않았을 것이다. innodb는 WAL(Write Ahead Log) 이기 때문에 redo log가 flush되지 않으면 data도 flush되지 않을 텐데, 그러면 메모리데이터가 모두 날라가는건지, data는 flush되고 redo log만 손상되는건지 모르겠다.
중지 후 다시 기동하니까 새로운 파일들이 생겼다
total 254068
-rw-r----- 1 mysql mysql 49152 Nov 11 07:05 aria_log.00000001
-rw-r----- 1 mysql mysql 52 Nov 11 07:05 aria_log_control
#### -rw-rw---- 1 mysql mysql 1825 Nov 11 07:19 error.log
drwx------ 2 mysql mysql 4096 Nov 11 07:05 hisdb
-rw-rw---- 1 mysql mysql 16997 Nov 11 07:18 ib_buffer_pool
-rw-r----- 1 mysql mysql 146800640 Nov 11 07:05 ibdata1
#### -rw-rw---- 1 mysql mysql 100663296 Nov 11 07:19 ib_logfile0
#### -rw-rw---- 1 mysql mysql 12582912 Nov 11 07:19 ibtmp1
#### -rw-rw---- 1 mysql mysql 144 Nov 11 07:19 ip-172-31-6-25.log
#### -rw-rw---- 1 mysql mysql 6 Nov 11 07:19 ip-172-31-6-25.pid
#### -rw-rw---- 1 mysql mysql 0 Nov 11 07:19 multi-master.info
drwx------ 2 mysql mysql 4096 Nov 11 07:05 mysql
srwxrwxrwx 1 mysql mysql 0 Nov 11 07:19 mysql.sock
drwx------ 2 mysql mysql 8192 Nov 11 07:05 npsdb
drwx------ 2 mysql mysql 20 Nov 11 07:05 performance_schema
drwx------ 2 mysql mysql 4096 Nov 11 07:05 scmdb
drwx------ 2 mysql mysql 20 Nov 11 07:05 test
-rw-r----- 1 mysql mysql 454 Nov 11 07:05 xtrabackup_info- 다시 mariabackup 수행하기
-->정상 작동했다. 복원 후 shutdown까지의 기간동안 아무런 DDL이나 DML도 없어서 정상 작동 하는 것인가 ?
- 운영중에 복원 후 , insert 작업까지 한 후에 다시 재기동 한 후 mariabackup 수행
--> 정상 작동
- 그렇다면 운영중에 datadir 삭제 후 복원했을 때, db를 셧다운하기 전까지의 데이터는 손실되는 걸까 ??
- 예상대로 restore한 이후에 insert(commit완료)한 내용도 모두 삭제되었다.
-> 즉 ib_logfile이 없기 때문에 , redo log와 buffer pool 모두 flush가 실패한 것 같다.
오류 원인
mysql 서버 status를 확인하니까 run time이 13일이 넘게 나왔다.
분명 저번주에 systemctl stop maria , systemctl start maria 를 통해 재기동을 했는데
run time은 재기동이 된적이 없는 것으로 나왔다.
서버 로그를 확인해보니, 당시 error가 발생해서 정상적으로 서버가 종료되지 않았다.
그래서 mysql 좀비 프로세스가 죽지않고 계속 살아있다 보니까, 서버 재기동이 제대로 되지 않았고 mariabackup도 작동하지 않았다.
해당 서버를 재기동하고나니, 데이터베이스 테이블 조회가 되지 않았다. 데이터파일(ibd)와 테이블의 매핑정보가 잘못되서 해당 테이블을 찾을 수 없다고 나왔다. 이 또한 운영중 datadir를 삭제하고 이후에 제대로 재기동이 되지 않았기 때문에, 해당 매핑정보가 깨진 것으로 유추된다.
오류를 해결하기 위해 테이블마다 데이터파일을 복제 후 테이블 재생성 과정을 통해 , TABLESPACE 를 discart하고 import 하는 순서를 통해 해당 문제를 해결할 수 있다고 나와있지만, 현 서버에서는 작동하지 않았다.
https://m.blog.naver.com/bomyzzang/221740261378
따라서 기존에 있던 운영서버 데이터를 mariabackup받고 해당 데이터를 개발서버에 import하는 식으로 조치하였다.
기존 개발서버의 데이터가 많이 날라가는 큰 이슈였고 문제였다...
주의
mariadb 서버를 재기동 할 때는 단순히 systemctl stauts maria로 확인하는 것이 아니라. ps-ef | grep mysql 을 통해 확실하게 서버가 죽었고/살았는지를 확인해야 한다.
또한 서버 재기동 log를 꼭 확인해서 ERROR가 없는지 확인해야 한다.
복원 LOG
[root@ip-172-31-6-25 mysql]# mariabackup --prepare --target-dir=/backup/full
mariabackup based on MariaDB server 10.5.13-MariaDB Linux (x86_64)
[00] 2021-11-11 07:05:10 cd to /backup/full/
[00] 2021-11-11 07:05:10 open files limit requested 0, set to 65535
[00] 2021-11-11 07:05:10 This target seems to be not prepared yet.
[00] 2021-11-11 07:05:10 mariabackup: using the following InnoDB configuration for recovery:
[00] 2021-11-11 07:05:10 innodb_data_home_dir = .
[00] 2021-11-11 07:05:10 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2021-11-11 07:05:10 innodb_log_group_home_dir = .
[00] 2021-11-11 07:05:10 InnoDB: Using Linux native AIO
[00] 2021-11-11 07:05:10 Starting InnoDB instance for recovery.
[00] 2021-11-11 07:05:10 mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2021-11-11 7:05:10 0 [Note] InnoDB: Uses event mutexes
2021-11-11 7:05:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2021-11-11 7:05:10 0 [Note] InnoDB: Number of pools: 1
2021-11-11 7:05:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2021-11-11 7:05:10 0 [Note] InnoDB: Using Linux native AIO
2021-11-11 7:05:10 0 [Note] InnoDB: Initializing buffer pool, total size = 104857600, chunk size = 104857600
2021-11-11 7:05:10 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-11 7:05:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2018521247,2018521247
[00] 2021-11-11 07:05:10 Last binlog file , position 0
[00] 2021-11-11 07:05:10 completed OK!
[root@ip-172-31-6-25 mysql]#
[root@ip-172-31-6-25 mysql]#
[root@ip-172-31-6-25 mysql]#
[root@ip-172-31-6-25 mysql]# mariabackup --copy-back --target-dir=/backup/full
mariabackup based on MariaDB server 10.5.13-MariaDB Linux (x86_64)
[01] 2021-11-11 07:05:35 Copying ibdata1 to /var/lib/mysql/ibdata1
[01] 2021-11-11 07:05:36 ...done
[01] 2021-11-11 07:05:36 Copying ./mysql/gtid_slave_pos.ibd to /var/lib/mysql/mysql/gtid_slave_pos.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/test11.ibd to /var/lib/mysql/mysql/test11.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/transaction_registry.ibd to /var/lib/mysql/mysql/transaction_registry.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/db.opt to /var/lib/mysql/mysql/db.opt
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/global_priv.frm to /var/lib/mysql/mysql/global_priv.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/global_priv.MAI to /var/lib/mysql/mysql/global_priv.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/global_priv.MAD to /var/lib/mysql/mysql/global_priv.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/proxies_priv.MAI to /var/lib/mysql/mysql/proxies_priv.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/roles_mapping.frm to /var/lib/mysql/mysql/roles_mapping.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/roles_mapping.MAI to /var/lib/mysql/mysql/roles_mapping.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_category.MAD to /var/lib/mysql/mysql/help_category.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/plugin.MAI to /var/lib/mysql/mysql/plugin.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/proxies_priv.MAD to /var/lib/mysql/mysql/proxies_priv.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/servers.MAI to /var/lib/mysql/mysql/servers.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/tables_priv.MAI to /var/lib/mysql/mysql/tables_priv.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/tables_priv.MAD to /var/lib/mysql/mysql/tables_priv.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/func.MAD to /var/lib/mysql/mysql/func.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_keyword.MAI to /var/lib/mysql/mysql/help_keyword.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_topic.MAI to /var/lib/mysql/mysql/help_topic.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_topic.MAD to /var/lib/mysql/mysql/help_topic.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_relation.MAI to /var/lib/mysql/mysql/help_relation.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_relation.MAD to /var/lib/mysql/mysql/help_relation.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/roles_mapping.MAD to /var/lib/mysql/mysql/roles_mapping.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/servers.MAD to /var/lib/mysql/mysql/servers.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_name.MAI to /var/lib/mysql/mysql/time_zone_name.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_name.MAD to /var/lib/mysql/mysql/time_zone_name.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone.MAI to /var/lib/mysql/mysql/time_zone.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_transition.MAI to /var/lib/mysql/mysql/time_zone_transition.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_transition.MAD to /var/lib/mysql/mysql/time_zone_transition.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_transition_type.MAI to /var/lib/mysql/mysql/time_zone_transition_type.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_transition_type.MAD to /var/lib/mysql/mysql/time_zone_transition_type.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_leap_second.MAI to /var/lib/mysql/mysql/time_zone_leap_second.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/proc.MAI to /var/lib/mysql/mysql/proc.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/procs_priv.MAI to /var/lib/mysql/mysql/procs_priv.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/procs_priv.MAD to /var/lib/mysql/mysql/procs_priv.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone.MAD to /var/lib/mysql/mysql/time_zone.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_keyword.MAD to /var/lib/mysql/mysql/help_keyword.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/plugin.MAD to /var/lib/mysql/mysql/plugin.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/proc.MAD to /var/lib/mysql/mysql/proc.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/time_zone_leap_second.MAD to /var/lib/mysql/mysql/time_zone_leap_second.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/transaction_registry.frm to /var/lib/mysql/mysql/transaction_registry.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/table_stats.frm to /var/lib/mysql/mysql/table_stats.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/table_stats.MAI to /var/lib/mysql/mysql/table_stats.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/table_stats.MAD to /var/lib/mysql/mysql/table_stats.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/test11.frm to /var/lib/mysql/mysql/test11.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/gtid_slave_pos.frm to /var/lib/mysql/mysql/gtid_slave_pos.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/index_stats.frm to /var/lib/mysql/mysql/index_stats.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/index_stats.MAI to /var/lib/mysql/mysql/index_stats.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/index_stats.MAD to /var/lib/mysql/mysql/index_stats.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/column_stats.frm to /var/lib/mysql/mysql/column_stats.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/column_stats.MAI to /var/lib/mysql/mysql/column_stats.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/column_stats.MAD to /var/lib/mysql/mysql/column_stats.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/columns_priv.MAI to /var/lib/mysql/mysql/columns_priv.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/columns_priv.MAD to /var/lib/mysql/mysql/columns_priv.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/db.MAI to /var/lib/mysql/mysql/db.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/db.MAD to /var/lib/mysql/mysql/db.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/event.MAI to /var/lib/mysql/mysql/event.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/event.MAD to /var/lib/mysql/mysql/event.MAD
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/func.MAI to /var/lib/mysql/mysql/func.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./mysql/help_category.MAI to /var/lib/mysql/mysql/help_category.MAI
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_log_master.ibd to /var/lib/mysql/hisdb/tb_his_log_master.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d07.ibd to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d07.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d08.ibd to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d08.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d09.ibd to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d09.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d10.ibd to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d10.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d11.ibd to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d11.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_rcv_log_2021@002d09.ibd to /var/lib/mysql/hisdb/tb_his_rcv_log_2021@002d09.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_rcv_log_2021@002d10.ibd to /var/lib/mysql/hisdb/tb_his_rcv_log_2021@002d10.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_rcv_log_2021@002d11.ibd to /var/lib/mysql/hisdb/tb_his_rcv_log_2021@002d11.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/db.opt to /var/lib/mysql/hisdb/db.opt
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_log_master.frm to /var/lib/mysql/hisdb/tb_his_log_master.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d07.frm to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d07.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d08.frm to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d08.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d09.frm to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d09.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d10.frm to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d10.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_pws_log_2021@002d11.frm to /var/lib/mysql/hisdb/tb_his_pws_log_2021@002d11.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_rcv_log_2021@002d09.frm to /var/lib/mysql/hisdb/tb_his_rcv_log_2021@002d09.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_rcv_log_2021@002d10.frm to /var/lib/mysql/hisdb/tb_his_rcv_log_2021@002d10.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./hisdb/tb_his_rcv_log_2021@002d11.frm to /var/lib/mysql/hisdb/tb_his_rcv_log_2021@002d11.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_ad_image.ibd to /var/lib/mysql/npsdb/tb_nps_ad_image.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_ad_reg.ibd to /var/lib/mysql/npsdb/tb_nps_ad_reg.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_appenvdate.ibd to /var/lib/mysql/npsdb/tb_nps_appenvdate.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_autoupdate.ibd to /var/lib/mysql/npsdb/tb_nps_autoupdate.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_client_pc.ibd to /var/lib/mysql/npsdb/tb_nps_client_pc.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_client_pc_app.ibd to /var/lib/mysql/npsdb/tb_nps_client_pc_app.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_dombo.ibd to /var/lib/mysql/npsdb/tb_nps_dombo.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_dombo_h.ibd to /var/lib/mysql/npsdb/tb_nps_dombo_h.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_emergency_passwd.ibd to /var/lib/mysql/npsdb/tb_nps_emergency_passwd.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_ad_category.ibd to /var/lib/mysql/npsdb/tb_nps_g_ad_category.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_adline.ibd to /var/lib/mysql/npsdb/tb_nps_g_adline.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_media.ibd to /var/lib/mysql/npsdb/tb_nps_g_media.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_theme.ibd to /var/lib/mysql/npsdb/tb_nps_g_theme.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_adsize.ibd to /var/lib/mysql/npsdb/tb_nps_g_adsize.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_paper.ibd to /var/lib/mysql/npsdb/tb_nps_g_paper.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_adsize_by_jam.ibd to /var/lib/mysql/npsdb/tb_nps_g_adsize_by_jam.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_dept.ibd to /var/lib/mysql/npsdb/tb_nps_g_dept.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_image_category.ibd to /var/lib/mysql/npsdb/tb_nps_g_image_category.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_print_type.ibd to /var/lib/mysql/npsdb/tb_nps_g_print_type.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_indd_char_style.ibd to /var/lib/mysql/npsdb/tb_nps_g_indd_char_style.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_kisa_type.ibd to /var/lib/mysql/npsdb/tb_nps_g_kisa_type.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_level.ibd to /var/lib/mysql/npsdb/tb_nps_g_level.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_jibang.ibd to /var/lib/mysql/npsdb/tb_nps_g_jibang.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_section.ibd to /var/lib/mysql/npsdb/tb_nps_g_section.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_kisa_category.ibd to /var/lib/mysql/npsdb/tb_nps_g_kisa_category.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_myun_name.ibd to /var/lib/mysql/npsdb/tb_nps_g_myun_name.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_pan.ibd to /var/lib/mysql/npsdb/tb_nps_g_pan.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_hosu.ibd to /var/lib/mysql/npsdb/tb_nps_hosu.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_image.ibd to /var/lib/mysql/npsdb/tb_nps_image.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_server_list.ibd to /var/lib/mysql/npsdb/tb_nps_g_server_list.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sj_image_category1.ibd to /var/lib/mysql/npsdb/tb_nps_g_sj_image_category1.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sj_image_category2.ibd to /var/lib/mysql/npsdb/tb_nps_g_sj_image_category2.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sojo_category.ibd to /var/lib/mysql/npsdb/tb_nps_g_sojo_category.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_hosu_holliday.ibd to /var/lib/mysql/npsdb/tb_nps_hosu_holliday.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_image_cut.ibd to /var/lib/mysql/npsdb/tb_nps_image_cut.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_image_h.ibd to /var/lib/mysql/npsdb/tb_nps_image_h.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_indd_server.ibd to /var/lib/mysql/npsdb/tb_nps_indd_server.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_indd_server_job.ibd to /var/lib/mysql/npsdb/tb_nps_indd_server_job.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_kisa.ibd to /var/lib/mysql/npsdb/tb_nps_kisa.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_kisa_h.ibd to /var/lib/mysql/npsdb/tb_nps_kisa_h.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_library.ibd to /var/lib/mysql/npsdb/tb_nps_library.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_library_h.ibd to /var/lib/mysql/npsdb/tb_nps_library_h.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun.ibd to /var/lib/mysql/npsdb/tb_nps_myun.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_h.ibd to /var/lib/mysql/npsdb/tb_nps_myun_h.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_output.ibd to /var/lib/mysql/npsdb/tb_nps_myun_output.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_output_h.ibd to /var/lib/mysql/npsdb/tb_nps_myun_output_h.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_pdf_comment.ibd to /var/lib/mysql/npsdb/tb_nps_myun_pdf_comment.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_pttn.ibd to /var/lib/mysql/npsdb/tb_nps_myun_pttn.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_pttn_h.ibd to /var/lib/mysql/npsdb/tb_nps_myun_pttn_h.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_pttn_sjimage.ibd to /var/lib/mysql/npsdb/tb_nps_myun_pttn_sjimage.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan.ibd to /var/lib/mysql/npsdb/tb_nps_plan.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan_ad.ibd to /var/lib/mysql/npsdb/tb_nps_plan_ad.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan_master.ibd to /var/lib/mysql/npsdb/tb_nps_plan_master.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan_master_title.ibd to /var/lib/mysql/npsdb/tb_nps_plan_master_title.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan_multipage.ibd to /var/lib/mysql/npsdb/tb_nps_plan_multipage.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_rip.ibd to /var/lib/mysql/npsdb/tb_nps_rip.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_rip_access.ibd to /var/lib/mysql/npsdb/tb_nps_rip_access.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_rip_job.ibd to /var/lib/mysql/npsdb/tb_nps_rip_job.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_sangju_image.ibd to /var/lib/mysql/npsdb/tb_nps_sangju_image.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_sangju_library.ibd to /var/lib/mysql/npsdb/tb_nps_sangju_library.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_sojo.ibd to /var/lib/mysql/npsdb/tb_nps_sojo.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_user.ibd to /var/lib/mysql/npsdb/tb_nps_user.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_user_level.ibd to /var/lib/mysql/npsdb/tb_nps_user_level.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_user_login.ibd to /var/lib/mysql/npsdb/tb_nps_user_login.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/db.opt to /var/lib/mysql/npsdb/db.opt
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_ad_image.frm to /var/lib/mysql/npsdb/tb_nps_ad_image.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_ad_reg.frm to /var/lib/mysql/npsdb/tb_nps_ad_reg.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_appenvdate.frm to /var/lib/mysql/npsdb/tb_nps_appenvdate.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_autoupdate.frm to /var/lib/mysql/npsdb/tb_nps_autoupdate.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_client_pc.frm to /var/lib/mysql/npsdb/tb_nps_client_pc.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_client_pc_app.frm to /var/lib/mysql/npsdb/tb_nps_client_pc_app.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_dombo.frm to /var/lib/mysql/npsdb/tb_nps_dombo.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_dombo_h.frm to /var/lib/mysql/npsdb/tb_nps_dombo_h.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_emergency_passwd.frm to /var/lib/mysql/npsdb/tb_nps_emergency_passwd.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_ad_category.frm to /var/lib/mysql/npsdb/tb_nps_g_ad_category.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_sojo_update.TRN to /var/lib/mysql/npsdb/tr_sojo_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adreg_insert.TRN to /var/lib/mysql/npsdb/tr_adreg_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_media.frm to /var/lib/mysql/npsdb/tb_nps_g_media.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_ad_category.TRG to /var/lib/mysql/npsdb/tb_nps_g_ad_category.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_sojo_insert.TRN to /var/lib/mysql/npsdb/tr_sojo_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adreg_update.TRN to /var/lib/mysql/npsdb/tr_adreg_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_sojo_delete.TRN to /var/lib/mysql/npsdb/tr_sojo_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adreg_delete.TRN to /var/lib/mysql/npsdb/tr_adreg_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_adline.frm to /var/lib/mysql/npsdb/tb_nps_g_adline.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adline_insert.TRN to /var/lib/mysql/npsdb/tr_adline_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_adline.TRG to /var/lib/mysql/npsdb/tb_nps_g_adline.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_pan_update.TRN to /var/lib/mysql/npsdb/tr_pan_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adline_update.TRN to /var/lib/mysql/npsdb/tr_adline_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_pan_delete.TRN to /var/lib/mysql/npsdb/tr_pan_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adline_delete.TRN to /var/lib/mysql/npsdb/tr_adline_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_adsize.frm to /var/lib/mysql/npsdb/tb_nps_g_adsize.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adsize_insert.TRN to /var/lib/mysql/npsdb/tr_adsize_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_theme.frm to /var/lib/mysql/npsdb/tb_nps_g_theme.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_adsize.TRG to /var/lib/mysql/npsdb/tb_nps_g_adsize.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_paper.TRG to /var/lib/mysql/npsdb/tb_nps_g_paper.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adsize_update.TRN to /var/lib/mysql/npsdb/tr_adsize_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_paper_insert.TRN to /var/lib/mysql/npsdb/tr_paper_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_adsize_delete.TRN to /var/lib/mysql/npsdb/tr_adsize_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_adsize_by_jam.frm to /var/lib/mysql/npsdb/tb_nps_g_adsize_by_jam.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_dept.frm to /var/lib/mysql/npsdb/tb_nps_g_dept.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_image_category.frm to /var/lib/mysql/npsdb/tb_nps_g_image_category.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_paper_update.TRN to /var/lib/mysql/npsdb/tr_paper_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory_insert.TRN to /var/lib/mysql/npsdb/tr_imagecategory_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_print_type.frm to /var/lib/mysql/npsdb/tb_nps_g_print_type.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_image_category.TRG to /var/lib/mysql/npsdb/tb_nps_g_image_category.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_paper_delete.TRN to /var/lib/mysql/npsdb/tr_paper_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory_update.TRN to /var/lib/mysql/npsdb/tr_imagecategory_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory_delete.TRN to /var/lib/mysql/npsdb/tr_imagecategory_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_indd_char_style.frm to /var/lib/mysql/npsdb/tb_nps_g_indd_char_style.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_kisacategory_delete.TRN to /var/lib/mysql/npsdb/tr_kisacategory_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_indd_char_style_insert.TRN to /var/lib/mysql/npsdb/tr_indd_char_style_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_indd_char_style.TRG to /var/lib/mysql/npsdb/tb_nps_g_indd_char_style.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_level.frm to /var/lib/mysql/npsdb/tb_nps_g_level.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_indd_char_style_update.TRN to /var/lib/mysql/npsdb/tr_indd_char_style_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_indd_char_style_delete.TRN to /var/lib/mysql/npsdb/tr_indd_char_style_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_jibang.frm to /var/lib/mysql/npsdb/tb_nps_g_jibang.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_section.frm to /var/lib/mysql/npsdb/tb_nps_g_section.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_jibang_insert.TRN to /var/lib/mysql/npsdb/tr_jibang_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_theme.TRG to /var/lib/mysql/npsdb/tb_nps_g_theme.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_jibang.TRG to /var/lib/mysql/npsdb/tb_nps_g_jibang.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_jibang_update.TRN to /var/lib/mysql/npsdb/tr_jibang_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_section.TRG to /var/lib/mysql/npsdb/tb_nps_g_section.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_jibang_delete.TRN to /var/lib/mysql/npsdb/tr_jibang_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_kisa_category.frm to /var/lib/mysql/npsdb/tb_nps_g_kisa_category.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_section_insert.TRN to /var/lib/mysql/npsdb/tr_section_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_kisacategory_insert.TRN to /var/lib/mysql/npsdb/tr_kisacategory_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_section_update.TRN to /var/lib/mysql/npsdb/tr_section_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_kisa_category.TRG to /var/lib/mysql/npsdb/tb_nps_g_kisa_category.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_server_list.frm to /var/lib/mysql/npsdb/tb_nps_g_server_list.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_kisacategory_update.TRN to /var/lib/mysql/npsdb/tr_kisacategory_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_kisa_type.frm to /var/lib/mysql/npsdb/tb_nps_g_kisa_type.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_theme_insert.TRN to /var/lib/mysql/npsdb/tr_theme_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_media_insert.TRN to /var/lib/mysql/npsdb/tr_media_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_theme_update.TRN to /var/lib/mysql/npsdb/tr_theme_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_media.TRG to /var/lib/mysql/npsdb/tb_nps_g_media.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_hosu.frm to /var/lib/mysql/npsdb/tb_nps_hosu.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_media_update.TRN to /var/lib/mysql/npsdb/tr_media_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_theme_delete.TRN to /var/lib/mysql/npsdb/tr_theme_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_media_delete.TRN to /var/lib/mysql/npsdb/tr_media_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_myun_name.frm to /var/lib/mysql/npsdb/tb_nps_g_myun_name.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_pan.frm to /var/lib/mysql/npsdb/tb_nps_g_pan.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_pan_insert.TRN to /var/lib/mysql/npsdb/tr_pan_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_image.frm to /var/lib/mysql/npsdb/tb_nps_image.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_pan.TRG to /var/lib/mysql/npsdb/tb_nps_g_pan.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_paper.frm to /var/lib/mysql/npsdb/tb_nps_g_paper.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_section_delete.TRN to /var/lib/mysql/npsdb/tr_section_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sj_image_category1.frm to /var/lib/mysql/npsdb/tb_nps_g_sj_image_category1.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory1_insert.TRN to /var/lib/mysql/npsdb/tr_imagecategory1_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sj_image_category1.TRG to /var/lib/mysql/npsdb/tb_nps_g_sj_image_category1.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory1_update.TRN to /var/lib/mysql/npsdb/tr_imagecategory1_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory1_delete.TRN to /var/lib/mysql/npsdb/tr_imagecategory1_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sj_image_category2.frm to /var/lib/mysql/npsdb/tb_nps_g_sj_image_category2.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory2_insert.TRN to /var/lib/mysql/npsdb/tr_imagecategory2_insert.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sj_image_category2.TRG to /var/lib/mysql/npsdb/tb_nps_g_sj_image_category2.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory2_update.TRN to /var/lib/mysql/npsdb/tr_imagecategory2_update.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tr_imagecategory2_delete.TRN to /var/lib/mysql/npsdb/tr_imagecategory2_delete.TRN
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sojo_category.frm to /var/lib/mysql/npsdb/tb_nps_g_sojo_category.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_g_sojo_category.TRG to /var/lib/mysql/npsdb/tb_nps_g_sojo_category.TRG
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_hosu_holliday.frm to /var/lib/mysql/npsdb/tb_nps_hosu_holliday.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_image_cut.frm to /var/lib/mysql/npsdb/tb_nps_image_cut.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_image_h.frm to /var/lib/mysql/npsdb/tb_nps_image_h.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_indd_server.frm to /var/lib/mysql/npsdb/tb_nps_indd_server.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_indd_server_job.frm to /var/lib/mysql/npsdb/tb_nps_indd_server_job.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_kisa.frm to /var/lib/mysql/npsdb/tb_nps_kisa.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_kisa_h.frm to /var/lib/mysql/npsdb/tb_nps_kisa_h.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_library.frm to /var/lib/mysql/npsdb/tb_nps_library.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_library_h.frm to /var/lib/mysql/npsdb/tb_nps_library_h.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun.frm to /var/lib/mysql/npsdb/tb_nps_myun.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_h.frm to /var/lib/mysql/npsdb/tb_nps_myun_h.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_output.frm to /var/lib/mysql/npsdb/tb_nps_myun_output.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_output_h.frm to /var/lib/mysql/npsdb/tb_nps_myun_output_h.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_pdf_comment.frm to /var/lib/mysql/npsdb/tb_nps_myun_pdf_comment.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_pttn.frm to /var/lib/mysql/npsdb/tb_nps_myun_pttn.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_pttn_h.frm to /var/lib/mysql/npsdb/tb_nps_myun_pttn_h.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_myun_pttn_sjimage.frm to /var/lib/mysql/npsdb/tb_nps_myun_pttn_sjimage.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan.frm to /var/lib/mysql/npsdb/tb_nps_plan.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan_ad.frm to /var/lib/mysql/npsdb/tb_nps_plan_ad.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan_master.frm to /var/lib/mysql/npsdb/tb_nps_plan_master.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan_master_title.frm to /var/lib/mysql/npsdb/tb_nps_plan_master_title.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_plan_multipage.frm to /var/lib/mysql/npsdb/tb_nps_plan_multipage.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_rip.frm to /var/lib/mysql/npsdb/tb_nps_rip.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_rip_access.frm to /var/lib/mysql/npsdb/tb_nps_rip_access.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_rip_job.frm to /var/lib/mysql/npsdb/tb_nps_rip_job.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_sangju_image.frm to /var/lib/mysql/npsdb/tb_nps_sangju_image.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_sangju_library.frm to /var/lib/mysql/npsdb/tb_nps_sangju_library.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_sojo.frm to /var/lib/mysql/npsdb/tb_nps_sojo.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_user.frm to /var/lib/mysql/npsdb/tb_nps_user.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_user_level.frm to /var/lib/mysql/npsdb/tb_nps_user_level.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./npsdb/tb_nps_user_login.frm to /var/lib/mysql/npsdb/tb_nps_user_login.frm
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./scmdb/tb_scm_adcode.ibd to /var/lib/mysql/scmdb/tb_scm_adcode.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./scmdb/tb_scm_adplan.ibd to /var/lib/mysql/scmdb/tb_scm_adplan.ibd
[01] 2021-11-11 07:05:37 ...done
[01] 2021-11-11 07:05:37 Copying ./scmdb/tb_scm_adsize_pantype.ibd to /var/lib/mysql/scmdb/tb_scm_adsize_pantype.ibd
[01] 2021-11-11 07:05:38 ...done
[01] 2021-11-11 07:05:38 Copying ./scmdb/tb_scm_authority.ibd to /var/lib/mysql/scmdb/tb_scm_authority.ibd
[01] 2021-11-11 07:05:38 ...done
[01] 2021-11-11 07:05:38 Copying ./scmdb/tb_scm_board.ibd to /var/lib/mysql/scmdb/tb_scm_board.ibd
[01] 2021-11-11 07:05:38 ...done
[01] 2021-11-11 07:05:38 Copying ./scmdb/tb_scm_branch.ibd to /var/lib/mysql/scmdb/tb_scm_branch.ibd
[01] 2021-11-11 07:05:38 ...done
[01] 2021-11-11 07:05:38 Copying ./scmdb/tb_scm_branch_jibang.ibd to /var/lib/mysql/scmdb/tb_scm_branch_jibang.ibd
[01] 2021-11-11 07:05:38 ...done
[01] 2021-11-11 07:05:38 Copying ./scmdb/tb_scm_branch_message.ibd to /var/lib/mysql/scmdb/tb_scm_branch_message.ibd
[01] 2021-11-11 07:05:38 ...done
[01] 2021-11-11 07:05:38 Copying ./scmdb/tb_scm_branch_pc.ibd to /var/lib/mysql/scmdb/tb_scm_branch_pc.ibd
[01] 2021-11-11 07:05:38 ...done
[01] 2021-11-11 07:05:38 Copying ./scmdb/tb_scm_branch_send_log.ibd to /var/lib/mysql/scmdb/tb_scm_branch_send_log.ibd
[01] 2021-11-11 07:05:49 ...done
[01] 2021-11-11 07:05:49 Copying ./scmdb/tb_scm_corp_id.ibd to /var/lib/mysql/scmdb/tb_scm_corp_id.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_dept_code.ibd to /var/lib/mysql/scmdb/tb_scm_dept_code.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_emergency_ctel.ibd to /var/lib/mysql/scmdb/tb_scm_emergency_ctel.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_emergency_tel.ibd to /var/lib/mysql/scmdb/tb_scm_emergency_tel.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_file.ibd to /var/lib/mysql/scmdb/tb_scm_file.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_gaepan_info.ibd to /var/lib/mysql/scmdb/tb_scm_gaepan_info.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_gaepan_msg.ibd to /var/lib/mysql/scmdb/tb_scm_gaepan_msg.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_jibang.ibd to /var/lib/mysql/scmdb/tb_scm_jibang.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_jibang_sep.ibd to /var/lib/mysql/scmdb/tb_scm_jibang_sep.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_jimyuncomment.ibd to /var/lib/mysql/scmdb/tb_scm_jimyuncomment.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_master_week.ibd to /var/lib/mysql/scmdb/tb_scm_master_week.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_media.ibd to /var/lib/mysql/scmdb/tb_scm_media.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_media_section_view.ibd to /var/lib/mysql/scmdb/tb_scm_media_section_view.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_mediasection_ad_type.ibd to /var/lib/mysql/scmdb/tb_scm_mediasection_ad_type.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_message_info.ibd to /var/lib/mysql/scmdb/tb_scm_message_info.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_myun_pattern.ibd to /var/lib/mysql/scmdb/tb_scm_myun_pattern.ibd
[01] 2021-11-11 07:05:50 ...done
[01] 2021-11-11 07:05:50 Copying ./scmdb/tb_scm_myun_plan.ibd to /var/lib/mysql/scmdb/tb_scm_myun_plan.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_myun_status.ibd to /var/lib/mysql/scmdb/tb_scm_myun_status.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_panbranchlist.ibd to /var/lib/mysql/scmdb/tb_scm_panbranchlist.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_pn_strd_gangpan_tm.ibd to /var/lib/mysql/scmdb/tb_scm_pn_strd_gangpan_tm.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_print_pattern.ibd to /var/lib/mysql/scmdb/tb_scm_print_pattern.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_progress_diary.ibd to /var/lib/mysql/scmdb/tb_scm_progress_diary.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_ps_user.ibd to /var/lib/mysql/scmdb/tb_scm_ps_user.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_region_info.ibd to /var/lib/mysql/scmdb/tb_scm_region_info.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_region_jibang.ibd to /var/lib/mysql/scmdb/tb_scm_region_jibang.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_section.ibd to /var/lib/mysql/scmdb/tb_scm_section.ibd
[01] 2021-11-11 07:05:51 ...done
[01] 2021-11-11 07:05:51 Copying ./scmdb/tb_scm_sendplan.ibd to /var/lib/mysql/scmdb/tb_scm_sendplan.ibd
[01] 2021-11-11 07:05:53 ...done
[01] 2021-11-11 07:05:53 Copying ./scmdb/tb_scm_trans_diary.ibd to /var/lib/mysql/scmdb/tb_scm_trans_diary.ibd
[01] 2021-11-11 07:05:53 ...done
[01] 2021-11-11 07:05:53 Copying ./scmdb/tb_scm_trans_today_cancel.ibd to /var/lib/mysql/scmdb/tb_scm_trans_today_cancel.ibd
[01] 2021-11-11 07:05:53 ...done
[01] 2021-11-11 07:05:53 Copying ./scmdb/tb_scm_trans_today_diary.ibd to /var/lib/mysql/scmdb/tb_scm_trans_today_diary.ibd
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_trans_user_diary.ibd to /var/lib/mysql/scmdb/tb_scm_trans_user_diary.ibd
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_trans_week.ibd to /var/lib/mysql/scmdb/tb_scm_trans_week.ibd
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_user.ibd to /var/lib/mysql/scmdb/tb_scm_user.ibd
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_work_log.ibd to /var/lib/mysql/scmdb/tb_scm_work_log.ibd
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/db.opt to /var/lib/mysql/scmdb/db.opt
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_adcode.frm to /var/lib/mysql/scmdb/tb_scm_adcode.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_adplan.frm to /var/lib/mysql/scmdb/tb_scm_adplan.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_adsize_pantype.frm to /var/lib/mysql/scmdb/tb_scm_adsize_pantype.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_authority.frm to /var/lib/mysql/scmdb/tb_scm_authority.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_board.frm to /var/lib/mysql/scmdb/tb_scm_board.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_branch.frm to /var/lib/mysql/scmdb/tb_scm_branch.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_branch_jibang.frm to /var/lib/mysql/scmdb/tb_scm_branch_jibang.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_branch_message.frm to /var/lib/mysql/scmdb/tb_scm_branch_message.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_branch_pc.frm to /var/lib/mysql/scmdb/tb_scm_branch_pc.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_branch_send_log.frm to /var/lib/mysql/scmdb/tb_scm_branch_send_log.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_corp_id.frm to /var/lib/mysql/scmdb/tb_scm_corp_id.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_dept_code.frm to /var/lib/mysql/scmdb/tb_scm_dept_code.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_emergency_ctel.frm to /var/lib/mysql/scmdb/tb_scm_emergency_ctel.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_emergency_tel.frm to /var/lib/mysql/scmdb/tb_scm_emergency_tel.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_file.frm to /var/lib/mysql/scmdb/tb_scm_file.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_gaepan_info.frm to /var/lib/mysql/scmdb/tb_scm_gaepan_info.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_gaepan_msg.frm to /var/lib/mysql/scmdb/tb_scm_gaepan_msg.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_jibang.frm to /var/lib/mysql/scmdb/tb_scm_jibang.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_jibang_sep.frm to /var/lib/mysql/scmdb/tb_scm_jibang_sep.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_jimyuncomment.frm to /var/lib/mysql/scmdb/tb_scm_jimyuncomment.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_master_week.frm to /var/lib/mysql/scmdb/tb_scm_master_week.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_media.frm to /var/lib/mysql/scmdb/tb_scm_media.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_media_section_view.frm to /var/lib/mysql/scmdb/tb_scm_media_section_view.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_mediasection_ad_type.frm to /var/lib/mysql/scmdb/tb_scm_mediasection_ad_type.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_message_info.frm to /var/lib/mysql/scmdb/tb_scm_message_info.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_myun_pattern.frm to /var/lib/mysql/scmdb/tb_scm_myun_pattern.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_myun_plan.frm to /var/lib/mysql/scmdb/tb_scm_myun_plan.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_myun_status.frm to /var/lib/mysql/scmdb/tb_scm_myun_status.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_panbranchlist.frm to /var/lib/mysql/scmdb/tb_scm_panbranchlist.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_pn_strd_gangpan_tm.frm to /var/lib/mysql/scmdb/tb_scm_pn_strd_gangpan_tm.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_print_pattern.frm to /var/lib/mysql/scmdb/tb_scm_print_pattern.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_progress_diary.frm to /var/lib/mysql/scmdb/tb_scm_progress_diary.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_ps_user.frm to /var/lib/mysql/scmdb/tb_scm_ps_user.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_region_info.frm to /var/lib/mysql/scmdb/tb_scm_region_info.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_region_jibang.frm to /var/lib/mysql/scmdb/tb_scm_region_jibang.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_section.frm to /var/lib/mysql/scmdb/tb_scm_section.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_sendplan.frm to /var/lib/mysql/scmdb/tb_scm_sendplan.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_trans_diary.frm to /var/lib/mysql/scmdb/tb_scm_trans_diary.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_trans_today_cancel.frm to /var/lib/mysql/scmdb/tb_scm_trans_today_cancel.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_trans_today_diary.frm to /var/lib/mysql/scmdb/tb_scm_trans_today_diary.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_trans_user_diary.frm to /var/lib/mysql/scmdb/tb_scm_trans_user_diary.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_trans_week.frm to /var/lib/mysql/scmdb/tb_scm_trans_week.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_user.frm to /var/lib/mysql/scmdb/tb_scm_user.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./scmdb/tb_scm_work_log.frm to /var/lib/mysql/scmdb/tb_scm_work_log.frm
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./test/db.opt to /var/lib/mysql/test/db.opt
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./aria_log_control to /var/lib/mysql/aria_log_control
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./aria_log.00000001 to /var/lib/mysql/aria_log.00000001
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool
[01] 2021-11-11 07:05:55 ...done
[01] 2021-11-11 07:05:55 Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
[01] 2021-11-11 07:05:55 ...done
[00] 2021-11-11 07:05:55 completed OK!EC2에서 운영중인 DB에서 data를 다 삭제한 후에 mysqldump를 테스트해보았다.
cd /var/lib/mysql
rm -rf *모든 datafile을 삭제했는데도 메모리에 있는 buffer 때문에 데이터 조회도 되고 , 심지어 insert와 commit도 정상작동했다.
--> commit시 redolog를 logfile로 저장하는데, 해당 logfile이 없으니 redolog 손실 발생하는가 ?
--> 모든 datafile삭제시 db를 shutdown시킨 이후에 다시 기동하는 것이 안됬다.
Nov 10 05:28:01 ip-172-31-6-25.ap-northeast-2.compute.internal mariadbd[4721]: 2021-11-10 5:28:01 0 [Note] Plugin 'FEEDBACK' is disabled.
Nov 10 05:28:01 ip-172-31-6-25.ap-northeast-2.compute.internal mariadbd[4721]: 2021-11-10 5:28:01 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
Nov 10 05:28:01 ip-172-31-6-25.ap-northeast-2.compute.internal mariadbd[4721]: 2021-11-10 5:28:01 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Nov 10 05:28:01 ip-172-31-6-25.ap-northeast-2.compute.internal mariadbd[4721]: 2021-11-10 5:28:01 0 [Note] Server socket created on IP: '::'.
Nov 10 05:28:01 ip-172-31-6-25.ap-northeast-2.compute.internal mariadbd[4721]: 2021-11-10 5:28:01 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist살펴보면 해당 디렉토리에 있는 mysql db를 비롯한 다른 시스템데이터베이스에서 정보를 가져와서 해당 내용을 기반으로 DB를 기동하는 것 같은데, 모든 파일을 삭제하니까 기동이 되지 않았다.
- Mariabackup 같은경우는 물리적인 백업/복구로 disk자체를 백업/복구 하는 과정이기 때문에 복원할 때 기존 datadir를 모두 삭제한 후에 디스크를 새로 쓰는식으로 복제가 이루어진다. -> OS단에서의 복원
하지만 mysqldump는 서버에서 DDL문을 하나씩 실행하며 복제하는 논리적 백업이기 때문에 기존 서버의 datadir자체를 삭제해버리면 서버 기동자체가 안되기 때문에 오류 -> DB단 복원
-> 따라서 용량 자체는 mariabackup이 mysqldump보다 크다, 속도는 mariabackup이 훨씬 빠르다.(mysqldump복원은 DDL을 하나씩 실행해야 하므로)
실력을 쌓아가는 하루하루