Migración Personajes Trinity Core 3.1.3 a 3.3.2a

Buenas tardes,

Soy relativamente nuevo en esto y tengo un pequeño problema... a ver si alguien que me lea, me puede ayudar...

Tal y como he puesto en el asunto, no se como migrar los personajes de la versión 3.1.3 a 3.3.2a de Trinity Core...

Lo he intentado importando charecters y realmd con SQLyog de la version 3.1.3 a .sql e importandola a la nueva db de la versión 3.3.2a... la importación se realiza con éxito... entro perfectamente con mi user y pass pero después no veo mis personajes... Os adjunto el log que me saca el server por si sabe alguien que puede estar pasando... o si hay otro sistema... porque hay poca información sobre el tema googleando... y llevo así ya 1 mes para hacerlo...

Muchas gracias de antemano amigos

Mario

____________________________________________________________

2010-03-09 14:37:01 query ERROR: Unknown column 'instance_reset.difficulty' in 'on clause'
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('249','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('309','0','1268366400')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('409','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('469','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('509','0','1268366400')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('531','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('532','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('533','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('534','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('544','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('548','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('550','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('564','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('565','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('568','0','1268366400')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('580','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('603','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('615','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('616','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('624','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('631','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('649','0','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('249','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('269','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('533','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('540','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('542','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('543','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('545','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('546','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('547','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('552','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('553','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('554','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('555','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('556','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('557','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('558','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('560','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('574','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('575','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('576','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('578','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('585','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('595','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('598','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('599','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('600','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('601','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('602','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('603','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('604','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('608','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('615','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('616','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('619','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('624','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('631','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('632','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('649','1','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('650','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('658','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('668','1','1268193600')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('631','2','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('649','2','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('631','3','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:01 SQL: INSERT INTO instance_reset VALUES ('649','3','1268712000')
2010-03-09 14:37:01 SQL ERROR: Column count doesn't match value count at row 1
2010-03-09 14:37:53 SQL: SELECT mainTank, mainAssistant, lootMethod, looterGuid, lootThreshold, icon1, icon2, icon3, icon4, icon5, icon6, icon7, icon8, isRaid, difficulty, raiddifficulty, leaderGuid FROM groups
2010-03-09 14:37:53 query ERROR: Unknown column 'raiddifficulty' in 'field list'
2010-03-09 14:38:33 SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.data FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '7' ORDER BY characters.guid
2010-03-09 14:38:33 query ERROR: Unknown column 'characters.gender' in 'field list'
2010-03-09 14:38:36 SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.data FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '7' ORDER BY characters.guid
2010-03-09 14:38:36 query ERROR: Unknown column 'characters.gender' in 'field list'
2010-03-09 14:43:22 SQL: UPDATE realmlist SET color = 2 WHERE id = '1'
2010-03-09 14:43:22 SQL ERROR: Can't connect to MySQL server on '127.0.0.1' (10061)
2010-03-09 14:52:28 SQL: SELECT characters.guid, characters.name, characters.race, characters.class, characters.gender, characters.playerBytes, characters.playerBytes2, characters.level, characters.zone, characters.map, characters.position_x, characters.position_y, characters.position_z, guild_member.guildid, characters.playerFlags, characters.at_login, character_pet.entry, character_pet.modelid, character_pet.level, characters.data FROM characters LEFT JOIN character_pet ON characters.guid=character_pet.owner AND character_pet.slot='0' LEFT JOIN guild_member ON characters.guid = guild_member.guid WHERE characters.account = '7' ORDER BY characters.guid
2010-03-09 14:52:28 query ERROR: Unknown column 'characters.gender' in 'field list'
2010-03-09 15:07:28 SQL: UPDATE account SET online = 0 WHERE id = 7;
2010-03-09 15:07:28 SQL: UPDATE characters SET online = 0 WHERE account = 7;
2010-03-09 15:07:28 SQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:28 SQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:32 SQL: UPDATE uptime SET uptime = 1200, maxplayers = 1 WHERE realmid = 1 AND starttime = 1268142452
2010-03-09 15:07:32 SQL: SELECT guid,position_x,position_y,map,player FROM corpse WHERE UNIX_TIMESTAMP()-time > '1200' AND corpse_type = '0'
2010-03-09 15:07:32 SQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:32 query ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:32 SQL: DELETE FROM logs WHERE (time + 1209600) < 1268143652;
2010-03-09 15:07:32 SQL: SELECT guid,position_x,position_y,map,player FROM corpse WHERE UNIX_TIMESTAMP()-time > '259200' AND corpse_type <> '0'
2010-03-09 15:07:32 SQL ERROR: Access denied for user 'root'@'localhost' (using password: YES)
2010-03-09 15:07:32 query ERROR: Access denied for user 'root'@'localhost' (using password: YES)

Actualizando... tengo algunas lagunas mentales sobre las actualizaciones... no se muy bien como hacerlas... ¿hay algún manual que me explique paso a paso la mecánica a seguir...? Porque actualizar ya lo intenté pero tuve problemas también con las importaciones de los archivos que me bajaba con Tortoise... las actualizaciones que me bajaba al importarlas con SQLyog me daban error...

Me podrías decir como actualizo desde 0 mi querido Trinity Core 3.1.3 please!??

Ansss... no lo encuentro... y no es por se vago ni mucho menos... me he estoy mirando por todas las entradas de los Foros y no encuentro nada que solucione mi duda existencial que me esta quitando horas de sueño... ya no se ni que poner en google... he buscado hasta en francés...

Echame una manita please Fran...

De todas formas te agradezco las contestaciones tan rápidas de antes... muchas veces las preguntas se quedan en el aire en los foros como me ha pasado en casi todos...

Gracias... pero me he quedado igual... se que tengo que hacer todo eso pero no se como...

Buenas,

Pues lo que he hecho ha sido sustituir los archivos realmd y characters que había en la carpeta mysql data... pero... lamentablemente sigo entrando en la cuenta pero no puedo ver los personajes creados... tengo que hacer algo más?? Algún tipo de compilación con la bd???