Fully Updated Database

mikenune · #1 04-19-2004, 09:34 AM

The 0.5.6 DB is Here!

Note: This DB does NOT work with EQEMu 0.5.7!

Although the previous version was plagued with problems, the current version (for EQEMu servers v0.5.6) should work without any issues. PLEASE NOTE THAT THIS DATABASE CAN TAKE A LONG TIME TO SOURCE. This version of the DB has more than a half a million records spread across fifty six tables! Please be patient!

Current version: http://www.raskii.net/eqemu/eqemu056.zip [6.49MB download]

Previous version(s):
0.5.5 DB: http://www.raskii.net/eqemu/eqemu055.sql.zip [4.25MB download] (do not use!)

README.TXT

Code:

These SQL dumps contain:
 - Myra's db version DR5.3.2
 - TCMyWorld's Alpha 1 and 2
 - govtcheese's loottable and NPC db version 0.3
 - the 03/15/2004 door update

Instructions:
 1) Extract the SQL files into MySQL's bin folder (typically C:\mysql\bin).
 2) Create the eq database.
     A) From the command prompt type "\mysql\bin\mysql -b -s -f -u root -p &lt;password>"
        (where &lt;password> is your password, if any).
     B) Type "create eq;"
 2) Dump the SQL files into your new database.
     A) Type "use database eq"
     B) Type "source sql1.sql;"
     B) Type "source sql2.sql;"
     B) Type "source sql3.sql;"
 3) Create any necessary user accounts.
     A) Type "INSERT INTO account (id, name, charname, packencrypt, sharedplat,
        password, status, lsaccount_id, gmspeed, revoked) VALUES (1, 'eqemu', '',
        '', 0, 'eqemu', 250, NULL, 0, 0);"
     B) Repeat the above step as necessary. Just be sure to change the id, name,
        password, and status fields for each user.
 4) Enjoy!

Many thanks to the EQEMu devs for their tireless work in creating this most excelent
program. Also, I would like to thanks both Myra and govtcheese for their efforts in
fleshing out the db. Keep up the great work guys!

mikenune