A LOT of updates!

[xCode195]

So my mangos version is 10537_01 and I have to update all the way to 11701_01 and there is no way i am updating my databases one by one.

Is there any workaround or a way to automatize the process somehow?

Thanks,all help is appreciated!

[Schmoozerd]

there are tons of ways to automate this - however you should only automate if you know what you are doing, don't care about dataz or use good enough backups:

1) python-scripts (exist here in forums somewhere)

2) bash/ bat scripts (I think I posted the one I use sometimes around)

3) for f in *.sql; do mysql -uUSER -pPASS DATABASE < $f; done

4) cat *.sql > help.sql and import help.sql

5) write a small tool that selects a Database and which you associate with *.sql files

[Cyberfreak]

If there is no self-made content, which by the way should always be prepared in sql statements, you simply can drop the whole mangos (and SD2) database and replace it with an actual version. This should not affect the account or character database. For this two, there are much less updates, which can easily be inserted one by one.