[[FreeBSD/インストール9.1-RC3 king仕様 その2]]

----------------------------
#contents
----------------------------

mkdir /log
mkdir /data
mkdir /data/pub
mkdir /data/pub/king
mkdir /data/pub/honbu

vi fstab 
# Device        Mountpoint      FStype  Options Dump    Pass#
/dev/mirror/p2  /               ufs     rw      1       1
/dev/mirror/p4  /log            ufs     rw      2       2
/dev/mirror/p5  /data           ufs     rw      2       2
/dev/stripe/p3  none            swap    sw      0       0
 mkdir /log
 mkdir /data
 mkdir /data/pub
 mkdir /data/pub/king
 mkdir /data/pub/honbu

/usr/local/etc/rc.d/mysql-server stop
cd /var/db/
mv mysql /data/
ln -s /data/mysql  mysql
 vi fstab 
 # Device        Mountpoint      FStype  Options Dump    Pass#
 /dev/mirror/p2  /               ufs     rw      1       1
 /dev/mirror/p4  /log            ufs     rw      2       2
 /dev/mirror/p5  /data           ufs     rw      2       2
 /dev/stripe/p3  none            swap    sw      0       0

vi /var/db/mysql/
[mysqld]
max_connections=1000
thread_cache=100
character-set-server=eucjpms
skip-character-set-client-handshake
 /usr/local/etc/rc.d/mysql-server stop
 cd /var/db/
 mv mysql /data/
 ln -s /data/mysql  mysql

/usr/local/etc/rc.d/mysql-server start
 vi /var/db/mysql/
 [mysqld]
 max_connections=1000
 thread_cache=100
 character-set-server=eucjpms
 skip-character-set-client-handshake

pkg_add -rv rsync
 /usr/local/etc/rc.d/mysql-server start

rsync -av kazuto:/usr/local/share/PHPExcel-1.7.7/ /usr/local/share/PHPExcel-1.7.7/
rsync -av kazuto:/usr/local/share/fpdf/ /usr/local/share/fpdf/
 pkg_add -rv rsync

rsync -av --delete kazuto:/data/pub/king/ /data/pub/kens/
rsync -av --delete kazuto:/data/pub/honbu/ /data/pub/honbu/
 rsync -av kazuto:/usr/local/share/PHPExcel-1.7.7/ /usr/local/share/PHPExcel-1.7.7/
 rsync -av kazuto:/usr/local/share/fpdf/ /usr/local/share/fpdf/

cd /data
mysqldump -hkazuto -ukenji -p******* --databases honbu king  > king.sql.dump
mysql -p******** < king.sql.dump
 rsync -av --delete kazuto:/data/pub/king/ /data/pub/kens/
 rsync -av --delete kazuto:/data/pub/honbu/ /data/pub/honbu/

cd /usr/local/etc/apache22/extra/
vi httpd-vhosts.conf
 cd /data
 mysqldump -hkazuto -ukenji -p******* --databases honbu king  > king.sql.dump
 mysql -p******** < king.sql.dump

cd ../
vi http.conf
 cd /usr/local/etc/apache22/extra/
 vi httpd-vhosts.conf

# Virtual hosts
Include etc/apache22/extra/httpd-vhosts.conf
 cd ../
 vi http.conf

 # Virtual hosts
 Include etc/apache22/extra/httpd-vhosts.conf

 
----
[[FreeBSD]]


トップ   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS