实例

#!/bin/bash

mysqlconn=" mysql -uroot -paishang132465 "
old_db="aishang"
new_db="aishang_big"
$mysqlconn -e "CREATE DATABASE $new_db"
params=$($mysqlconn -N -e "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='$old_db'")
for name in $params;
do
	$mysqlconn -e "RENAME TABLE $old_db.$name to $new_db.$name";
done;
# $mysqlconn -e "DROP DATABASE $old_db"

#!/bin/sh
sh /home/tomcat8080-/bin/shutdown.sh
sleep 3
pid=$(ps -ef | grep tomcat8080 | grep -v grep | grep -v $$ | awk '{print $2}')
echo $pid
if test -z $pid; then
  sh /home/tomcat8080-/bin/startup.sh
  echo success without kill
else
  kill -9 $pid
  sh /home/tomcat8080-/bin/startup.sh
  echo success with kill
fi

vim /srv/tomcat9/logs/catalina.out;
tail -f /srv/tomcat9/logs/catalina.out;

rm -rf /srv/tomcat9/logs/*;
sh /srv/tomcat9/bin/startup.sh;
sleep 1;
tail -f /srv/tomcat9/logs/catalina.out;

sh /srv/tomcat9/bin/shutdown.sh;
sleep 3;
ps -aux|grep /srv/tomcat9/bin | grep -v grep |awk '{print $2}' |xargs -I $ kill -9 $;

::echo off
echo "Yby@2503"
scp -vrp -P 21722 C:\JAVA\software\apache-tomcat-9.0.37\webapps\ybysys\webpage\ root@192.168.5.12:/home/tomcat8080-/webapps/ybysys/webpage/ 
scp -vrp -P 21722 C:\JAVA\software\apache-tomcat-9.0.37\webapps\ybysys\WEB-INF\classes\com\ root@192.168.5.12:/home/tomcat8080-/webapps/ybysys/WEB-INF/classes/com/
scp -vrp -P 21722 C:\JAVA\software\apache-tomcat-9.0.37\webapps\ybysys\WEB-INF\classes\content\ root@192.168.5.12:/home/tomcat8080-/webapps/ybysys/WEB-INF/classes/content/
scp -vrp -P 21722 C:\JAVA\software\apache-tomcat-9.0.37\webapps\ybysys\WEB-INF\classes\export\ root@192.168.5.12:/home/tomcat8080-/webapps/ybysys/WEB-INF/classes/export/
scp -vrp -P 21722 C:\JAVA\software\apache-tomcat-9.0.37\webapps\ybysys\WEB-INF\classes\jeecg\ root@192.168.5.12:/home/tomcat8080-/webapps/ybysys/WEB-INF/classes/jeecg/
scp -vrp -P 21722 C:\JAVA\software\apache-tomcat-9.0.37\webapps\ybysys\WEB-INF\classes\online\ root@192.168.5.12:/home/tomcat8080-/webapps/ybysys/WEB-INF/classes/online/
scp -vrp -P 21722 C:\JAVA\software\apache-tomcat-9.0.37\webapps\ybysys\WEB-INF\classes\org\ root@192.168.5.12:/home/tomcat8080-/webapps/ybysys/WEB-INF/classes/org/
pause