人物数据用户迁移sql语句(人物数据_帐号数据备份&恢复－－换库后迁

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

 

 

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` ;

 

 

备注：

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

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

商业版发布站程序下载：发布站程序下载：

Tags：

作者：佚名