내블로그

1. 패키지 설치yum updateyum install iftop iptraf bind-utils rsync wget rdate vim-enhancedyum install httpd mod_dav_svn subversion expect 2. HTTPD 설정 (httpd.conf) ServerName dev.domain.com ServerAlias dev.domain.com ErrorLog /var/log/httpd/error_log CustomLog /var/log/httpd/access_log common DocumentRoot "/var/www/html/update/svn_repo" DAV svn SVNPath "/var/www/html/update/svn_repo" AuthType Basic Aut..

# 특정 DATABASE 또는 TABLE 백업 / 복구 1. 백업pg_dump [database name] -t [table name] --username=[id] -W -h 127.0.0.1 > [dump.file.name] 2. 복구psql -f [dump.file.name] [database name] --username=[id] -W -h 127.0.0.1 # 전체 DATABASE 백업 / 복구1. 백업pg_dumpall --username=[id] -W -h 127.0.0.1 > [dump.file.name] 2. 복구psql -f [dump.file.name] template1 --username=[id] -W -h 127.0.0.1

# 계정생성grant all privileges on *.* to 'db_user_id'@'%' identified by 'db_user_pwd' with grant option; # 변경사항 저장flush privileges;