Log in

View Full Version : Empty Database

reddogut
04-03-2009, 06:08 PM
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
04-04-2009, 02:50 AM
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
04-04-2009, 12:28 PM
use truncate table instead of empty table too btw. works better. (sets auto increments back to 0, etc..)
mplayer254
04-04-2009, 02:18 PM
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
04-04-2009, 04:01 PM
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
04-04-2009, 05:01 PM
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!