sql woes, goodbye crushbone!

[LordAdakos]

So somehow removed crushbone's npc's. All of them.

Good news is that I have a back up!

However, I've never done a back up for just one zone, would anyone be able to explain the proper procedure for restoring just specific tables, instead of a full SQL dump ?


Im running on database 'peq' and my backup is titled 'peqbackup62'

Something like this perhaps?

copy from peqbackup62.npc_spawn
to peq.npc_spawn
where ID >=1;

[Cilraaz]

Personally, I don't even have an npc_spawn table, but you'd likely want to do something more like:

INSERT INTO peq.npc_spawn
SELECT * FROM peqbackup62.npc_spawn
WHERE ID > 0;