人物数据_帐号数据备份&恢复--换库后迁移用户用的

use `tbcmangos` ;

TRUNCATE TABLE `character` ;

INSERT INTO `tbcmangos`.`character` SELECT * FROM `mangos3447`.`character` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_action` ;

INSERT INTO `tbcmangos`.`character_action` SELECT * FROM `mangos3447`.`character_action` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_aura` ;

INSERT INTO `tbcmangos`.`character_aura` SELECT * FROM `mangos3447`.`character_aura` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_homebind` ;

INSERT INTO `tbcmangos`.`character_homebind` SELECT * FROM `mangos3447`.`character_homebind` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_inventory` ;

INSERT INTO `tbcmangos`.`character_inventory` SELECT * FROM `mangos3447`.`character_inventory` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_kill` ;

INSERT INTO `tbcmangos`.`character_kill` SELECT * FROM `mangos3447`.`character_kill` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_pet` ;

INSERT INTO `tbcmangos`.`character_pet` SELECT * FROM `mangos3447`.`character_pet` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_queststatus` ;

INSERT INTO `tbcmangos`.`character_queststatus` SELECT * FROM `mangos3447`.`character_queststatus` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_reputation` ;

INSERT INTO `tbcmangos`.`character_reputation` SELECT * FROM `mangos3447`.`character_reputation` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_social` ;

INSERT INTO `tbcmangos`.`character_social` SELECT * FROM `mangos3447`.`character_social` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_spell` ;

INSERT INTO `tbcmangos`.`character_spell` SELECT * FROM `mangos3447`.`character_spell` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_spell_cooldown` ;

INSERT INTO `tbcmangos`.`character_spell_cooldown` SELECT * FROM `mangos3447`.`character_spell_cooldown` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_stable` ;

INSERT INTO `tbcmangos`.`character_stable` SELECT * FROM `mangos3447`.`character_stable` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_ticket` ;

INSERT INTO `tbcmangos`.`character_ticket` SELECT * FROM `mangos3447`.`character_ticket` ;

use `tbcmangos` ;

TRUNCATE TABLE `character_tutorial` ;

INSERT INTO `tbcmangos`.`character_tutorial` SELECT * FROM `mangos3447`.`character_tutorial` ;

use `tbcmangos` ;

TRUNCATE TABLE `item_instance` ;

INSERT INTO `tbcmangos`.`item_instance` SELECT * FROM `mangos3447`.`item_instance` ;

use `tbcmangos` ;

TRUNCATE TABLE `mail` ;

INSERT INTO `tbcmangos`.`mail` SELECT * FROM `mangos3447`.`mail` ;

use `tbcmangos` ;

TRUNCATE TABLE `guild` ;

INSERT INTO `tbcmangos`.`guild` SELECT * FROM `mangos3447`.`guild` ;

use `tbcmangos` ;

TRUNCATE TABLE `guild_charter` ;

INSERT INTO `tbcmangos`.`guild_charter` SELECT * FROM `mangos3447`.`guild_charter` ;

use `tbcmangos` ;

TRUNCATE TABLE `guild_charter_sign` ;

INSERT INTO `tbcmangos`.`guild_charter_sign` SELECT * FROM `mangos3447`.`guild_charter_sign` ;

use `tbcmangos` ;

TRUNCATE TABLE `guild_member` ;

INSERT INTO `tbcmangos`.`guild_member` SELECT * FROM `mangos3447`.`guild_member` ;

use `tbcmangos` ;

TRUNCATE TABLE `guild_rank` ;

INSERT INTO `tbcmangos`.`guild_rank` SELECT * FROM `mangos3447`.`guild_rank` ;

w ww.5u wl.net

备注：

use `tbcmangos 中 use 后面是新库的名字

FROM `mangos3447`中 from 后面是旧库的名字

本站声明:本站文章资源均来自网上转载或机器人自动搜索采集,如果本站文章资源有版权问题请联系管理员，我们尽快予以更正。所有文章只限用于个人测试学习使用,不得用于非法商业用途,请勿非法复制传播。特此声明！--[5uwl.net]

五年游戏制作经验; 金牌服务品质保障 游戏开区一条龙 第一品牌无忧网络[5uwl.net]