How to run multiple .SQL queries at once? menu

User Tag List

Results 1 to 6 of 6
  1. #1
    Deathbringer123's Avatar Master Sergeant
    Reputation
    25
    Join Date
    Oct 2010
    Posts
    121
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to run multiple .SQL queries at once?

    Hey

    Just redownloaded TrinityCore got the server files sorted e.g .dll's and manin server and auth sorted but now im doing the database done auth and character db and run the TDB sql file for the world and now need to run the 1000's SQL Updates in the world update folder and im not up for sitting there and doing it all manually and would like to know if it is possible to run them all at once with HeidiSQL or any other program, any help is greatly apreciated

    Thanks

    These ads disappear when you log in.

  2. #2
    stoneharry's Avatar Moderator Harry

    Authenticator enabled
    Reputation
    1593
    Join Date
    Sep 2007
    Posts
    4,513
    Thanks G/R
    139/131
    Trade Feedback
    0 (0%)
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Are you SURE you need to apply those updates?

    I think you only need to apply the ones newer than your database version (which is only a couple if any). If you really need to apply them all, write a script to merge the files and then execute it. But I don't think you do, not at all. :G

  3. #3
    Deathbringer123's Avatar Master Sergeant
    Reputation
    25
    Join Date
    Oct 2010
    Posts
    121
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok , will check them now to see which ones need doin

    Thanks

  4. #4
    Deathbringer123's Avatar Master Sergeant
    Reputation
    25
    Join Date
    Oct 2010
    Posts
    121
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah need to run them all The database is version is 02/12 and i got updates higher then that

  5. #5
    Deathbringer123's Avatar Master Sergeant
    Reputation
    25
    Join Date
    Oct 2010
    Posts
    121
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Its alrite i got a .bat to combine the updates then i just run 1 sql file


    Thanks anyway

  6. #6
    LilleCarl's Avatar Active Member
    Reputation
    65
    Join Date
    Feb 2008
    Posts
    132
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    open a commandline and type:
    Windows:
    copy *.sql combined.sql
    *NIX:
    cat *.sql > combined.sql
    Violence doesn't solve shit, but everything else.

Similar Threads

  1. How to Run Multiple Clients in Diablo 3
    By darkpanda1 in forum Diablo 3 Guides
    Replies: 3
    Last Post: 09-24-2013, 03:21 AM
  2. how to run multiple immortals with different account
    By j4sp3r in forum Diablo 3 Bots and Programs
    Replies: 4
    Last Post: 07-02-2012, 04:28 AM
  3. How to run multiple instances of D3 without copying maps.
    By blablabloto in forum Diablo 3 Guides
    Replies: 1
    Last Post: 06-13-2012, 03:51 PM
  4. Executing multiple SQL files at once
    By roguesownu in forum World of Warcraft Emulator Servers
    Replies: 4
    Last Post: 10-21-2007, 07:51 AM
All times are GMT -5. The time now is 04:36 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2022 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search