Shulou(Shulou.com)06/01 Report--

If you want to replace any variable, copy and paste directly, and the program will run and go.

#! / bin/bash

# copy the data of hellodb into the hellodb_ Bak library.

Mysql-uroot-pAbcd@1234-h 10.0.20.26-P33062 > / dev/null-e "flush tables with read lock;"

Mysql-uroot-pAbcd@1234-h 10.0.20.26-P33062 > / dev/null-e "create database hellodb_bak;"

Tbname=$ (mysql-uroot-pAbcd@1234-h 10.0.20.26-P33062 > / dev/null-e "SELECT table_name from information_schema.tables where TABLE_SCHEMA='hellodb'")

For i in $tbname; do

Mysql-uroot-pAbcd@1234-h 10.0.20.26-P3306 hellodb_bak 2 > / dev/null-e "create table $I like hellodb.$i"

Mysql-uroot-pAbcd@1234-h 10.0.20.26-P3306 hellodb_bak 2 > / dev/null-e "insert into $I select * from hellodb.$i"

Done

Mysql-uroot-pAbcd@1234-h 10.0.20.26-P33062 > / dev/null-e "unlock tables;"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.