魔兽世界AZ端MySQL数据库查询清理开服命令

admin

acore_auth表

1. -- 完整的 acore_auth 清理脚本
   
2. USE acore_auth;
   
3. 
   
4. -- 关闭外键约束
   
5. SET FOREIGN_KEY_CHECKS = 0;
   
6. 
   
7. -- 清除所有账号相关数据
   
8. DELETE FROM account_banned;
   
9. DELETE FROM account_muted;
   
10. DELETE FROM account_access;
    
11. DELETE FROM secret_digest;
    
12. DELETE FROM realmcharacters;
    
13. DELETE FROM account;
    
14. 
    
15. -- 重置自增ID
    
16. ALTER TABLE account AUTO_INCREMENT = 1;
    
17. ALTER TABLE account_access AUTO_INCREMENT = 1;
    
18. ALTER TABLE account_banned AUTO_INCREMENT = 1;
    
19. ALTER TABLE account_muted AUTO_INCREMENT = 1;
    
20. 
    
21. -- 恢复外键约束
    
22. SET FOREIGN_KEY_CHECKS = 1;
    
23. 
    
24. -- 验证清理结果
    
25. SELECT COUNT(*) FROM account;
    
26. SELECT COUNT(*) FROM account_access;

复制代码

acore_characters表

1. -- 完整的 acore_characters 清理脚本
   
2. USE acore_characters;
   
3. 
   
4. -- 关闭外键约束
   
5. SET FOREIGN_KEY_CHECKS = 0;
   
6. 
   
7. -- 1. 清除社交和团队相关数据
   
8. DELETE FROM guild_bank_item;
   
9. DELETE FROM guild_bank_log;
   
10. DELETE FROM guild_bank_tab;
    
11. DELETE FROM guild_eventlog;
    
12. DELETE FROM guild_member;
    
13. DELETE FROM guild_rank;
    
14. DELETE FROM guild;
    
15. 
    
16. DELETE FROM arena_team_member;
    
17. DELETE FROM arena_team_stats;
    
18. DELETE FROM arena_team;
    
19. 
    
20. -- 2. 清除交易和邮件数据
    
21. DELETE FROM mail_items;
    
22. DELETE FROM mail;
    
23. DELETE FROM auctionhouse;
    
24. DELETE FROM item_instance;
    
25. 
    
26. -- 3. 清除角色扩展数据
    
27. DELETE FROM character_achievement_offline_updates;
    
28. DELETE FROM character_achievement;
    
29. DELETE FROM character_account_data;
    
30. DELETE FROM character_armory_stats;
    
31. DELETE FROM character_battleground_data;
    
32. DELETE FROM character_battleground_stats;
    
33. DELETE FROM character_homebind;
    
34. DELETE FROM character_instance;
    
35. DELETE FROM character_inventory;
    
36. DELETE FROM character_pet;
    
37. DELETE FROM character_queststatus_rewarded;
    
38. DELETE FROM character_queststatus;
    
39. DELETE FROM character_reputation;
    
40. DELETE FROM character_skills;
    
41. DELETE FROM character_social;
    
42. DELETE FROM character_spell_cooldown;
    
43. DELETE FROM character_spell;
    
44. DELETE FROM character_stats;
    
45. DELETE FROM character_talent;
    
46. DELETE FROM character_titles;
    
47. DELETE FROM character_voidstorage;
    
48. DELETE FROM character_archaeology_project;
    
49. DELETE FROM character_archaeology_artifact;
    
50. 
    
51. -- 4. 清除核心角色数据
    
52. DELETE FROM characters;
    
53. 
    
54. -- 5. 清除账号相关角色数据
    
55. DELETE FROM account_instance_times;
    
56. DELETE FROM account_data;
    
57. DELETE FROM account_tutorial;
    
58. 
    
59. -- 6. 清除其他辅助数据
    
60. DELETE FROM addons;
    
61. DELETE FROM bugreport;
    
62. DELETE FROM battleground_deserters;
    
63. DELETE FROM calendar_invites;
    
64. DELETE FROM calendar_events;
    
65. DELETE FROM channels_rights;
    
66. DELETE FROM channels_bans;
    
67. DELETE FROM channels;
    
68. 
    
69. -- 7. 重置自增ID
    
70. ALTER TABLE characters AUTO_INCREMENT = 1;
    
71. ALTER TABLE guild AUTO_INCREMENT = 1;
    
72. ALTER TABLE arena_team AUTO_INCREMENT = 1;
    
73. ALTER TABLE mail AUTO_INCREMENT = 1;
    
74. ALTER TABLE auctionhouse AUTO_INCREMENT = 1;
    
75. ALTER TABLE item_instance AUTO_INCREMENT = 1;
    
76. 
    
77. -- 恢复外键约束
    
78. SET FOREIGN_KEY_CHECKS = 1;
    
79. 
    
80. -- 验证清理结果
    
81. SELECT COUNT(*) FROM characters;
    
82. SELECT COUNT(*) FROM guild;
    
83. SELECT COUNT(*) FROM arena_team;

复制代码

注意事项
1. 备份数据 ：在执行清除命令前，务必先备份整个数据库
2. 外键约束 ：清除数据时必须先关闭外键约束，否则会因关联关系导致清除失败
3. 清除顺序 ：建议按照从依赖表到被依赖表的顺序清除，避免数据残留
4. 重置自增ID ：清除数据后，建议重置自增ID，让新角色从ID=1开始
5. 谨慎操作 ：清除命令不可逆，务必确认后再执行
6. 测试环境 ：建议先在测试环境中测试清除脚本，确认无误后再在生产环境执行
7. 账号关联 ：清除角色数据后，建议同时清理对应的认证数据库中的账号数据，保持数据一致性
部分表说明
characters 核心角色表，存储角色的基本信息
character_inventory 角色背包和装备
character_queststatus 角色任务状态
character_skills 角色技能
character_spell 角色法术
guild 公会信息
arena_team 竞技场队伍
mail 邮件系统
auctionhouse 拍卖行