열린 작업방

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, &..

[root@dbbackup backup]# mysqldump --help mysqldump Ver 8.22 Distrib 3.23.57, for pc-linux (i686) By Igor Romanenko, Monty, Jani & Sinisa This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Dumping definition and data mysql database or table Usage: mysqldump [OPTIONS] database [tables] OR mysqldump [OPTION..

modsecurity ############################################################################ Homepage : http://www.modsecurity.org Documentation : http://www.modsecurity.org/documentation/index.html Download : http://www.modsecurity.org/download/direct.html (latest version : modsecurity-apache_2.5.2.tar.gz (20080422) Requirement : liblua5.1.so OS : CentOS5.1 Webserver : Apache / 2.2.3 ##############..