[SOLVED] CMangos Eluna Classic Database Installation Procedure

[gussaki]

Hello everybody .

I already started my new CMangos Eluna Classic installation and i am like 90% Done .

Since i want to have a correct installation procedure from the beginning and not come back and forth and check what wenr wrong etc , i want a bit of a help
to clarify some bits of the installation procedure .

I am about to begin doing that now : Final Stage of Database installation - Updating

In other words i am stuck on thinking what updates i must implement to the databases.

DB Version : 1.4.2 For core z2583 and SD2 z2715

I have :

1: C:\Mangos\classicdb\updates & C:\Mangos\classicdb\old_releases in my classic DB folder .
2: C:\Mangos\mangos\sql\updates starting from folder 0.5 up to z2621_s2263_12823_04_mangos_creature.sql

Now some questions .

1: Is there a standard way to check what updates are needed to be installed ?
2: Where do i have to start from implementing the Sql files , and to what Database ?
3: Which is the safest way to merge sql files so i don't have to run the queries one by one ?


Waiting for your replies really anxiously

Thanks a lot for the previous replies from you that made my installation possible so far.

 

[Rochet2]

1: Is there a standard way to check what updates are needed to be installed ?
2: Where do i have to start from implementing the Sql files , and to what Database ?
3: Which is the safest way to merge sql files so i don't have to run the queries one by one ?

I havent used mangos in a while, but they version the SQLs by a number usually as a row or column name in a table called version or similar in the database.
So once you run the base DB, you can check the table and see what you should run next. The SQL files will have the version numbers in the names.
This info may be outdated.

The file names say characters, world and so on, which tells you what database to execute to.
You usually on fresh installation only execute the files from sql/base/ and the full DB SQL from some project if the emulator does not provide the database and then
you need updates usually which are provided partly often by the DB project and after running those if any you need to run the DB updates from sql/updates/world or sql/updates or similar path.
Only run the updates for world database

On windows you can make a bat file that has this code:
copy *.sql merged.sql
it will merge all the files in the current folder that are .sql ending and output it to merged.sql
however do delete merged.sql before running if you run it twice so the code wont be doubled or anything.
there are probably similar ways for linux as well. Just google around maybe? (bash merge text files)