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/-
fyi: http://stackoverflow.com/questions/8192287/-

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

 June 16, 2016

 Blog | #Command #Debian #DirectAdmin #MySQL

	Facebook Twitter Line It Telegram Pinterest Email