API tools faq
paste
Guest User

Untitled

a guest
May 26th, 2018
130
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 9.13 KB | None | 0 0
raw download clone embed print report
  1. ##### CONFIG ######
  2. set @user := root;
  3. set @password := root;
  4. set @world_db := world;
  5.  
  6. ##### FULL DB #####
  7. cd ~/OregonCore/DB/
  8. mysql -u @user -p@password--default-character-set=utf8 world_db < ODB0.0.6_1207.sql
  9. #cd /server_x1/sources/sql/updates/
  10. #mysql -u root -proot --default-character-set=utf8 world_db <
  11.  
  12. #### UPDATE OREGONCORE ########
  13. cd ~/OregonCore/sql/updates
  14. #mysql -u @user -p@password--default-character-set=utf8 world_db < 145_world_scripts.sql
  15. #mysql -u @user -p@password--default-character-set=utf8 world_db < 161_world_quest_template.sql
  16. #mysql -u @user -p@password--default-character-set=utf8 world_db < 186_world_oregon_string.sql
  17. #mysql -u @user -p@password--default-character-set=utf8 world_db < 203_world_script_texts.sql
  18. #mysql -u @user -p@password--default-character-set=utf8 world_db < 263_world_oregon_string.sql
  19. #mysql -u @user -p@password--default-character-set=utf8 world_db < 267_world_oregon_string.sql
  20. #mysql -u @user -p@password--default-character-set=utf8 world_db < 320_world_command.sql
  21. #mysql -u @user -p@password--default-character-set=utf8 world_db < 322_world_command.sql
  22. #mysql -u @user -p@password--default-character-set=utf8 world_db < 353_world.sql
  23. #mysql -u @user -p@password--default-character-set=utf8 world_db < 485_world_playercreateinfo.sql
  24. #mysql -u @user -p@password--default-character-set=utf8 world_db < 494_world_gossip.sql
  25. #mysql -u @user -p@password--default-character-set=utf8 world_db < 494_world_script.sql
  26. #mysql -u @user -p@password--default-character-set=utf8 world_db < 498_world_script.sql
  27. #mysql -u @user -p@password--default-character-set=utf8 world_db < 502_world_mail_loot_template.sql
  28. #mysql -u @user -p@password--default-character-set=utf8 world_db < 526_world_command.sql
  29. #mysql -u @user -p@password--default-character-set=utf8 world_db < 543_world_spell_proc_event.sql
  30. #mysql -u @user -p@password--default-character-set=utf8 world_db < 593_world_eventai.sql
  31. #mysql -u @user -p@password--default-character-set=utf8 world_db < 599_world_gameobject_template.sql
  32. #mysql -u @user -p@password--default-character-set=utf8 world_db < 671_world_spell_proc_event.sql
  33. #mysql -u @user -p@password--default-character-set=utf8 world_db < 686_world_oregon_string.sql
  34. #mysql -u @user -p@password--default-character-set=utf8 world_db < 699_world_oregon_string.sql
  35. #mysql -u @user -p@password--default-character-set=utf8 world_db < 702_world_structure.sql
  36. #mysql -u @user -p@password--default-character-set=utf8 world_db < 788_world_script_texts.sql
  37. #mysql -u @user -p@password--default-character-set=utf8 world_db < 793_world_script_texts.sql
  38. #mysql -u @user -p@password--default-character-set=utf8 world_db < 794_world_script_texts.sql
  39. #mysql -u @user -p@password--default-character-set=utf8 world_db < 806_world_script_texts.sql
  40. #mysql -u @user -p@password--default-character-set=utf8 world_db < 819_world_creature.sql
  41. #mysql -u @user -p@password--default-character-set=utf8 world_db < 822_world_script_texts.sql
  42. #mysql -u @user -p@password--default-character-set=utf8 world_db < 823_world_script_texts.sql
  43. #mysql -u @user -p@password--default-character-set=utf8 world_db < 827_world_script_texts.sql
  44. #mysql -u @user -p@password--default-character-set=utf8 world_db < 828_world_script_texts.sql
  45. #mysql -u @user -p@password--default-character-set=utf8 world_db < 829_world_script_texts.sql
  46. #mysql -u @user -p@password--default-character-set=utf8 world_db < 830_world_script_texts.sql
  47. #mysql -u @user -p@password--default-character-set=utf8 world_db < 831_world_script_texts.sql
  48. #mysql -u @user -p@password--default-character-set=utf8 world_db < 832_world_creature_template.sql
  49. #mysql -u @user -p@password--default-character-set=utf8 world_db < 835_world_creature_ai_scripts.sql
  50. #mysql -u @user -p@password--default-character-set=utf8 world_db < 836_world_creature_template.sql
  51. #mysql -u @user -p@password--default-character-set=utf8 world_db < 837_world_creature_template.sql
  52. #mysql -u @user -p@password--default-character-set=utf8 world_db < 841_world_script_texts.sql
  53. #mysql -u @user -p@password--default-character-set=utf8 world_db < 852_world_script_texts.sql
  54. #mysql -u @user -p@password--default-character-set=utf8 world_db < 868_world_creature_template.sql
  55. #mysql -u @user -p@password--default-character-set=utf8 world_db < 893_world_oregon_string.sql
  56. #mysql -u @user -p@password--default-character-set=utf8 world_db < 906_world_creature_ai_scripts.sql
  57. #mysql -u @user -p@password--default-character-set=utf8 world_db < 938_world_pools.sql
  58. #mysql -u @user -p@password--default-character-set=utf8 world_db < 963_world_npc_text.sql
  59. #mysql -u @user -p@password--default-character-set=utf8 world_db < 969_world_oregon_string.sql
  60. #mysql -u @user -p@password--default-character-set=utf8 world_db < 970_world_spell_script_target.sql
  61. #mysql -u @user -p@password--default-character-set=utf8 world_db < 977_world_creature_template.sql
  62. #mysql -u @user -p@password--default-character-set=utf8 world_db < 983_world_spell_script_target.sql
  63. #mysql -u @user -p@password--default-character-set=utf8 world_db < 984_world_creature_template.sql
  64. #mysql -u @user -p@password--default-character-set=utf8 world_db < 993_world_creature_template.sql
  65. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1003_world_creature_template.sql
  66. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1037_world_oregon_string.sql
  67. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1041_world_command.sql
  68. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1056_world_oregon_string.sql
  69. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1067_world_script_texts.sql
  70. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1076_world_oregon_string.sql
  71. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1086_world_oregon_string.sql
  72. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1094_world_spell_proc_event.sql
  73. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1097_01_world_oregon_string.sql
  74. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1097_02_world_command.sql
  75. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1117_world_spell_affect.sql
  76. #mysql -u @user -p@password--default-character-set=utf8 world_db < 1137_world_creature_template.sql
  77. mysql -u @user -p@password--default-character-set=utf8 world_db < 1208_02_world_command.sql
  78. mysql -u @user -p@password--default-character-set=utf8 world_db < 1208_03_world_oregon_string.sql
  79. mysql -u @user -p@password--default-character-set=utf8 world_db < 1216_world_spell_linked_spell.sql
  80. mysql -u @user -p@password--default-character-set=utf8 world_db < 1217_world_spell_linked_spell.sql
  81. mysql -u @user -p@password--default-character-set=utf8 world_db < 1282_world_creature_template.sql
  82. mysql -u @user -p@password--default-character-set=utf8 world_db < 1286_world_creature_template.sql
  83. mysql -u @user -p@password--default-character-set=utf8 world_db < 1298_01_world_oregon_string.sql
  84. mysql -u @user -p@password--default-character-set=utf8 world_db < 1335_world_oregon_string.sql
  85. mysql -u @user -p@password--default-character-set=utf8 world_db < 1385_world_autobroadcast.sql
  86. mysql -u @user -p@password--default-character-set=utf8 world_db < 1391_world_ActiveMover.sql
  87. mysql -u @user -p@password--default-character-set=utf8 world_db < 1446_world_creature_template.sql
  88. mysql -u @user -p@password--default-character-set=utf8 world_db < 1486_world_gameobject_template.sql
  89. mysql -u @user -p@password--default-character-set=utf8 world_db < 1515_world_creature_template.sql
  90. mysql -u @user -p@password--default-character-set=utf8 world_db < 1522_world_creature_template.sql
  91. mysql -u @user -p@password--default-character-set=utf8 world_db < 1523_world_creature_template.sql
  92. mysql -u @user -p@password--default-character-set=utf8 world_db < 1526_world_creature_template.sql
  93. mysql -u @user -p@password--default-character-set=utf8 world_db < 1529_event_scripts.sql
  94. mysql -u @user -p@password--default-character-set=utf8 world_db < 1533_world_creature_template.sql
  95. mysql -u @user -p@password--default-character-set=utf8 world_db < 1538_world_creature_template.sql
  96. mysql -u @user -p@password--default-character-set=utf8 world_db < 1542_world_creature_template.sql
  97. mysql -u @user -p@password--default-character-set=utf8 world_db < 1544_world_creature_template.sql
  98. mysql -u @user -p@password--default-character-set=utf8 world_db < 1545_01_world_creature_formations.sql
  99. mysql -u @user -p@password--default-character-set=utf8 world_db < 1545_02_world_creature_groups.sql
  100. mysql -u @user -p@password--default-character-set=utf8 world_db < 1545_03_world_creature_group_data.sql
  101. mysql -u @user -p@password--default-character-set=utf8 world_db < 1545_04_world_command.sql
  102. mysql -u @user -p@password--default-character-set=utf8 world_db < 1553_world_creature_template.sql
  103. mysql -u @user -p@password--default-character-set=utf8 world_db < 1569_world_spell_affect.sql
  104.  
  105. ###### CUSTOM UPDATES #######
  106. cd ~/OregonCore/sql_updates/
  107. mysql -u @user -p@password--default-character-set=utf8 world_db < wb_001_mangos_closed_arena.sql
  108. mysql -u @user -p@password--default-character-set=utf8 world_db < wb_002_mangos_scriptname.sql
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!