세상의 중심 여기다!!

What's New in Disk Management? This section describes new disk management features in the Solaris release. Solaris iSCSI Target Support Solaris iSCSI Initiator Support Disk Management in the GRUB Boot Environment Support for SCSI Disks That are Larger Than 2 Tbytes For a complete listing of new Solaris features and a description of Solaris releases, see What’s New in Solaris Express.

MySQL 테이블 수정 이름 바꾸기mysql> ALTER TABLE tablename RENAME bbs; 컬럼 속성 수정mysql> ALTER TABLE tablename MODIFY colname INT NOT NULL AUTO_INCREMENT PRIMARY KEY; ALTER TABLE tablename MODIFY 컬럼이름 컬럼속성 컬럼 이름 바꾸기mysql> ALTER TABLE tablename CHANGE colname newcolname INT NOT NULL AUTO_INCREMENT; CHANGE는 컬럼 속성뿐아니라 이름도 바꿔준다. 컬럼 추가mysql> ALTER TABLE bbs ADD name varchar(10); ALTER TABLE tablename ADD 컬럼이름 컬럼속성..

./configure --prefix=/usr/local/php --with-exec-dir=/usr/bin --with-apxs2=/usr/local/apache/bin/apxs --with-apache-install=/usr/local/apache --with-mysql=/usr/local/mysql --with-config-file-path=/etc --disable-debug --enable-safe-mode --enable-track-vars --enable-sockets --enable-exif --with-png-dir=/usr/lib --with-freetype-dir=/usr --with-mod_charset --with-charset=euc_kr --with-xml --with-lang..

./configure --prefix=/usr/local/php --with-apxs2=/usr/local/apache/bin/apxs \ --with-mysql=/usr/local/mysql --disable-debug --enable-sockets --with-language=korean \ --with-charset=euc_kr --enable-modules=so --enable-trans-sid --with-config-file-path=/usr/local/apache/conf \ --with-execdir=/usr/local/apache/bin --with-gd=/usr/local --enable-gd-native-ttf --enable-gd --with-jpeg-dir=/usr/local \ ..

APM 설치시(DSO) 1. RPM으로 설치된 Package제거 % killall httpd % ps -ef | grep httpd % killall mysqld % rpm -e apache % rpm -e apache-devel % rpm -e php % rpm -e imap % rpm -e mysql 2. mysql 설치 주의 ) 시간이 다소 필요 % ./configure --prefix=/usr/local/mysql --with-charset=euc_kr % make % make install % cd /usr/local/mysql/bin % ./mysql_install_db [root:/usr/local/mysql/share/mysql] groupadd mysql [root:/usr/local/m..

ntsysv 에 등록을 하시려면 일단 chkconfig 쪽에 올라와야합니다. 우선 /etc/init.d로 이동하셔서 vi httpd 하신다음에요. 아래 내용을 복사해서 붙이세요 #!/bin/bash # # chkconfig: - 50 50 # description: init file for Apache2 server daemon # processname: /usr/local/apache2/apachectl # config: /usr/local/apache2/conf/httpd.conf # pidfile: /usr/local/apache2/logs/httpd.pid # # source function library . /etc/rc.d/init.d/functions # pull in sysconfig se..

apm 설치순서 mysql 설치전 점검 : rpm -qa | grep mysql ->존재하면 지움 (1) zlib 설치 zlib은 압축과 관련된 라이브러리 입니다. [root@localhost local]# cd /usr/local/src [root@localhost src]# wget http://ftp.superuser.co.kr/pub/etc/zlib-1.1.4.tar.gz [root@localhost src]# tar xvfz zlib-1.1.4.tar.gz [root@localhost src]# cd zlib-1.1.4 [root@localhost zlib-1.1.4]# ./configure && make && make install [root@localhost zlib-1.1.4]# cd ....

# vi /usr/local/mysql/share/mysql/mysql.server - 편집기로 열어서 safe_mysql이 실행되는 라인(119라인)에 --language=korean 옵션을 추가. $bindir/safe_mysqld --pid-file=$pid_file --datadir=$datadir --language=korean & 한글메세지를 띄우도록 해준다. - 시스템 부팅시에 자동 실행되도록 설정 # cp -p /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqld # ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc3.d/S90mysqld # /etc/rc.d/init.d/mysqld start # ..

ASIANUX에서 최초 MySQL Daemon을 아래의 명령어에 의해서 실행 시킬 경우, 다음과 같은 에러 메세지가 나타난다. #mysqld_safe --user=mysql & [root@tekstudio bin]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 050901 12:47:43 mysqld ended [1]+ Done mysqld_safe --user=mysql /var/log/mysqld.log에서 다음과 같은 내용을 확인 할 수 있다. 050901 10:58:29 mysqld started 050901 10:58:29 InnoDB:..

2.9 MySQL Installation Using a Source Distribution ================================================== * Menu: * quick-install:: Source Installation Overview * configure-options:: Typical `configure' Options * installing-source-tree:: Installing from the Development Source Tree * compilation-problems:: Dealing with Problems Compiling MySQL * mit-pthreads:: MIT-pthreads Notes * windows-source-buil..