Database backups and mangos updates

[Svarr_]

I hope you can answer me some questions. I'm updating mangos and scriptdev right now (in fact I already did it but I have to wait until someone has helped me with my playerbot problem, before I can compile it) and I have never done it before.

So I would like to know if a backup of the databases (e.g. own items, mobs and characters...) is necessary when I update the emu or if it is only needed for a complete new installation?

Then what do I have to be careful about? I'm using SQLyog which has of course a backup as sql-dump function. Is it ok to safe all tables or would this be causing conflicts when I want to import it in the updated version? I mean there could be changes in the tables and when I import something from an older db I would automatically overwrite some data, or am I wrong?

Btw: Where are the tables safed anyway? I know how to acces them, but they have to be physically safed somewhere, right?

[Svarr_]

I just learned that I dont have to backup my stuff if I want to update mangos. So far so good.

[TheLuda]

Take a look at http://github.com/mangos-zero/database/. There you can see how you can backup your tables. You may need to add and remove a few tables depending on your mangos branch.

[Svarr_]

The problem wasnt how to backup, I wanted to know, if my chars and the accounts would be lost when I update mangos. Now I know the answer.

Another question:

I want to completely reinstall mangos. For this I want to completely delete the databases with their tables and all other data. (I already made a backup of every table of which I think its important for my ingame progress)

How should I proceed?

[Schmoozerd]

usually you don't have to care about the world or sd2 database, as these are well filled with the provided files.

so all that is left is the characters and realm database.

Usually you won't have need to recreate these two databases, as you can always create new accounds and new characters

[Svarr_]

Thanks Schmoozerd.

So its enough to drop the mangosdb and sd2db and to delete the mangos folder?

[antz]

Thanks Schmoozerd.

So its enough to drop the mangosdb and sd2db and to delete the mangos folder?

Thats what I normally do (unless you have added custom stuff to the mangos folder)