Database content - Dawn-of-Light/DOLSharp GitHub Wiki

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

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".

db-4

[!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.

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.

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.