Shell 操作练习

时间：2021-10-29 11:34:08
#! /bin/sh

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

#          --         #

#        author jackluo       #

#      net.webjoy@gmail.com   #

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

serverid=$ #服务器的id

db_name=$  #数据库名

db_host=$ #mysql 的主机地址

databases_file_path=/home/wwwroot/cy/application/config/database.php

db_user=root #数据库帐号

db_password=admin #数据库密码

db_host=localhost #数据库ip

db_template_path=/home/jackluo/platform.sql #要导入的模板数据库

if [ -z "${serverid}" ] || [ -z "${db_name}" ] || [ -z "${db_host}" ];then

    echo "参数不够 共3个参数第一个是服务器的id 第二个是数据名, 第三个是mysql的主机地址"

    exit

fi

echo "/***************appgame ${serverid}************/

$db['${serverid}']['gamedb']['hostname'] = 'localhost';

$db['${serverid}']['gamedb']['username'] = 'jack';

$db['${serverid}']['gamedb']['password'] = '****';

$db['${serverid}']['gamedb']['database'] = '${db_name}';

$db['${serverid}']['gamedb']['dbdriver'] = 'mysql';

$db['${serverid}']['gamedb']['dbprefix'] = '';

$db['${serverid}']['gamedb']['pconnect'] = FALSE;

$db['${serverid}']['gamedb']['db_debug'] = TRUE;

$db['${serverid}']['gamedb']['cache_on'] = FALSE;

$db['${serverid}']['gamedb']['cachedir'] = '';

$db['${serverid}']['gamedb']['char_set'] = 'utf8';

$db['${serverid}']['gamedb']['dbcollat'] = 'utf8_general_ci';

$db['${serverid}']['gamedb']['swap_pre'] = '';

$db['${serverid}']['gamedb']['autoinit'] = TRUE;

$db['${serverid}']['gamedb']['stricton'] = FALSE;

$db['${serverid}']['remotedb']['hostname'] = '${db_host}';

$db['${serverid}']['remotedb']['username'] = 'luo';

$db['${serverid}']['remotedb']['password'] = '***';

$db['${serverid}']['remotedb']['database'] = '${db_name}';

$db['${serverid}']['remotedb']['dbdriver'] = 'mysql';

$db['${serverid}']['remotedb']['dbprefix'] = '';

$db['${serverid}']['remotedb']['pconnect'] = FALSE;

$db['${serverid}']['remotedb']['db_debug'] = TRUE;

$db['${serverid}']['remotedb']['cache_on'] = FALSE;

$db['${serverid}']['remotedb']['cachedir'] = '';

$db['${serverid}']['remotedb']['char_set'] = 'utf8';

$db['${serverid}']['remotedb']['dbcollat'] = 'utf8_general_ci';

$db['${serverid}']['remotedb']['swap_pre'] = '';

$db['${serverid}']['remotedb']['autoinit'] = TRUE;

$db['${serverid}']['remotedb']['stricton'] = FALSE;

/***************appgame ${serverid}********************/

" >> ${databases_file_path} #写入数据库

sed -i 's/\r//' ${databases_file_path} #替换^M 这样的东西

#创建数据库

mysql -u${db_user} -p${db_password} -h${db_host} <<EOF

    set names utf8;

    create database ${db_name};

    use ${db_name};

    source ${db_template_path};

EOF

相关文章