Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Transferir base de datos MuEMU S4 a MuEMU S6  (Visto 3945 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline musantamarta Posteado: February 20, 2019, 11:00:45 PM | Modificado: October 26, 2019, 11:26:13 PM by ZabiinoOo

  • 0 puntos por ventas
  • *
  • Rank: Dedicado
  • Posts: 51
  • Gracias recibida: 12871
  • ar
PRECAUCIONES
- No sirve para pasar de S6 a S8, ya que la longitud de inventarios y baules son distintas.
- Siempre hagan backup antes de probarlo, no nos hacemos responsables si dañan su base de datos.
- Solo ejecuten el script una sola vez, hacerlo mas veces puede dañar la base de datos.
- Solo como curiosidad, podría darse el caso de que el orden de los sockets cambien en las cuentas, es algo poco probable, solo lo menciono porque eso sucede cuando adaptan la base de datos titan tech a muemu.

COMO USARLO
1. Hace una copia de seguridad/Back UP de su base de datos S4.
2. Restauran su base de datos S4 y le colocan el nombre MuOnline_Bug.
3. Restauran la base de datos S6 con el nombre MuOnline.
4. Abren el SQL, se conectar y hacen click en New Query/Nueva Consulta.
5. Pegan el SCRIPT completo, seleccionan la base de datos MuOnline y lo ejecutan apretando en Execute/Ejcutar o presionando F5.
NOTA: OJO SOLO DEBEN EJECUTAR UNA VEZ, SOLO UNA VEZ.
6. Eliminan la base de datos MuOnline_Bug.

si hiciste todos los pasos iguales a los de arriba y usaste los mismos nombres en base de datos ejecutar el siguiente script asi como se deja si hiciste modificacion de las base de datos cambiar nombres en scripts

Code: [Select]
-- TRASPASAR BASE DE DATOS MUEMU S4 A S6 (NO FUNCIONA DE S6 A S8, PORQUE LA LONGITUD DE INVENTARIOS ES DISTINTA)

Insert Into [MuOnline].[dbo].AccountCharacter (Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
Select [MuOnline_Bug].[dbo].AccountCharacter.Id, [MuOnline_Bug].[dbo].AccountCharacter.GameID1, [MuOnline_Bug].[dbo].AccountCharacter.GameID2, [MuOnline_Bug].[dbo].AccountCharacter.GameID3, [MuOnline_Bug].[dbo].AccountCharacter.GameID4, [MuOnline_Bug].[dbo].AccountCharacter.GameID5, [MuOnline_Bug].[dbo].AccountCharacter.GameIDC from [MuOnline_Bug].[dbo].AccountCharacter
GO

Insert Into [MuOnline].[dbo].Character (AccountID, Name, cLevel, ResetCount, MasterResetCount, LevelUpPoint, Class, Experience, Strength, Dexterity,Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest)
Select [MuOnline_Bug].[dbo].Character.AccountID, [MuOnline_Bug].[dbo].Character.Name, [MuOnline_Bug].[dbo].Character.cLevel, [MuOnline_Bug].[dbo].Character.ResetCount, [MuOnline_Bug].[dbo].Character.MasterResetCount, [MuOnline_Bug].[dbo].Character.LevelUpPoint, [MuOnline_Bug].[dbo].Character.Class, [MuOnline_Bug].[dbo].Character.Experience, [MuOnline_Bug].[dbo].Character.Strength, [MuOnline_Bug].[dbo].Character.Dexterity,[MuOnline_Bug].[dbo].Character.Vitality, [MuOnline_Bug].[dbo].Character.Energy, [MuOnline_Bug].[dbo].Character.Inventory, [MuOnline_Bug].[dbo].Character.MagicList, [MuOnline_Bug].[dbo].Character.Money, [MuOnline_Bug].[dbo].Character.Life, [MuOnline_Bug].[dbo].Character.MaxLife, [MuOnline_Bug].[dbo].Character.Mana, [MuOnline_Bug].[dbo].Character.MaxMana, [MuOnline_Bug].[dbo].Character.MapNumber, [MuOnline_Bug].[dbo].Character.MapPosX, [MuOnline_Bug].[dbo].Character.MapPosY, [MuOnline_Bug].[dbo].Character.MapDir, [MuOnline_Bug].[dbo].Character.PkCount, [MuOnline_Bug].[dbo].Character.PkLevel, [MuOnline_Bug].[dbo].Character.PkTime, [MuOnline_Bug].[dbo].Character.MDate, [MuOnline_Bug].[dbo].Character.LDate, [MuOnline_Bug].[dbo].Character.CtlCode, [MuOnline_Bug].[dbo].Character.DbVersion, [MuOnline_Bug].[dbo].Character.Quest from [MuOnline_Bug].[dbo].Character
GO

Insert Into [MuOnline].[dbo].Guild ( G_Name, G_Mark, G_Score, G_Master, G_Count, G_Notice)
Select [MuOnline_Bug].[dbo].Guild.G_Name, [MuOnline_Bug].[dbo].Guild.G_Mark, [MuOnline_Bug].[dbo].Guild.G_Score, [MuOnline_Bug].[dbo].Guild.G_Master, [MuOnline_Bug].[dbo].Guild.G_Count, [MuOnline_Bug].[dbo].Guild.G_Notice from [MuOnline_Bug].[dbo].Guild
GO

Insert Into [MuOnline].[dbo].GuildMember ( Name, G_Name, G_Level)
Select [MuOnline_Bug].[dbo].GuildMember.Name, [MuOnline_Bug].[dbo].GuildMember.G_Name, [MuOnline_Bug].[dbo].GuildMember.G_Level from [MuOnline_Bug].[dbo].GuildMember
GO

Insert Into [MuOnline].[dbo].MEMB_INFO ( memb___id, memb__pwd, memb_name, sno__numb, post_code, addr_info, addr_deta, tel__numb, phon_numb, mail_addr, fpas_ques, fpas_answ, job__code, appl_days, modi_days, out__days, true_days, mail_chek, bloc_code, ctl1_code)
Select [MuOnline_Bug].[dbo].MEMB_INFO.memb___id, [MuOnline_Bug].[dbo].MEMB_INFO.memb__pwd, [MuOnline_Bug].[dbo].MEMB_INFO.memb_name, [MuOnline_Bug].[dbo].MEMB_INFO.sno__numb, [MuOnline_Bug].[dbo].MEMB_INFO.post_code, [MuOnline_Bug].[dbo].MEMB_INFO.addr_info, [MuOnline_Bug].[dbo].MEMB_INFO.addr_deta, [MuOnline_Bug].[dbo].MEMB_INFO.tel__numb, [MuOnline_Bug].[dbo].MEMB_INFO.phon_numb, [MuOnline_Bug].[dbo].MEMB_INFO.mail_addr, [MuOnline_Bug].[dbo].MEMB_INFO.fpas_ques, [MuOnline_Bug].[dbo].MEMB_INFO.fpas_answ, [MuOnline_Bug].[dbo].MEMB_INFO.job__code, [MuOnline_Bug].[dbo].MEMB_INFO.appl_days, [MuOnline_Bug].[dbo].MEMB_INFO.modi_days, [MuOnline_Bug].[dbo].MEMB_INFO.out__days, [MuOnline_Bug].[dbo].MEMB_INFO.true_days, [MuOnline_Bug].[dbo].MEMB_INFO.mail_chek, [MuOnline_Bug].[dbo].MEMB_INFO.bloc_code, [MuOnline_Bug].[dbo].MEMB_INFO.ctl1_code from [MuOnline_Bug].[dbo].MEMB_INFO
GO

Insert Into [MuOnline].[dbo].MEMB_STAT ( memb___id, ConnectStat, ServerName, IP, ConnectTM, DisConnectTM)
Select [MuOnline_Bug].[dbo].MEMB_STAT.memb___id, [MuOnline_Bug].[dbo].MEMB_STAT.ConnectStat, [MuOnline_Bug].[dbo].MEMB_STAT.ServerName, [MuOnline_Bug].[dbo].MEMB_STAT.IP, [MuOnline_Bug].[dbo].MEMB_STAT.ConnectTM, [MuOnline_Bug].[dbo].MEMB_STAT.DisConnectTM from [MuOnline_Bug].[dbo].MEMB_STAT
GO

Insert Into [MuOnline].[dbo].OptionData (Name, Skillkey, GameOption, Qkey, Wkey, Ekey, ChatWindow, Rkey, QWERLevel )
Select [MuOnline_Bug].[dbo].OptionData.Name, [MuOnline_Bug].[dbo].OptionData.Skillkey, [MuOnline_Bug].[dbo].OptionData.GameOption, [MuOnline_Bug].[dbo].OptionData.Qkey, [MuOnline_Bug].[dbo].OptionData.Wkey, [MuOnline_Bug].[dbo].OptionData.Ekey, [MuOnline_Bug].[dbo].OptionData.ChatWindow, [MuOnline_Bug].[dbo].OptionData.Rkey, [MuOnline_Bug].[dbo].OptionData.QWERLevel from [MuOnline_Bug].[dbo].OptionData
GO

Insert Into [MuOnline].[dbo].warehouse ( AccountID, Items, Money, EndUseDate, DbVersion, pw)
Select [MuOnline_Bug].[dbo].warehouse.AccountID, [MuOnline_Bug].[dbo].warehouse.Items, [MuOnline_Bug].[dbo].warehouse.Money, [MuOnline_Bug].[dbo].warehouse.EndUseDate, [MuOnline_Bug].[dbo].warehouse.DbVersion, [MuOnline_Bug].[dbo].warehouse.pw from [MuOnline_Bug].[dbo].warehouse
GO

Creditos: Carlos Mondragon

Gracias:


Offline ChanhEp #1 Posteado: February 20, 2019, 11:38:58 PM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 72
  • Gracias recibida: 18
  • vn
How to transfer db s6 to db s8, sir?


Online ZabiinoOo #2 Posteado: March 04, 2019, 01:06:05 AM

  • MAESTRO

  • US. DE HONOR

  • LEYENDA

  • Administrador
  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 7.270
  • Gracias recibida: 125174
  • pe
How to transfer db s6 to db s8, sir?

is same, only not is possible transfer warehouse and inventory




Prohibido pedir soporte via MP
Leer las reglas de cada seccion
we trust god

Offline Lude #3 Posteado: October 26, 2019, 11:25:16 PM | Modificado: October 26, 2019, 11:28:42 PM by Lude

  • MAESTRO

  • C++ Coder
  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 388
  • Gracias recibida: 19154
  • us
Creditos: Carlos Mondragon

PD: Para los que usan MuEmu les hara falta algo muy importante, el CashShopData  y el AccountLevel, aca se los dejo

Code: [Select]
Insert Into [MuOnline].[dbo].CashShopData (AccountID, WCoinC, GWCoinP, GoblinPoint)
Select [MuOnlineS6].[dbo].CashShopData.AccountID, [MuOnlineS6].[dbo].CashShopData.WCoinC, [MuOnlineS6].[dbo].CashShopData.WCoinP, [MuOnlineS6].[dbo].CashShopData.GoblinPoint from [MuOnlineS6].[dbo].CashShopData
GO


Insert Into [MuOnline].[dbo].MEMB_INFO ( memb___id, memb__pwd, memb_name, sno__numb, post_code, addr_info, addr_deta, tel__numb, phon_numb, mail_addr, fpas_ques, fpas_answ, job__code, appl_days, modi_days, out__days, true_days, mail_chek, bloc_code, ctl1_code, AccountLevel, AccountExpireDate, Lock)
Select [MuOnlineS6].[dbo].MEMB_INFO.memb___id, [MuOnlineS6].
[dbo].MEMB_INFO.memb__pwd, [MuOnlineS6].[dbo].MEMB_INFO.memb_name, [MuOnlineS6].
[dbo].MEMB_INFO.sno__numb, [MuOnlineS6].[dbo].MEMB_INFO.post_code, [MuOnlineS6].
[dbo].MEMB_INFO.addr_info, [MuOnlineS6].[dbo].MEMB_INFO.addr_deta, [MuOnlineS6].
[dbo].MEMB_INFO.tel__numb, [MuOnlineS6].[dbo].MEMB_INFO.phon_numb, [MuOnlineS6].
[dbo].MEMB_INFO.mail_addr, [MuOnlineS6].[dbo].MEMB_INFO.fpas_ques, [MuOnlineS6].
[dbo].MEMB_INFO.fpas_answ, [MuOnlineS6].[dbo].MEMB_INFO.job__code, [MuOnlineS6].
[dbo].MEMB_INFO.appl_days, [MuOnlineS6].[dbo].MEMB_INFO.modi_days, [MuOnlineS6].
[dbo].MEMB_INFO.out__days, [MuOnlineS6].[dbo].MEMB_INFO.true_days, [MuOnlineS6].
[dbo].MEMB_INFO.mail_chek, [MuOnlineS6].[dbo].MEMB_INFO.bloc_code, [MuOnlineS6].
[dbo].MEMB_INFO.ctl1_code, [MuOnlineS6].[dbo].MEMB_INFO.AccountLevel, [MuOnlineS6].
[dbo].MEMB_INFO.AccountExpireDate, [MuOnlineS6].[dbo].MEMB_INFO.Lock from [MuOnlineS6].[dbo].MEMB_INFO
GO

Creditos: Lude

Gracias:


Offline samsunggon #4 Posteado: December 20, 2019, 08:38:27 AM | Modificado: December 20, 2019, 10:29:46 AM by samsunggon

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 434
  • Gracias recibida: 1308
  • ph
help with this error
after transfering.
all items have 5 sockets


DISCORD: valentino1515


Offline PRONEXUS #5 Posteado: April 05, 2020, 09:16:27 PM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 243
  • Gracias recibida: 71
  • ar

Offline RifleMaN_ #6 Posteado: October 27, 2022, 04:23:57 AM

  • 0 puntos por ventas
  • *
  • Rank: Destacado
  • Posts: 86
  • Gracias recibida: 6
  • br
Es posible migrar de 1.01T a la temporada 6 con los itens?


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
5 Replies
2220 Views
Last post September 14, 2016, 09:58:04 AM
by ronald15
1 Replies
2205 Views
Last post May 22, 2018, 09:51:10 PM
by xXSiniestroXx
3 Replies
1741 Views
Last post January 08, 2018, 07:02:22 PM
by -Rastaa.TSM☢
0 Replies
475 Views
Last post October 27, 2018, 04:29:23 PM
by Azzlaer
3 Replies
1827 Views
Last post June 10, 2019, 03:27:11 PM
by dabarrio