|Main Page Other languages: English • German • FrenchArcEmu Website ArcEmu Forum Bug Tracker|
How to set up your world, logon, and character databases.
MySQL can be downloaded for free from here.
Installing a MySQL client
A SQL client lets you easily connect to the databases. You'll need one to import your initial database.
This is a list of some free SQL clients for Windows:
- SQLyog Community Edition
- Dreamcoder for MySQL
- Navicat Lite
- dbForge Studio for MySQL 5.0 Express
In Linux you can also use the command line client that comes with MySql, which is ultimately the fastest way to import a full database.
Creating empty databases
Using your client, connect to 127.0.0.1 with the username as "root" and the password you set when you installed MySQL.
Create 3 databases and name them:
(Not recommended but, if you have a limit at your provider on how many databases you can use all tables can be combined into one big database. Adjust the guide accordingly.)
Importing logon and character databases
Open your arcemurootfolder\sql directory. In this you will find 3 files:
character_structure.sql logon_structure.sql world_structure.sql
After that, switch to your character database and import the character_structure.sql file. If you're using SQLyog or Navicat you can do this by right-clicking the newly-created database, and then selecting Execute Batch File. Repeat this step with the logon database and the logon_structure.sql file.
world_structure.sql is the database structure only and it is for people who want to build their own database project. It doesn't contain any data. It's better to follow the next step how to get a world database.
Getting a world database
The world database contains all data on things like NPCs, GameObjects, quests, gossips. For more documentation on the world database please visit: World Database
There are many different projects with different aims the most popular categories are:
- Blizzlike data that is similar or identical to the real thing.
- Funserver data created or made with insane, game breaking stats or values.
- ArcDB (dervied from Land of Elves)
GIT Repository: https://github.com/DarkAngel39/ArcDB
- Land Of Elves (LoE) World Database
(Calendar events and German localization tables included)
(5.2015 closed, because of inactivity of ArcEmu, recommend to use ArcDB
Creating your administrator account
Switch to your
logon database. Run the following query (replacing the values for login and password with your own):
INSERT INTO `accounts` (login, password, gm, flags, forceLanguage, banned) VALUES ('admin', 'admin', 'az', '24', 'enEN', '0');
A breakdown of this query for those that do not understand SQL:
- Username (login): admin
- Password: admin
- GM Level: az (for all commands)
- Expansion: All
- Banned: Not banned. (the field doesn't have a default value, so it's required)
After setting up the database correctly, you're now ready to move on to Server configuration.