导出/导入表空间-KeepStudy

导出/导入表空间

```shell
#!bin/bash

#导出表空间

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

for db in game_backstage game_backstage_common game_log game_log_12
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
导出表空间db.sql文件
ALTER TABLE `c_ac_delgiftbag` DISCARD TABLESPACE;
ALTER TABLE `c_ac_gift1` DISCARD TABLESPACE;
ALTER TABLE `c_ac_reward1` DISCARD TABLESPACE;
ALTER TABLE `c_activity1` DISCARD TABLESPACE;
ALTER TABLE `c_advice` DISCARD TABLESPACE;
ALTER TABLE `c_ban` DISCARD TABLESPACE;
ALTER TABLE `c_ban_ip_dev` DISCARD TABLESPACE;
ALTER TABLE `c_charge_dc_set` DISCARD TABLESPACE;
ALTER TABLE `c_chat_level_limit` DISCARD TABLESPACE;
ALTER TABLE `c_chat_times_limit` DISCARD TABLESPACE;
ALTER TABLE `c_chat_word_limit` DISCARD TABLESPACE;
ALTER TABLE `c_email` DISCARD TABLESPACE;
ALTER TABLE `c_email_temp` DISCARD TABLESPACE;
ALTER TABLE `c_game_link` DISCARD TABLESPACE;
ALTER TABLE `c_guild_notice` DISCARD TABLESPACE;
ALTER TABLE `c_inside` DISCARD TABLESPACE;
ALTER TABLE `c_inside_deal_item_set` DISCARD TABLESPACE;
ALTER TABLE `c_inside_deal_role_set` DISCARD TABLESPACE;
```

```sql
导入表空间db.sql文件
ALTER TABLE `c_ac_delgiftbag` IMPORT TABLESPACE;
ALTER TABLE `c_ac_gift1` IMPORT TABLESPACE;
ALTER TABLE `c_ac_reward1` IMPORT TABLESPACE;
ALTER TABLE `c_activity1` IMPORT TABLESPACE;
ALTER TABLE `c_advice` IMPORT TABLESPACE;
ALTER TABLE `c_ban` IMPORT TABLESPACE;
ALTER TABLE `c_ban_ip_dev` IMPORT TABLESPACE;
ALTER TABLE `c_charge_dc_set` IMPORT TABLESPACE;
ALTER TABLE `c_chat_level_limit` IMPORT TABLESPACE;
ALTER TABLE `c_chat_times_limit` IMPORT TABLESPACE;
ALTER TABLE `c_chat_word_limit` IMPORT TABLESPACE;
ALTER TABLE `c_email` IMPORT TABLESPACE;
```

顶部

Shell应用

目录

相关推荐