EQEmulator Forums - sql woes, goodbye crushbone!

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)

- - sql woes, goodbye crushbone! (https://www.eqemulator.org/forums/showthread.php?t=35236)

LordAdakos

04-23-2012 01:03 PM

sql woes, goodbye crushbone!

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?

Code:

copy from peqbackup62.npc_spawn

to peq.npc_spawn

where ID >=1;

Cilraaz

04-23-2012 02:22 PM

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

Code:

INSERT INTO peq.npc_spawn

SELECT * FROM peqbackup62.npc_spawn

WHERE ID > 0;

All times are GMT -4. The time now is 03:44 AM.