Empty Database

[reddogut]

How would I go about either obtaining or creating an 'empty' database.... Here is what I am thinking...

I want a database that has all of the zones and items, but no NPC's (Guards, mob's, merchants..... anything), no quests (I assume I could just remove all of the .pl files from the eqemu\quests folder).

Any ideas?

[Secrets]

Originally Posted by reddogut

How would I go about either obtaining or creating an 'empty' database.... Here is what I am thinking...

I want a database that has all of the zones and items, but no NPC's (Guards, mob's, merchants..... anything), no quests (I assume I could just remove all of the .pl files from the eqemu\quests folder).

Any ideas?

You can download Navicat and use the empty table tool on the respective tables. That is what I did with Edge. However, if you still want player pets to work, delete all NPC ids above 1000 if you are using a pre-spawned DB.

I am sure HeidiSQL and SQLyog also has a tool like this.

[Cripp]

use truncate table instead of empty table too btw. works better. (sets auto increments back to 0, etc..)

[mplayer254]

Above ways will work really well, I would also humbly suggest using Navicat/HeidiSQL to copy a fresh PEQ/AXClassic DB and switch between the two, really helps having the original DB to compare to. This will require you to change some configuration files to the correct DB each time you switch but I just made shortcuts for them on the desktop, easy to switch quickly.

[reddogut]

Originally Posted by Secrets

You can download Navicat and use the empty table tool on the respective tables. That is what I did with Edge. However, if you still want player pets to work, delete all NPC ids above 1000 if you are using a pre-spawned DB.

I am sure HeidiSQL and SQLyog also has a tool like this.

What are the respective tables?

[reddogut]

Originally Posted by Cripp

use truncate table instead of empty table too btw. works better. (sets auto increments back to 0, etc..)

Nevermind.... I figured it out.... Using Cripp's advice I truncated the spawn2, spawngroup and spawnentry tables..... ding... empty database just like I was looking for....

Thanks everyone!