linux 免安装数据库,免安装执行mysql，并且导入数据库（Linux）

#!/bin/bash

MYSQL_VERSION='mysql-5.5.32-linux2.6-i686'

MYSQL_PACKAGE='mysql-5.5.32-linux2.6-i686.tar.gz'

LIBAIO_PACKAGE='libaio-0.3.106-5.i386.rpm'

LOCK_FILE='wot.lock'

CURRENT_DIR=$(cd "$(dirname $0)"; pwd)

############################################

function isStartSuccess()

{

count=10

isSuccess=0

while [ $count -lt 0 ]

do

count=$(count - 1)

run_status=$(ps -ef | grep -v 'grep' | egrep "bin/mysqld_safe --user=mysql")

if [ "${run_status}X" -eq "X" ];then

echo "check mysql service,please wait..."

else

break

fi

isSuccess=1

sleep 1

done

if [ "${isSuccess}" == 0 ];then

echo "Mysql start success...."

exit 0

else

echo "Mysql start fail...."

exit 1

fi

}

function shutdownMysql()

{

bin/mysqladmin -uroot -proot shutdown >/dev/null 2>&1

pids=$(ps -ef | grep -e "bin/mysqld_safe" | grep -v grep | awk '{print $2}')

for pid in $pids

do

kill -9 $pid

done

pids=$(ps -ef | grep -e "bin/mysqld" | grep -v grep | awk '{print $2}')

for pid in $pids

do

kill -9 $pid

done

pids=$(ps -ef | grep -e "\[mysqld\]" | grep -v grep | awk '{print $2}')

for pid in $pids

do

kill -9 $pid

done

}

###############################################

#check libaio lib

isExistLibaio=$(rpm -qa | grep libaio)

if [ "${isExistLibaio}X" == "X" ];then

echo "Libaio library is not install,we will install it,please wait."

rpm -ivh $CURRENT_DIR/$LIBAIO_PACKAGE

fi

if [ -e "$CURRENT_DIR/$MYSQL_VERSION/$LOCK_FILE" ];then

echo starting mysql,please waiting...

cd "$CURRENT_DIR/$MYSQL_VERSION"

#start mysql

shutdownMysql

sleep 5

/bin/bash "bin/mysqld_safe" --user=mysql &

isStartSuccess

fi

echo "Mysql first install to you PC.please wait..."

rm -fr $CURRENT_DIR/$MYSQL_VERSION

tar -zxf "$CURRENT_DIR/$MYSQL_PACKAGE"

echo starting mysql,please waiting...

cd "$CURRENT_DIR/$MYSQL_VERSION"

#modify perm

chmod -R 744 bin

chmod -R 744 scripts

#check mysql folder

if [ -e /usr/local/mysql ];then

echo "Other Mysql is installed.please uninstall it and remove /usr/local/mysql"

exit 1

else

rm -fr /usr/local/mysql >/dev/null 2>&1

ln -s "$CURRENT_DIR/$MYSQL_VERSION" /usr/local/mysql

fi

#check mysql user and group

groupid=`grep 'mysql' /etc/group|awk -F : '{print $3}'`

if [ ! -z $groupid ] ;then

echo "Mysql group is exist."

else

groupadd mysql

fi

userid=`grep 'mysql' /etc/passwd|awk -F : '{print $3}'`

if [ ! -z $userid ] ;then

echo "Mysql user is exist."

else

useradd -g mysql mysql

fi

#check my.cnf

if [ -e /etc/my.cnf ] ;then

cp /etc/my.cnf /etc/my.cnf.other

fi

cp "$CURRENT_DIR/$MYSQL_VERSION/support-files/my-large.cnf" /etc/my.cnf

#modify mysql perm

chown -R mysql:mysql "$CURRENT_DIR/$MYSQL_VERSION"

chmod -R 744 bin

#install mysql script

/bin/bash "scripts/mysql_install_db" --user=mysql

shutdownMysql

bin/mysqld_safe &

sleep 5

#modify root password

bin/mysqladmin -uroot password root

shutdownMysql

bin/mysqld_safe --user=mysql&

sleep 5

#import sql data

if [ -e "$CURRENT_DIR/platform_core.sql" ];then

echo "Import platform_core.sql,please wait..."

bin/mysql -uroot -proot -hlocalhost

fi

#start mysql

shutdownMysql

sleep 5

/bin/bash "bin/mysqld_safe" --user=mysql&

#lock mysql

touch $LOCK_FILE

isStartSuccess

实施的步骤

1.解压包

2.初始化数据库脚本

3.修改密码

4.导入sql语句

5.启动mysql