How to remove all creature from the world

i want to remove every creature in the world , but i want them to stay in the DB without taking me like… 1 millions hours to open my server , if someone can make me a delete files or maybe juste explain me which DB to completly empty


Thank you /emoticons/default_smile.png

Well you can remove thair spawns; meaning you will have to delete enteries in “creature” table. You can do same for objects.

DELETE FROM creature; – This will delete all creatures from the world

DELETE FROM gameobject; – This will delete all gameobjects from world.

Great , thank you , i did a mistake , i deleted creature_template fail -.- x)

Well i upload back my sql into my db and i try , thank guys /emoticons/default_tongue.png

Wont that create a lot of DB errors from scripts and such?

I made this once, but I am not sure if it is enough / needed / working:

DELETE FROM creature_addon;
DELETE FROM creature_formations;
DELETE FROM game_event_creature;
DELETE FROM game_event_npcflag;
DELETE FROM game_event_npc_vendor;
DELETE FROM linked_respawn WHERE linkedType <> 2;
DELETE FROM smart_scripts WHERE EXISTS(SELECT 1 FROM creature b WHERE smart_scripts.entryorguid = -b.GUID) AND source_type = 0;
DELETE FROM creature;

Though it might have been that you just wanted to get rid of the spawns only or that was enough for you.

Its not like DB errors affect the server like that … and you can probably get the log to ignore them anyways.

Ok well i will try yours right now /emoticons/default_smile.png i send you a feedback in 5 min /emoticons/default_tongue.png

5 min has passed rofl /emoticons/default_biggrin.png ?