Which orders should the sql files be run?

Results 1 to 3 of 3
  1. #1
    Member Jelsoft is offline
    MemberRank
    Dec 2006 Join Date
    43Posts

    Which orders should the sql files be run?

    I have two packs:

    1) MaNGOS_2806+ScriptDev_147+MCH_1.5c+Anticheat_1.5
    2) SDB_0.5.3_Changeset_20-2806

    In the MaNGOS_2806+ScriptDev_147+MCH_1.5c+Anticheat_1.5 are the following SQL files:

    create_mysql.sql
    drop_mysql.sql
    mangos.sql
    realmd.sql
    scripts.sql
    spell_anticheat.sql

    SDB_0.5.3_Changeset_20-2806 have two files:

    mangos.sql
    realmd.sql

    Which order should I run these files in mySQL?


  2. #2
    Sorcerer Supreme elldiablo is offline
    Member +Rank
    Oct 2005 Join Date
    Outland --> Shattrath cityLocation
    478Posts
    you need te use the mangos .sql and realmd.sql from the SDB_0.5.3_changeset ........ the other no need of it also look at te nummber if they are bigger then your mangosnumbber , for example your mangos is 2806 and the files in update are 2809 they need the be don .all the nummbers before 2806 they dont need the be fixt

  3. #3
    Sorcerer Supreme aceindy is offline
    Member +Rank
    Jun 2006 Join Date
    322Posts
    create_mysql.sql
    drop_mysql.sql
    mangos.sql
    realmd.sql
    scripts.sql
    spell_anticheat.sql
    These are SQL structures only (templates).

    mangos.sql
    realmd.sql
    These are SQL structures including world data



Advertisement