블로그 이미지
bedbmsguru

Notice

Recent Post

Recent Comment

Recent Trackback

Archive

calendar

1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28
  • total
  • today
  • yesterday
2017. 12. 21. 11:59 maridb&mysql

innobackupex 로 백업도중 아래와 같은 에러가 발생할 경우


./xtrabackup --defaults-file=/etc/my.cnf --backup --datadir=/var/lib/mysql/ --target-dir=/home/backup_dir/full/ --user=root --password=12345

Can't locate Digest/MD5.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at - line 693.
BEGIN failed--compilation aborted at - line 693.
Connecting to MySQL server host: (null), user: root, password: set, port: 0, socket: /var/lib/mysql/mysql.sock



의존성 오류이므로 해당 rpm을 설치해주면 된다.



yum install perl-Digest-MD5

'maridb&mysql' 카테고리의 다른 글

procedure 생성 템플릿  (0) 2018.10.26
Function 템플릿  (0) 2018.10.26
Foreign key 정보조회 및 삭제  (0) 2018.10.26
mariadb (mysql)백업  (0) 2018.10.26
mariadb 설치  (0) 2017.12.26
posted by bedbmsguru
2017. 12. 6. 17:52 Zabbix

(1).Configuration--> HostGroups 에 신규그룹 추가


(2).Administrator --> UserGroups 신규그룹 추가

  Permissions 에 권한부여할 HostGroups 추가

  Windows 일경우 Discovered hosts에대한 read write권한 필요


(3).Administrator -->Users 신규사용자 추가 -->Media생성

   , Permissions --> User type은 zabbix Admin


(4).Configuration  --> Actions 추가

posted by bedbmsguru
2017. 11. 8. 16:05 SQL SERVER
Backup , Restore 진행현황을 %로 보여줌


SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete,
      dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time
FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a

WHERE r.command in ('BACKUP DATABASE','RESTORE DATABASE');




posted by bedbmsguru