How to update the DB in your repack menu

These ads disappear when you log in.

Results 1 to 6 of 6
  1. #1
    xhopefullookx's Avatar Sergeant
    Reputation
    5
    Join Date
    Mar 2009
    Posts
    35
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)

    How to update the DB in your repack

    Im sure there have been guides to this before, but i searched and came up empty handed.

    Now we all know if you're new and in some cases old to the custom server game, using a repack is the easiest way to host a server. Yet sometimes people still want to keep things semi updated.

    I have authored 12 steps to update the databse in a repack!

    The example I am using is hearthstone but can be modified easily for any emu as the steps are the same just filenames are different

    Okie dokie so

    1) Goto RivalDB | Home and click on the "Get RDB" link
    a) Download the .sql file under changesets and the database.rar under World
    2) Start MySQl

    3) Start Navicat and log into SQl, your hostname ip is 127.0.0.1 user is root pass is root and port is 3306

    4) Once logged in you should see a folder on the left either called world or heartstone-world, right click it and delete it

    5) Right click under the other folders and goto "New Database..." name it whatever you like, i named mine rivalworld, dont worry about the other 2 boxes just click ok

    6) Unpack the Database.rar into a folder, doesnt matter which just know where it is

    7) Back in navicat double click your new world folder to open it, then in the big empty plane on the right, right click and select "execute batch file"

    In this window, click the ... next to the text bar select the database.sql file you just unpacked, click ok and let this run, it could take some time

    9) follow steps 7 and 8 to use the changeset.sql file you downloaded

    10) Goto File>Close Connection to ensure everything is closed and saved, exit navicat alltogether

    11) Shutdown MySQL and Apache

    12) Goto your heartstone folder and open heartstone-world.conf in notepad, look for the following line
    <WorldDatabase Hostname = "localhost" Username = "root" Password = "root" Name = "world" Port = "3306" Type = "1">

    Name = "World" is what you want to change
    Change it to whatever you named the new folder in SQL
    EG: i would change mine to Name = "Rivalworld"

    13) Save and close notepad

    I recommend restarting your comp you dont have to

    14) Launch SQL and Apache, you should be set!

    I think I gave the most detailed instructions i could, if you get stuck...holla

    comment rate appreciate! =)

    These ads disappear when you log in.

  2. #2
    Vindicated's Avatar Contributor
    Reputation
    226
    Join Date
    Aug 2008
    Posts
    1,068
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    +Rep x2 for the effort mate

    Suggestions:
    1.) Add pictures
    2.) Add READABLE colors
    3.) Remind the people reading this guide that if the database structure of the actual up-to-date core changes (not the repack), then this will not work because your repack doesn't support the latest database structural changes.


  3. #3
    AngelSandy's Avatar Knight-Lieutenant
    Reputation
    19
    Join Date
    Jan 2009
    Posts
    330
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    I don't know why so many is hyped up on colours <_<

  4. #4
    Gastricpenguin's Avatar Account not activated by Email
    Reputation
    980
    Join Date
    Feb 2007
    Posts
    2,237
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    This won't "update" your database at all. It's just wiping your old database and using a new one : /

  5. #5
    House.MD's Avatar Master Sergeant
    Reputation
    15
    Join Date
    Sep 2007
    Posts
    112
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    As Gastricpenguin said. This is still something like update, maybe if you are running a blizzlike server and haven't changed anything in the DB you can use it, if not, there is no point of this at all. It would be nice to see a guide for real update without wipingeverything custom.

  6. #6
    Bunster's Avatar Knight-Champion
    Reputation
    19
    Join Date
    May 2008
    Posts
    553
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Originally Posted by AngelSandy View Post
    I don't know why so many is hyped up on colours <_<
    lool i hear ya, although im making new server this will help thx *bookmarked*

Similar Threads

  1. [Guide] how to add the frostmourne to your server
    By ReppzYouTube in forum WoW EMU Guides & Tutorials
    Replies: 23
    Last Post: 01-20-2009, 01:20 PM
  2. [How To] Remove the gryphons of your actionbar - STEP BY STEP.
    By Scarecr0w in forum WoW UI, Macros and Talent Specs
    Replies: 8
    Last Post: 01-08-2009, 08:04 PM
  3. How to update the client
    By zozoka in forum WoW ME Questions and Requests
    Replies: 3
    Last Post: 08-09-2008, 01:22 AM
  4. How to become the leader of your guild.
    By kemalraik in forum World of Warcraft Guides
    Replies: 13
    Last Post: 04-04-2008, 07:32 PM
  5. [GUIDE] how to change the ip of your server
    By InternetExplorer in forum WoW EMU Guides & Tutorials
    Replies: 6
    Last Post: 02-02-2008, 06:11 PM
All times are GMT -5. The time now is 02:45 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search