Mangos 2.0.10.2 help me plz

[Tecko]

I have a 2.0.10 server runnign and i upgraded it today to the 2.0.10.2 and i have a copy of my 2.0.10 still on my comp. how do I transfer over all the players accounts to my new one? What file or directory are all the accounts and characters saved in? thanks =]

 

[iNViSiGOD]

Your in luck, I just had to do that with my mangos server this morning. Backup all character related databases, guild related and Item_instances, if you forget the last one you will appear to have all your EQ at the login screen but will be neekid when you enter the game.

 

[Tecko]

I have a 2.0.10 server runnign and i upgraded it today to the 2.0.10.2 and i have a copy of my 2.0.10 still on my comp. how do I transfer over all the players accounts to my new one? What file or directory are all the accounts and characters saved in? thanks =]

Your in luck, I just had to do that with my mangos server this morning. Backup all character related databases, guild related and Item_instances, if you forget the last one you will appear to have all your EQ at the login screen but will be neekid when you enter the game.

Thanks a lot =] .. Where might I find these? lol In my mangos file? or my MYsql? or.. uhm.. any idea?

 

[iNViSiGOD]

Did you install the stand alone mangos server? These fields are found using SQLyog or Navicat to explore your SQL databases.

 

[Tecko]

Na.. I didn't go through Navicat.. I'm using a different system, DJ execute's all in one. I can find them in the localhost/a/ thingy.. but I dont know how to copy them or transfer them to my new server. Are you familiar with this ????

 

[iNViSiGOD]

I'm personally not familiar with the stand alone as I prefer to have everything exposed and accessable if needs be. Try getting SQLYog and see if you can connect to the database. Hit Alt-Ctrl-Del and see of you have a mysql process running, if so get SQLYog and give it a shot.

 

[Tecko]

Thanks a lot buddddy. I'll give er a try

 

[iNViSiGOD]

Thanks a lot buddddy. I'll give er a try

Let me know what you find mate, if you can't get it I'll send you to the placed you will get answers for it, the designers web forums.

 

[Tecko]

Let me know what you find mate, if you can't get it I'll send you to the placed you will get answers for it, the designers web forums.

Hmm.. well i got SQLyog and I hopened it with the old server and I see all the files, but I don't know which ones to copy and how to import them into my new server. ? ?? :juggle: help plz?

 

[iNViSiGOD]

Ok, using SQLyog we are going to export each item one at a time, this wat it insures nothing gets lost. *Turns on monitor to Mangos server and opens SQLyog* OK! This could get messy because I don't know how the stand-alone works so bear with me.
You should have 2 different databases, one called mangos(or mangos_bc) and another called realmd(or realmd_bc) Right click on the first one and select "Backup as SQL Dump", select where you want it to save everything to and it will create a dump file, now do the same with your realmd/realmd_bc file.

Now we have everything backed up. Install the mangos server and SQLyog on the new PC. Once mangos is installed use SQLyog to create two new databases (same name as the ones you exported from the old server) once this is done right click the first database (the mangos one) and select "Restore from SQL Dump) select the SQL file you backed-up that matches the database you just made, it should start importing it, do the same with the realmd/realmd_bc database as well.

This should be all you need to do *IN THEORY* I don't guarentee anything.

 

[Tecko]

That sounds pretty simple. I'll give er a whirl.. these forums need a "thanks" button liek gamerzplanet. Well thanks a lot man! :turned: :clap:

 

[rigamrts]

when you uprade to that patch all your chars stay all it does is update some files no need to backup. now what you really want to do is start the server and in the cmd promtscreen type setgm your charname 6 so you can administer your server.