열린 작업방

◆ 설치환경 Pentium 4 CPU 2.6GHz RAM 2GB Microsoft Windows XP Professional Version 2002 Service Pack2 VMware Workstation 4.5.2 build-8848 Redhat Linux 9 (2.4.20) HDD 20GB, RAM 1740MB ◆ 계정 생성 [root@localhost root]# groupadd dba [root@localhost root]# groupadd oinstall [root@localhost root]# useradd -g oinstall -G dba oracle [root@localhost root]# passwd oracle ◆ 디렉토리 생성 [root@localhost root]# mkdir -p..

A utility like mysqldump is very useful for backing up MySQL data and table schema. However, backups are usually made only once a day or at some other regular interval. If data is lost on your system several hours after the last backup is completed, you may not be able to recover it. There are a few methods by which you can continuously protect data. One method that you can use to be able to rec..

1. user를 등록하는데 모든권한을 N 로 해서 추가합니다. mysql> select * from user; +---------------+----------+-------------------------------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+----------------..

HOWTO set up a MySQL Cluster for two servers (three servers required for true redundancy) Introduction This HOWTO was designed for a classic setup of two servers behind a loadbalancer. The aim is to have true redundancy - either server can be unplugged and yet the site will remain up. Notes: You MUST have a third server as a managment node but this can be shut down after the cluster starts. Also..

FreeBSD4.10-CURRENT + Oracle8i (8.1.7) 설치하기.. [ 출처: http://database.sarang.net] -------------------------------------------------------------------- 맨 먼저 Linux-6.1을 설치합니다. # /usr/port/emulators/linux_base-6/ linux_base-6.1_6 이 설치된다. make install clean # /usr/port/devel/linux_devtools-6/ linux_devtools-6.1_1이 설치된다. make install clean Linux-7.1을 설치하면 안됩니다. Oracle8i가 glib-2.1을 필요로 하기 때문입니다 Linux-7...

MySQL-3.23.57-1.i386.rpm MySQL-client-3.23.57-1.i386.rpm MySQL-devel-3.23.57-1.i386.rpm MySQL-Max-3.23.57-1.i386.rpm MySQL-shared-3.23.57-1.i386.rpm rpm -ivh * /etc/rc.d/init.d/mysql stop cd /var/lib ls mkdir /home/mysql mv mysql /home/mysql/data cd /var/lib/ ls -al /home/mysql/data ln -s /home/mysql/data mysql cd /home/mysql ln -s /usr/include/mysql /home/mysql/include ln -s /usr/lib/mysql /hom..

# mysql.php

Chapter 4: Database Administration 189 port=3306 socket=/tmp/mysql.sock no auto rehash The above output contains all options for the groups 'client' and 'mysql'. 4.1.3 Installing Many Servers on the Same Machine In some cases you may want to have many different mysqld daemons (servers) running on the same machine. You may for example want to run a new version of MySQL for testing together with a..

※ 기존의 mysql이 설치되어 있다고 가정. cp /etc/my.cnf /etc/my1.cnf cp /etc/my.cnf /etc/my2.cnf - port, socket, server-id 변경. cp /opt/mysql/data /opt/mysql2/data cp /opt/mysql/data /opt/mysql3/data /usr/sbin/mysqld-max --defaults-file=/etc/my2.cnf --user=mysql --datadir=/home/mysql2/data --pid-file=/var/lib/mysql3onu.pid & /usr/sbin/mysqld-max --defaults-file=/etc/my2.cnf --user=mysql --datadir=/home/mysql2/d..

1. 소스 파일이나 소스 파일을 구합니다. (저의 경우는 /usr/local/src 에 저장했습니다.) mysql-3.23.38.tar.gz 2. 소스 파일의 압축을 풉니다. #tar xvzf mysql-3.23.38.tar.gz 3. 이때 생성된 mysql-3.23.38 디렉토리로 이동합니다. #cd mysql-3.23.38 3.1. MySQL 3.23.38에 포함된 InnoDB는 몇가지 버그가 있습니다. http://www.innodb.com 에서 Bug and fix 메뉴에 가시면 내용 있습니다. mysql/innobase/include/page0cur.ic 의 173 라인 수정 page_cur_search_with_match(page, tuple, mode, &up_matched_fields, &..