source: npl/commonservers/mysql5/post.mysqld @ 0105685

#!/bin/bash
#(C)DatuX

#update ld.so.conf paths
if ! grep /usr/lib/mysql /etc/ld.so.conf; then
    echo /usr/lib/mysql >> /etc/ld.so.conf || exit 1
    ldconfig
fi

svcstop /service/mysql || exit 1

#update config file
mv /etc/my.cnf.new /etc/my.cnf 

#still uses old ib_logfile-size?
if [ `stat -c %s /home/system/mysql5/ib_logfile0` -lt 60000000 ]; then 
        mv /home/system/mysql5/ib_logfile0 /home/system/mysql5/ib_logfile0.old
        mv /home/system/mysql5/ib_logfile1 /home/system/mysql5/ib_logfile1.old
fi

#no mysql 5.x database yet?
if [ ! -d /home/system/mysql5/mysql ]; then
        touch /etc/my.passwd
        #convert mysql4 database?
        #WARNING: you cant convert from 4.1 to 5.1 directly, you first need to upgrade from 4.1 to 5.0!
        if [ -d /home/system/mysql ]; then
                echo "* Converting mysql 4 database to 5.0:"
                svcstop /service/mysql || exit 1

                #the database can be huge, so make sure nothing bad happens if cp gets aborted:
                rm -r /home/system/mysql5.tmp &>/dev/null
                cp -a /home/system/mysql /home/system/mysql5.tmp || exit 1
                mv /home/system/mysql5.tmp /home/system/mysql5 || exit 1

                #we need to run the database to update it
                svcstart /service/mysql || exit 1
                mysql_upgrade --password=`cat /etc/my.passwd` || exit 1
                
                #a restart is recommended after upgrading
                svcstop /service/mysql

        else
                #create new empty database
                svcstop /service/mysql || exit 1
                mkdir -p /home/system/mysql5 || exit 1
                chown mysql:mysql /home/system/mysql5 || exit 1
                chmod 750 /home/system/mysql5 || exit 1
                su mysql -c "mysql_install_db --force" || exit 1
        fi

        #fix the root password and other stuff if neccesary on the new/converted database:
        syn3-mysqlfix || exit 1
#database exists, upgrade it:
else
        echo "* Running mysql database upgrade:"
        #run a 'regular' upgrade on any existing database
        svcstart /service/mysql || exit 1
        mysql_upgrade --password=`cat /etc/my.passwd`
        #a restart is recommended after upgrading
        svcstop /service/mysql

fi

svcreset /service/mysql || exit 1