Jump to content
TrinityCore

Rochet2

Members
  • Posts

    967
  • Joined

  • Last visited

  • Days Won

    83

Posts posted by Rochet2

  1. The DB import system should probably be changed somehow.
    It seems those errors probably start to pop up once old updates are moved to the /old/ directory.

    https://github.com/TrinityCore/TrinityCore/blob/6.x/sql/old/6.x/world/02_2015_11_08/2015_11_07_04_world.sql

    Solution should not be just redoing whole DB.
    Maybe the warning should be removed. Or the system should check the old directories also for any SQLs you may have executed in the past.

  2. Make sure you have TOOLS checked in cmake before configure & generate & compile.
    Once you have compiled the core with the tools you can see them in the folder where the worldserver.exe is at.
    Move the mapextractor and vmap4extractor and vmap4assembler to the wow installation folder (needs to be 3.3.5 or 6.x depending on what patch core you are compiling).

    Start the mapextractor.exe and wait until it finishes.
    Create a bat file (a file with .bat extension / file type) that has the following content:

    vmap4extractor.exe
    md vmaps
    vmap4assembler.exe Buildings vmaps
    pause
    
    
    
    Run the bat file and wait until it is finished
    That bat runs the extractor, creates vmaps folder and runs assembler with the Buildings and vmaps folders as parameters so you could do it through cmd as well if you want to.
    
    After everything is finished move the newly created maps and vmaps and dbc folders to the folder that worldserver.exe is at (the server folder).
    You can delete the Buildings folder that was created by the vmap extractor, it was used by the vmap assembler and is no longer needed afterwards.
    
    If you want mmaps you should now run the mmaps_generator that is in the server folder (next to worldserver.exe). Make sure the vmaps etc is in the same folder since the mmap generator uses them to generate the mmaps.
    • Upvote 1
  3. You are not supposed to run the update files from the TDB download if you are creating a new DB.

    Instead you only run the TDB full sql file to world database and then you run the updates from sql/updates/world which is located in the source you downloaded: https://github.com/TrinityCore/TrinityCore/tree/3.3.5/sql/updates/world

    Far easier way of setting up the database is by using the new system that creates it for you.

    1. Delete existing databases
    2. make sure the database creation system is enabled (under UPDATE SETTINGS) and database settings are correct (under CONNECTIONS AND DIRECTORIES) in worldserver.conf
    3. Download TDB full and place the files to server folder (so the TDB full is next to the worldserver.exe)
    4. start worldserver.exe and press enter when it asks if you want to create databases
      • Note that if you get errors you may have deleted or moved the source folder that was used to compile the server.
        In that case you should download the source and set SourceDirectory to the source path under CONNECTIONS AND DIRECTORIES in worldserver.conf.
      • Otherwise check your mysql login credentials and read the error message as it may tell you what to do.
    5. once server is up you can start using it normally
  4. Can you say a specific table and the values of the size of it (size and amount of rows)?
    Currently there is no clear single example with exact values.

    The locales tables in general vary from 1KiB to 70MiB so its hard to compare with "non modified" values.
    Also the memory usage is probably not directly related to the saved data. Im sure if we have exact same databases they will probably vary in size.

    Its not likely any script unless you can find the table name of the increasing table in them.

×
×
  • Create New...