How to upgrade MySQL 5.5.x to 5.6.x with DirectAdmin

debian 6.0.10
php 5.5.36
directadmin custombuild 1.2

upgrade >> mysql 5.5.9 to 5.6.29

apt-get update
apt-get upgrade
apt-get install libncurses5-dev

cd /root
wget http://files10.directadmin.com/services/custombuild/cmake-2.8.11.tar.gz
tar xzf cmake-2.8.11.tar.gz
cd cmake-2.8.11
./configure
make
make install
ref: http://help.directadmin.com/item.php?id=494

find / | grep libncurses.so
/usr/lib/libncurses.so
find / | grep curses.h
/usr/include/curses.h
find / | grep FindCurses.cmake
/usr/local/share/cmake-2.8/Modules/FindCurses.cmake
vim /usr/local/share/cmake-2.8/Modules/FindCurses.cmake
#Add these top of file after comments.
set( CMAKE_INCLUDE_PATH "/usr/include")
set( CMAKE_LIBRARY_PATH "/usr/lib/libncurses.so")
it can fix error CMake
— Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:83 (MESSAGE):
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.
Call Stack (most recent call first):
cmake/readline.cmake:127 (FIND_CURSES)
cmake/readline.cmake:217 (MYSQL_USE_BUNDLED_LIBEDIT)
CMakeLists.txt:257 (MYSQL_CHECK_READLINE)
ref: http://dba.stackexchange.com/questions/9654/could-not-find-curses-error-when-installing-mysql-from-source
fyi: http://stackoverflow.com/questions/8192287/curses-library-not-found

Upgrade MySQL 5.5.X To 5.6.X

cd /usr/local/directadmin/custombuild
./build set mysql 5.6
./build set mysql_inst yes
./build set mysql_backup yes
./build update
./build mysql

#when upgrade mysql complete and next
./build set mysql_inst no
./build php n
#check phpinfo() again

and additional
./build set phpmyadmin_ver 4
./build update
./build phpmyadmin

./build versions
./build update_versions

fix error libmysqlclient.so.16
Starting DirectAdmin: /usr/local/directadmin/directadmin: error while loading shared libraries: libmysqlclient.so.16: cannot open shared object file: No such file or directory
cd /usr/local/mysql/lib
rm -f libmysqlclient.so.16

apt-get update
apt-get install libmysqlclient16
ref: http://forum.directadmin.com/showthread.php?t=36869&page=2&p=205416#post205416

Blog | , , ,
Line it!