MySql 6.11 Compile on Ubuntu 9.04

MySql install notes on Ubuntu 9.04
If you use this, you may have to read in between the lines here and there. I wasn't able to get the icc already compiled version to work b/c of a syntax error with my_print_defaults. But I compiled it from source and its working perfect. The sub-query system is so much faster, its unbelievable. I recommend using the mysql6-falcon alpha linux source install.

Compile Mysql6-falcon for ubuntu 9.04.

# http://www.howtoforge.com/mysql5_debian_sarge
# http://mapopa.blogspot.com/2009/03/compiling-mysql6.html

# get mysql source

# copy source - compile from this - do this incase you mess up
cp -R mysql-6.0.10-alpha mysql6

cd ./mysql6

sudo apt-get install build-essential
sudo apt-get install lib64ncurses5 libncurses5 libncurses5-dbg libncurses-dev
sudo apt-get install autoconf libtool

# auto configure
autoreconf -vif

# configure options
#./configure --help

#it was weird it stuck some stuff in the data directory that probably shouldn't be there but is fixable afterwords. I moved it to basedir/share/mysql
./configure --prefix=/srv/mysql6 --datadir=/mnt/ssd/mysql
#./configure --prefix=/srv/mysql6_11 #upgrading to .11

make

sudo make install



# copied my.cnf to /etc/mysql/my.cnf and linked /etc/my.cnf
# set [mysqld] datadir=/srv/mysql6 basedir=/srv/ssd/mysql

# add user and group
# set perimissions where needed

# setup the default system
./bin/mysql_install_db --user=mysql --basedir=/srv/mysql6 --builddir=/home/branflake2267/downloads/mysql6b --datadir=/mnt/ssd/mysql
#./bin/mysql_install_db --user=mysql --basedir=/srv/mysql6_11 --builddir=/home/branflake2267/downloads/mysql-6.0.11-alpha

# add hash next to skip-federated - notate it

#add ./share/mysql/mysql.server to /etc/init.d/mysql.server

# change basedir and datadir in mysql.server

# link ./bin/mysql to /usr/bin/mysql

# start server
sudo /etc/init.d/mysql.server start

# mysql - no password exists for root localhost user yet
./bin/mysql -uroot -p


# add user
CREATE USER 'Branflake2267'@'localhost' IDENTIFIED BY 'password*7';
GRANT ALL PRIVILEGES ON *.* TO 'Branflake2267'@'localhost' WITH GRANT OPTION;
flush privileges;



#mysqls help./b
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> gunzip <> cd mysql-VERSION
shell> ./configure --prefix=/usr/local/mysql
shell> make
shell> make install
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql var
shell> bin/mysqld_safe --user=mysql &

My data project wiki notes - http://code.google.com/p/parsecsv2sql/w/edit/mysql6_falcon_install