2017年06月21日

MySQL5.6をソースからインストール

MySQL5.6をソースからインストール

【参考】CentOS6.x - CentOS6.3でMySQL5.6.14をソースからインストール - Qiitahttp://qiita.com/nobu_blast/items/dfe92a7c14136d1dafe9
CentOS 6.4にMySQL5.6をソースからインストール - /dev/nullhttp://gitpub.hatenablog.com/entry/2013/07/16/010544


wget ftp://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.6/mysql-5.6.35.tar.gz
tar xzvf mysql-5.6.35.tar.gz

wget http://www.cmake.org/files/v3.3/cmake-3.3.1.tar.gz# tar xzvf cmake-3.3.1.tar.gz# cd cmake-3.3.1# ./configure# make# porg -lD "make install"



sudo yum -y install cmake


http://www.eastforest.jp/esthome/mysql/3521



yum install cmake
yum install ncurses-devel
yum install zlib-devel
yum install readline-devel
yum install bison
wget http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz

vi /usr/local/src/mysql-5.6.35/cmake/boost.cmake

wget ftp://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.6/mysql-5.6.35.tar.gz
tar xzvf mysql-5.6.35.tar.gz

yum -y install cmake
yum install ncurses-devel
rm CMakeCache.txt
#cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/var \
-DSYSCONFDIR=/usr/local/mysql/var \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_EXTRA_CHARSETS=complex \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/var/mysql.sock


cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DENABLED_LOCAL_INFILE=true \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_EXTRA_CHARSETS=all


cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
Curses library not found. Please install appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.


cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
→ CMakeCache.txt削除し忘れ
# rm CMakeCache.txt
# cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
# make





cmake . \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.6.35 \-DDEFAULT_CHARSET=utf8 \-DWITH_EXTRA_CHARSETS=all \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_PIC=1




sudo yum install gcc-c++ make cmake ncurses-devel perl




MySQL - 5.6.11 ソースビルドでインストール(on Linux Mint)!
http://www.mk-mode.com/octopress/2013/05/30/mysql-5-6-install-by-src-build-to-mint/
posted by a23 at 09:07| Comment(0) | MySQL

2017年06月16日

CentOS6 MySQL 5.1 -> 5.6


ftp://ftp.jaist.ac.jp/pub/mysql//Downloads/MySQL-5.6/

posted by a23 at 17:15| Comment(0) | MySQL

2017年06月14日

MySQL設定確認

ストレージエンジン

create table t1 (a int, b int) engine innodb;create table t2 (a int, b int) engine myisam;

show engines;

use information_schema;
select table_name, engine from tables

posted by a23 at 10:13| Comment(0) | MySQL