最終更新: yamashitatakuya 2009年07月08日(水) 18:06:38履歴
これを端末に貼り付けて実行すると全て完了するハズ。
ユーザの作成
sudo groupadd mysql sudo useradd -g mysql -d /usr/local/mysql mysql sudo passwd mysql sudo chown -R mysql.mysql /usr/local/mysql
mecab のインストール
wget http://jaist.dl.sourceforge.net/sourceforge/mecab/mecab-0.97.tar.gz tar zxvf mecab-0.97.tar.gz cd mecab-0.97 ./configure --prefix=/usr/local/mecab-0.97 make && sudo make install cd ..
mecab辞書 のインストール
wget http://jaist.dl.sourceforge.net/sourceforge/mecab/mecab-ipadic-2.7.0-20070801.tar.gz tar zxvf mecab-ipadic-2.7.0-20070801.tar.gz cd mecab-ipadic-2.7.0-20070801 ./configure --prefix=/usr/local/mecab-0.97 --with-mecab-config=/usr/local/mecab-0.97/bin/mecab-config --with-charset=utf8 make && sudo make install cd ..
senna のインストール
wget http://osdn.dl.sourceforge.jp/senna/33763/senna-1.1.4.tar.gz tar zxvf senna-1.1.4.tar.gz cd senna-1.1.4 ./configure --prefix=/usr/local/senna-1.1.4 --with-sennahome=/usr/local/senna-1.1.4/var --with-mecab --with-mecab-config=/usr/local/mecab-0.97/bin/mecab-config make && sudo make install sudo mkdir -p /usr/local/senna-1.1.4/var sudo echo "DEFAULT_ENCODING utf8" > senna.conf sudo mv senna.conf /usr/local/senna-1.1.4/var wget -O bindings/mysql/mysql-5.1.15-beta.senna.make-fix.diff "http://svn.yamashita.to/repos/public/senna/tags/RELEASE-1.1.4/bindings/mysql/mysql-5.1.15-beta.senna.make-fix.diff" cd ..
MySQL のインストール
wget http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.15-beta.tar.gz tar zxvf mysql-5.1.15-beta.tar.gz cd mysql-5.1.15-beta patch -p1 < ../senna-1.1.4/bindings/mysql/mysql-5.1.15-beta.senna.diff patch -p1 < ../senna-1.1.4/bindings/mysql/mysql-5.1.15-beta.senna.2ind.diff patch -p1 < ../senna-1.1.4/bindings/mysql/mysql-5.1.15-beta.senna.make-fix.diff libtoolize -c -f aclocal-1.9 autoheader automake-1.9 -c -a -i autoconf touch sql/sql_yacc.yy ./configure --prefix=/usr/local/mysql-5.1.15-beta --with-plugins=all --with-senna=/usr/local/senna-1.1.4 --with-mecab=/usr/local/mecab-0.97 --with-charset=utf8 --with-extra-charsets=complex --without-readline make && sudo make install sudo cp -p ./support-files/my-medium.cnf /usr/local/mysql-5.1.15-beta/my.cnf sudo ./scripts/mysql_install_db sudo chown -R mysql:mysql /usr/local/mysql-5.1.15-beta/var chmod +x ./support-files/mysql.server sudo ./support-files/mysql.server start /usr/local/mysql-5.1.15-beta/bin/mysqladmin version sudo ln -s /usr/local/mysql-5.1.15-beta /usr/local/mysql cd ..
MySQL にユーザ「test」の作成
echo "GRANT ALL ON *.* TO test@'localhost' IDENTIFIED BY 'test';" > grant.sql sudo /usr/local/mysql-5.1.15-beta/bin/mysql < grant.sql
テスト SQL を実行
echo "USE test" > test.sql echo "CREATE TABLE table01" >> test.sql echo "(" >> test.sql echo " id INT(11) NOT NULL AUTO_INCREMENT," >> test.sql echo " text01 TEXT," >> test.sql echo " PRIMARY KEY (id)," >> test.sql echo " FULLTEXT INDEX USING NGRAM (text01)" >> test.sql echo ");" >> test.sql echo "INSERT INTO table01 (text01) VALUES('テストだよ');" >> test.sql echo "INSERT INTO table01 (text01) VALUES('テストです');" >> test.sql echo "INSERT INTO table01 (text01) VALUES('this is a test.');" >> test.sql echo "SELECT * FROM table01 WHERE MATCH(text01) AGAINST('テス');" >> test.sql echo "SELECT * FROM table01 WHERE MATCH(text01) AGAINST('test');" >> test.sql echo "DROP TABLE table01;" >> test.sql sudo /usr/local/mysql-5.1.15-beta/bin/mysql < test.sql
とりあえず動いたので削除
cd mysql-5.1.15-beta sudo ./support-files/mysql.server stop cd .. sudo rm -f /usr/local/mysql sudo rm -rf /usr/local/mysql-5.1.15-beta sudo rm -rf /usr/local/senna-1.1.4 sudo rm -rf /usr/local/mecab-0.93 rm -rf mysql-5.1.15-beta rm -f mysql-5.1.15-beta.tar.gz rm -rf senna-1.1.4 rm -f senna-1.1.4.tar.gz rm -rf mecab-ipadic-2.7.0-20070801 rm -f mecab-ipadic-2.7.0-20070801.tar.gz rm -rf mecab-0.97 rm -f mecab-0.97.tar.gz rm -f grant.sql rm -f test.sql
コメントをかく