Database content

Now that the database is created, we need to fill it with content data. The public DB from Eve-of-Darkness github will be the golden source for that.

On Windows 10

Go into the Eve-of-Darkness/public-db github repo.

Check the latest release defined for this repo and download the file named "public-db.mysql.sql.7z"

Extract this archive in a dedicated directory.

A file named "public-db.mysql.sql" should be created in this folder once the extraction is completed.

Open HeidiSQL and connect to your DOL database.

In the file menu, select "Execute an SQL file" and indicate the sql file "public-db.mysql.sql".

Note

After a few minutes, your database is populated with all the data for NPC, items, spells, etc which are used by the DOL server.

On Linux

To populate the database, you need first to go into the Eve-of-Darkness/public-db github repo.

Check the latest release defined for this repo and download the file named "public-db.mysql.sql.7z"

Extract this archive in a dedicated directory : 7z x public-db.mysql.sql.7z

A file named "public-db.mysql.sql" should be created in this folder once the extraction is completed.

Populate the "dol" database with this file :

mysql -u root -p -b dol < ./public-db.mysql.sql

Note

After a few minutes, your database is populated with all the data for NPC, items, spells, etc which are used by the DOL server.

On MacOS

To populate the database, you need first to go into the Eve-of-Darkness/public-db github repo.

Check the latest release defined for this repo and download the file named "public-db.mysql.sql.7z"

Extract this archive in a dedicated directory : 7z x public-db.mysql.sql.7z

A file named "public-db.mysql.sql" should be created in this folder once the extraction is completed.

Populate the "dol" database with this file :

sudo mysql -u root -p -b dol < ./public-db.mysql.sql

Note

After a few minutes, your database is populated with all the data for NPC, items, spells, etc which are used by the DOL server.