API tools faq
paste
Advertisement
METAJIJI

Untitled

METAJIJI
Apr 8th, 2017
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.09 KB | None | 0 0
raw download clone embed print report
  1. # sh migrate.sh
  2. migrator.sh - INFO : running /srv/sql/migrate/migrator.sh.d/0000_init_migrate_database.sql
  3.  
  4. migrator.sh - INFO : running /srv/sql/migrate/migrator.sh.d/0010_just_copy_from_new.sh
  5. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.account_bonus' to 'l2migrate.account_bonus'
  6. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.account_log' to 'l2migrate.account_log'
  7. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bbs_clanbonus' to 'l2migrate.bbs_clanbonus'
  8. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bbs_clannotice' to 'l2migrate.bbs_clannotice'
  9. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bbs_commission' to 'l2migrate.bbs_commission'
  10. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bbs_favorites' to 'l2migrate.bbs_favorites'
  11. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bbs_mail' to 'l2migrate.bbs_mail'
  12. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bbs_news' to 'l2migrate.bbs_news'
  13. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bbs_pointsave' to 'l2migrate.bbs_pointsave'
  14. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bbs_skillsave' to 'l2migrate.bbs_skillsave'
  15. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bot_report' to 'l2migrate.bot_report'
  16. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.bot_reported_punish' to 'l2migrate.bot_reported_punish'
  17. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.castle_damage_zones' to 'l2migrate.castle_damage_zones'
  18. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.castle_door_upgrade' to 'l2migrate.castle_door_upgrade'
  19. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.castle_hired_guards' to 'l2migrate.castle_hired_guards'
  20. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.cataclysm' to 'l2migrate.cataclysm'
  21. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.character_bookmarks' to 'l2migrate.character_bookmarks'
  22. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.character_craft_fails' to 'l2migrate.character_craft_fails'
  23. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.character_group_reuse' to 'l2migrate.character_group_reuse'
  24. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.character_minigame_score' to 'l2migrate.character_minigame_score'
  25. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.character_post_friends' to 'l2migrate.character_post_friends'
  26. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.character_premium_items' to 'l2migrate.character_premium_items'
  27. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.character_sms_donate' to 'l2migrate.character_sms_donate'
  28. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.character_votes' to 'l2migrate.character_votes'
  29. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.clan_description' to 'l2migrate.clan_description'
  30. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.clan_subpledges_skills' to 'l2migrate.clan_subpledges_skills'
  31. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.clanlist_service' to 'l2migrate.clanlist_service'
  32. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.communitybuff_grp' to 'l2migrate.communitybuff_grp'
  33. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.communitybuff_grp_allowed_buffs' to 'l2migrate.communitybuff_grp_allowed_buffs'
  34. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.communitybuff_grp_buffs' to 'l2migrate.communitybuff_grp_buffs'
  35. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.custom_acp' to 'l2migrate.custom_acp'
  36. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.dominion' to 'l2migrate.dominion'
  37. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.dominion_rewards' to 'l2migrate.dominion_rewards'
  38. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.event_data' to 'l2migrate.event_data'
  39. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.event_tvt_arena' to 'l2migrate.event_tvt_arena'
  40. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.fishing_championship' to 'l2migrate.fishing_championship'
  41. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.fortress' to 'l2migrate.fortress'
  42. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.games' to 'l2migrate.games'
  43. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.global_tasks' to 'l2migrate.global_tasks'
  44. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.heroes_diary' to 'l2migrate.heroes_diary'
  45. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.hwid_info' to 'l2migrate.hwid_info'
  46. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.offline_buffers' to 'l2migrate.offline_buffers'
  47. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.offline_buffs' to 'l2migrate.offline_buffs'
  48. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.olympiad_history' to 'l2migrate.olympiad_history'
  49. 0010_just_copy_from_new.sh - INFO : Copy table 'l2new.siege_players' to 'l2migrate.siege_players'
  50.  
  51. migrator.sh - INFO : running /srv/sql/migrate/migrator.sh.d/0020_just_copy_from_old.sh
  52. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.bbs_memo' to 'l2migrate.bbs_memo'
  53. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.castle_manor_procure' to 'l2migrate.castle_manor_procure'
  54. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.castle_manor_production' to 'l2migrate.castle_manor_production'
  55. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.character_blocklist' to 'l2migrate.character_blocklist'
  56. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.character_friends' to 'l2migrate.character_friends'
  57. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.character_instances' to 'l2migrate.character_instances'
  58. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.char_templates' to 'l2migrate.char_templates'
  59. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.clan_privs' to 'l2migrate.clan_privs'
  60. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.clan_subpledges' to 'l2migrate.clan_subpledges'
  61. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.clan_wars' to 'l2migrate.clan_wars'
  62. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.four_sepulchers_spawnlist' to 'l2migrate.four_sepulchers_spawnlist'
  63. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.hwids_log' to 'l2migrate.hwids_log'
  64. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.item_auction_bid' to 'l2migrate.item_auction_bid'
  65. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.item_auction' to 'l2migrate.item_auction'
  66. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.petitions' to 'l2migrate.petitions'
  67. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.pets_skills' to 'l2migrate.pets_skills'
  68. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.raidboss_points' to 'l2migrate.raidboss_points'
  69. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.raidboss_status' to 'l2migrate.raidboss_status'
  70. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.random_spawn_loc' to 'l2migrate.random_spawn_loc'
  71. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.random_spawn' to 'l2migrate.random_spawn'
  72. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.residence_functions' to 'l2migrate.residence_functions'
  73. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.seven_signs_festival' to 'l2migrate.seven_signs_festival'
  74. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.seven_signs' to 'l2migrate.seven_signs'
  75. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.seven_signs_status' to 'l2migrate.seven_signs_status'
  76. 0020_just_copy_from_old.sh - INFO : Copy table 'l2enigma.siege_guards' to 'l2migrate.siege_guards'
  77.  
  78. migrator.sh - INFO : running /srv/sql/migrate/migrator.sh.d/1000_migrate.sh
  79. 1000_migrate.sh - INFO : Initialize table 'l2enigma.accounts' to 'l2migrate.accounts'
  80. 1000_migrate.sh - WARNING: Not implemented migration for table 'accounts'
  81. 1000_migrate.sh - INFO : Initialize table 'l2enigma.ally_data' to 'l2migrate.ally_data'
  82. 1000_migrate.sh - WARNING: Not implemented migration for table 'ally_data'
  83. 1000_migrate.sh - INFO : Initialize table 'l2enigma.bans' to 'l2migrate.bans'
  84. 1000_migrate.sh - WARNING: Not implemented migration for table 'bans'
  85. 1000_migrate.sh - INFO : Initialize table 'l2enigma.castle' to 'l2migrate.castle'
  86. 1000_migrate.sh - WARNING: Not implemented migration for table 'castle'
  87. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_effects_save' to 'l2migrate.character_effects_save'
  88. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_effects_save'
  89. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_hennas' to 'l2migrate.character_hennas'
  90. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_hennas'
  91. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_macroses' to 'l2migrate.character_macroses'
  92. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_macroses'
  93. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_mail' to 'l2migrate.character_mail'
  94. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_mail'
  95. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_quests' to 'l2migrate.character_quests'
  96. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_quests'
  97. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_recipebook' to 'l2migrate.character_recipebook'
  98. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_recipebook'
  99. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_shortcuts' to 'l2migrate.character_shortcuts'
  100. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_shortcuts'
  101. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_skills_save' to 'l2migrate.character_skills_save'
  102. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_skills_save'
  103. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_skills' to 'l2migrate.character_skills'
  104. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_skills'
  105. 1000_migrate.sh - INFO : Initialize table 'l2enigma.characters' to 'l2migrate.characters'
  106. 1000_migrate.sh - WARNING: Not implemented migration for table 'characters'
  107. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_subclasses' to 'l2migrate.character_subclasses'
  108. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_subclasses'
  109. 1000_migrate.sh - INFO : Initialize table 'l2enigma.character_variables' to 'l2migrate.character_variables'
  110. 1000_migrate.sh - WARNING: Not implemented migration for table 'character_variables'
  111. 1000_migrate.sh - INFO : Initialize table 'l2enigma.clan_data' to 'l2migrate.clan_data'
  112. 1000_migrate.sh - WARNING: Not implemented migration for table 'clan_data'
  113. 1000_migrate.sh - INFO : Initialize table 'l2enigma.clanhall' to 'l2migrate.clanhall'
  114. 1000_migrate.sh - WARNING: Not implemented migration for table 'clanhall'
  115. 1000_migrate.sh - INFO : Initialize table 'l2enigma.clan_skills' to 'l2migrate.clan_skills'
  116. 1000_migrate.sh - WARNING: Not implemented migration for table 'clan_skills'
  117. 1000_migrate.sh - INFO : Initialize table 'l2enigma.couples' to 'l2migrate.couples'
  118. 1000_migrate.sh - WARNING: Not implemented migration for table 'couples'
  119. 1000_migrate.sh - INFO : Initialize table 'l2enigma.cursed_weapons' to 'l2migrate.cursed_weapons'
  120. 1000_migrate.sh - WARNING: Not implemented migration for table 'cursed_weapons'
  121. 1000_migrate.sh - INFO : Initialize table 'l2enigma.epic_boss_spawn' to 'l2migrate.epic_boss_spawn'
  122. 1000_migrate.sh - WARNING: Not implemented migration for table 'epic_boss_spawn'
  123. 1000_migrate.sh - INFO : Initialize table 'l2enigma.game_log' to 'l2migrate.game_log'
  124. 1000_migrate.sh - WARNING: Not implemented migration for table 'game_log'
  125. 1000_migrate.sh - INFO : Initialize table 'l2enigma.gameservers' to 'l2migrate.gameservers'
  126. 1000_migrate.sh - WARNING: Not implemented migration for table 'gameservers'
  127. 1000_migrate.sh - INFO : Initialize table 'l2enigma.heroes' to 'l2migrate.heroes'
  128. 1000_migrate.sh - WARNING: Not implemented migration for table 'heroes'
  129. 1000_migrate.sh - INFO : Initialize table 'l2enigma.hwid_bans' to 'l2migrate.hwid_bans'
  130. 1000_migrate.sh - WARNING: Not implemented migration for table 'hwid_bans'
  131. 1000_migrate.sh - INFO : Initialize table 'l2enigma.items_delayed' to 'l2migrate.items_delayed'
  132. 1000_migrate.sh - WARNING: Not implemented migration for table 'items_delayed'
  133. 1000_migrate.sh - INFO : Initialize table 'l2enigma.items' to 'l2migrate.items'
  134. 1000_migrate.sh - WARNING: Not implemented migration for table 'items'
  135. 1000_migrate.sh - INFO : Initialize table 'l2enigma.lastimperialtomb_spawnlist' to 'l2migrate.lastimperialtomb_spawnlist'
  136. 1000_migrate.sh - WARNING: Not implemented migration for table 'lastimperialtomb_spawnlist'
  137. 1000_migrate.sh - INFO : Initialize table 'l2enigma.mail_attachments' to 'l2migrate.mail_attachments'
  138. 1000_migrate.sh - WARNING: Not implemented migration for table 'mail_attachments'
  139. 1000_migrate.sh - INFO : Initialize table 'l2enigma.mail' to 'l2migrate.mail'
  140. 1000_migrate.sh - WARNING: Not implemented migration for table 'mail'
  141. 1000_migrate.sh - INFO : Initialize table 'l2enigma.olympiad_nobles' to 'l2migrate.olympiad_nobles'
  142. 1000_migrate.sh - WARNING: Not implemented migration for table 'olympiad_nobles'
  143. 1000_migrate.sh - INFO : Initialize table 'l2enigma.pets' to 'l2migrate.pets'
  144. 1000_migrate.sh - WARNING: Not implemented migration for table 'pets'
  145. 1000_migrate.sh - INFO : Initialize table 'l2enigma.server_variables' to 'l2migrate.server_variables'
  146. 1000_migrate.sh - WARNING: Not implemented migration for table 'server_variables'
  147. 1000_migrate.sh - INFO : Initialize table 'l2enigma.siege_clans' to 'l2migrate.siege_clans'
  148. 1000_migrate.sh - WARNING: Not implemented migration for table 'siege_clans'
  149. 1000_migrate.sh - INFO : Initialize table 'l2enigma.vote' to 'l2migrate.vote'
  150. 1000_migrate.sh - WARNING: Not implemented migration for table 'vote'
  151.  
  152. migrator.sh - INFO : running /srv/sql/migrate/migrator.sh.d/9000_debug.sh
  153. disabled
  154.  
  155. migrator.sh - INFO : running /srv/sql/migrate/migrator.sh.d/zzzz_optimize.sh
  156. l2migrate.account_bonus Table is already up to date
  157. l2migrate.account_log OK
  158. l2migrate.accounts OK
  159. l2migrate.ally_data OK
  160. l2migrate.bans OK
  161. l2migrate.bbs_clanbonus
  162. note : Table does not support optimize, doing recreate + analyze instead
  163. status : OK
  164. l2migrate.bbs_clannotice Table is already up to date
  165. l2migrate.bbs_commission
  166. note : Table does not support optimize, doing recreate + analyze instead
  167. status : OK
  168. l2migrate.bbs_favorites OK
  169. l2migrate.bbs_mail OK
  170. l2migrate.bbs_memo OK
  171. l2migrate.bbs_news
  172. note : Table does not support optimize, doing recreate + analyze instead
  173. status : OK
  174. l2migrate.bbs_pointsave Table is already up to date
  175. l2migrate.bbs_skillsave Table is already up to date
  176. l2migrate.bot_report Table is already up to date
  177. l2migrate.bot_reported_punish Table is already up to date
  178. l2migrate.castle OK
  179. l2migrate.castle_damage_zones Table is already up to date
  180. l2migrate.castle_door_upgrade Table is already up to date
  181. l2migrate.castle_hired_guards OK
  182. l2migrate.castle_manor_procure OK
  183. l2migrate.castle_manor_production OK
  184. l2migrate.cataclysm OK
  185. l2migrate.char_templates OK
  186. l2migrate.character_blocklist OK
  187. l2migrate.character_bookmarks Table is already up to date
  188. l2migrate.character_craft_fails Table is already up to date
  189. l2migrate.character_effects_save OK
  190. l2migrate.character_friends OK
  191. l2migrate.character_group_reuse Table is already up to date
  192. l2migrate.character_hennas OK
  193. l2migrate.character_instances OK
  194. l2migrate.character_macroses OK
  195. l2migrate.character_mail Table is already up to date
  196. l2migrate.character_minigame_score
  197. note : Table does not support optimize, doing recreate + analyze instead
  198. status : OK
  199. l2migrate.character_post_friends Table is already up to date
  200. l2migrate.character_premium_items OK
  201. l2migrate.character_quests OK
  202. l2migrate.character_recipebook OK
  203. l2migrate.character_shortcuts OK
  204. l2migrate.character_skills OK
  205. l2migrate.character_skills_save OK
  206. l2migrate.character_sms_donate Table is already up to date
  207. l2migrate.character_subclasses OK
  208. l2migrate.character_variables OK
  209. l2migrate.character_votes Table is already up to date
  210. l2migrate.characters OK
  211. l2migrate.clan_data OK
  212. l2migrate.clan_description Table is already up to date
  213. l2migrate.clan_privs OK
  214. l2migrate.clan_skills OK
  215. l2migrate.clan_subpledges OK
  216. l2migrate.clan_subpledges_skills Table is already up to date
  217. l2migrate.clan_wars OK
  218. l2migrate.clanhall OK
  219. l2migrate.clanlist_service Table is already up to date
  220. l2migrate.communitybuff_grp Table is already up to date
  221. l2migrate.communitybuff_grp_allowed_buffs OK
  222. l2migrate.communitybuff_grp_buffs Table is already up to date
  223. l2migrate.couples Table is already up to date
  224. l2migrate.cursed_weapons Table is already up to date
  225. l2migrate.custom_acp Table is already up to date
  226. l2migrate.dominion OK
  227. l2migrate.dominion_rewards Table is already up to date
  228. l2migrate.epic_boss_spawn OK
  229. l2migrate.event_data Table is already up to date
  230. l2migrate.event_tvt_arena
  231. note : Table does not support optimize, doing recreate + analyze instead
  232. status : OK
  233. l2migrate.fishing_championship Table is already up to date
  234. l2migrate.fortress OK
  235. l2migrate.four_sepulchers_spawnlist OK
  236. l2migrate.game_log
  237. note : Table does not support optimize, doing recreate + analyze instead
  238. status : OK
  239. l2migrate.games Table is already up to date
  240. l2migrate.gameservers Table is already up to date
  241. l2migrate.global_tasks OK
  242. l2migrate.heroes OK
  243. l2migrate.heroes_diary OK
  244. l2migrate.hwid_bans Table is already up to date
  245. l2migrate.hwid_info Table is already up to date
  246. l2migrate.hwids_log OK
  247. l2migrate.item_auction Table is already up to date
  248. l2migrate.item_auction_bid Table is already up to date
  249. l2migrate.items OK
  250. l2migrate.items_delayed OK
  251. l2migrate.lastimperialtomb_spawnlist OK
  252. l2migrate.mail OK
  253. l2migrate.mail_attachments OK
  254. l2migrate.offline_buffers
  255. note : Table does not support optimize, doing recreate + analyze instead
  256. status : OK
  257. l2migrate.offline_buffs
  258. note : Table does not support optimize, doing recreate + analyze instead
  259. status : OK
  260. l2migrate.olympiad_history Table is already up to date
  261. l2migrate.olympiad_nobles OK
  262. l2migrate.petitions OK
  263. l2migrate.pets OK
  264. l2migrate.pets_skills OK
  265. l2migrate.raidboss_points OK
  266. l2migrate.raidboss_status OK
  267. l2migrate.random_spawn OK
  268. l2migrate.random_spawn_loc OK
  269. l2migrate.residence_functions OK
  270. l2migrate.server_variables OK
  271. l2migrate.seven_signs OK
  272. l2migrate.seven_signs_festival OK
  273. l2migrate.seven_signs_status OK
  274. l2migrate.siege_clans OK
  275. l2migrate.siege_guards OK
  276. l2migrate.siege_players Table is already up to date
  277. l2migrate.vote Table is already up to date
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!