导出/导入表结构-KeepStudy

导出/导入表结构

```shell
#!/usr/bin/env bash

#导出表结构

HOSTNAME="127.0.0.1"
PORT="3306"
USERNAME="root"
PASSWORD="root"

#获取所有日志库和后台库
SQL="SELECT SCHEMA_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME NOT IN ('mysql','information_schema','performance_schema')"
declare ROWS=`mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} -e "${SQL}"`
for dbName in ${ROWS}
do
  if [ ${dbName} != 'SCHEMA_NAME' ]
  then
    echo ${dbName}
     #备份数据结构
     mysqldump -dRE --skip-comments --compact --no-tablespaces --force -u${USERNAME} -p${PASSWORD} ${dbName} > /home/www/mysql_data_stru/${dbName}.sql
  fi
done
```

```shell
#!bin/bash

#导入数据库结构

HOSTNAME="127.0.0.1"
PORT="3306"
USERNAME="root"
PASSWORD="root"
PATH="/home/www/mysql_data_stru"

for db in game_backstage game_backstage_common game_log
do
    echo $db
    if [ ${db} == 'game_backstage_common' ]
    then
       #@连接数据库
       connDB="/usr/bin/mysql -h${HOSTNAME}  -P${PORT}  -u${USERNAME} -p${PASSWORD} ${db}"

#@导入表结构
       SQL="source ${PATH}/${db}.sql"
       ${connDB} -e "${SQL}"
       break
    fi
done
exit 0
```
```sql
-- 表结构文件
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `c_ac_delgiftbag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `server_id` text COMMENT '服务器列表',
  `create_er` char(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='删除活动奖励配置';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `c_ac_gift1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gid` varchar(50) DEFAULT NULL,
  `name` varchar(30) DEFAULT NULL,
  `reward` mediumtext,
  `create_er` varchar(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='活动礼包配置';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `c_ac_reward1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ac_id` varchar(50) DEFAULT NULL,
  `def_name` varchar(50) DEFAULT NULL,
  `channel` varchar(7) DEFAULT NULL,
  `reward` mediumtext,
  `create_er` varchar(20) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='活动奖励配置';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `c_activity1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `actype` tinyint(4) DEFAULT '0' COMMENT '显示位置 0经常 1开服',
  `name` varchar(100) DEFAULT NULL,
  `content` text COMMENT '模板id',
  `server_id` text COMMENT '服务器列表',
  `create_er` char(20) DEFAULT NULL COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `check_er` char(20) DEFAULT NULL COMMENT '审核者',
  `check_time` datetime DEFAULT NULL COMMENT '审核时间',
  `remark` varchar(60) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='活动';
```

顶部

Shell应用

目录

相关推荐