Database update

[minipopov]

Hi,

I want install my mangos server and i m stucking at database. All i need is tu update my database and i don't realy understand how we must do this.

1) Create database characters, mangos, realmd (and scriptdev2...)

2) Import base:

So make 'mysql -u root -p characters < sql/characters.sql | mysql -u root -p mangos< sql/mangos.sql | mysql -u root -p realmd< sql/realmd.sql '

3) Last step is to update database, isn't it?

So go in sql/update, unzip 0.5-0.17.zip. Now, how do you apply all .sql? Is there a script somewhere to put all .sql in the right order?

[Hikari]

First of all it is a great help, if you would provide which MaNGOS server you want to install. For now I assume you want to install MaNGOS Three (Cataclysm).

In which of the three steps you described, are you right now? In the third I guess.

You don't have to apply all database updates. It depends on how fresh your newly installed database is. Usually it's none or just a few files.

Updates within ZIP Folders are archived updates and are very old and aren't needed at all.

If you start up your server it will show you a message, if your database is outdated and tells you which update is needed. Then you've to apply all updates between your current database version and the requested version into the appropriate database.

In your update directory you can find a readme file in which is descriped what structure the update files follows, so you can find out which file is required and to which database it belongs.