[ArcEmu] Accidental Database Deletion

[VisionImp]

First off, I'd like to apologize if this is a repost or wrongly tagged, this is my very first post here.. And sadly, it's a nub post.

While attempting to make instances 'public', per say, I found a guide that told me just that. Great, isn't it? Well, the lovely person who made the guide decided to use Alterac Valley as an example, and left out a tidbit about areatriggers being instance entrances, etc. Me being completely new to all of this(my server's been up for maybe a week or so, no 'programming' or any experience before this), I was following the guide and made necessary changes, then started to delete areatriggers. Luckily, before deleting both rows, I stopped and realized that it names the entrances of the instance. Which led me to a near panic attack, and of course, confirmed my fears.

Now, onto the real reason for this thread: I'm wondering is there any way to get that data back, or anywhere I could search for that information back to remake the row and hopefully have the instance entrance working again. Or do I.. need to make an entire new server for a fresh database or something?

Again, sorry for nubness.. :/ And many thanks to any responses and help. Thank you, in advance.

[Kiev]

This isn't your own fault, its the guide at fault, so dont apologize for that.

Unless you backup regulary, its not possible to get the data back that way, but you can get the Database you used before (This is unless your using a repack), and drop the Area Triggers table and re execute it into your old database.

[VisionImp]

I am indeed using a repack.. ._.;; So the data is lost? I guess there would be nowhere someone may have compiled lists of that kind of data and such?

Either way, thank you. I only realized just now that there was the backup thing..>< If anything, I can make a portal into the instance, but didn't want to have to do that, but if it must be done then so be it.

Again, thank you for the help.

[Kiev]

Its not lost, but being able to get it back will require you to reinstall the repack, or atleast extract the MySQL info.

Im not sure on a list being around but im sure someone has made one somwhere, so i would take a look around for that.

[stoneharry]

What data is it that you need? Just the areatriggers for ArcEmu or...? I can get you back some data from my own database by dumping it for you if needed, which should solve your problem. In future always make backups, I make daily backups of my project which I store on external Hard drives so that I do not loose months of work.

[VisionImp]

Oh it's just a single row! The main entrance to the Gnomeregan instance. Not the back entrance that requires the key to unlock the door, just that one front instance. And yeah, I never even saw the backup thing until now, as I've been kinda switching between HeidiSQL and Navicat(semi-long story ._.) but if you could just get me that one row, I'd be incredibly grateful!

[stoneharry]

insert into `areatriggers` (`entry`, `type`, `map`, `screen`, `name`, `position_x`, `position_y`, `position_z`, `orientation`, `required_honor_rank`, `required_level`) values('1104','0','0','0','Gnomeregan - Dun Morogh entrance','0','0','0','0','0','1');
insert into `areatriggers` (`entry`, `type`, `map`, `screen`, `name`, `position_x`, `position_y`, `position_z`, `orientation`, `required_honor_rank`, `required_level`) values('1105','0','0','0','Gnomeregan - Dun Morogh istance','0','0','0','0','0','15');
insert into `areatriggers` (`entry`, `type`, `map`, `screen`, `name`, `position_x`, `position_y`, `position_z`, `orientation`, `required_honor_rank`, `required_level`) values('324','1','90','90','Gnomeregan Entrance','-332.22','-2.28','-150.86','2.77','0','15');
insert into `areatriggers` (`entry`, `type`, `map`, `screen`, `name`, `position_x`, `position_y`, `position_z`, `orientation`, `required_honor_rank`, `required_level`) values('322','1','0','0','Gnomeregan Istance Start','-5163.33','927.623','257.188','0','0','1');
insert into `areatriggers` (`entry`, `type`, `map`, `screen`, `name`, `position_x`, `position_y`, `position_z`, `orientation`, `required_honor_rank`, `required_level`) values('523','1','90','90','Gnomeregan Train Depot Entrance','-736.51','2.71','-249.99','3.14','0','15');
insert into `areatriggers` (`entry`, `type`, `map`, `screen`, `name`, `position_x`, `position_y`, `position_z`, `orientation`, `required_honor_rank`, `required_level`) values('525','1','0','0','Gnomeregan Train Fepot Istance','-4858.27','756.435','244.923','0','0','1');

Those are all my areatriggers for Gnomeregan, just execute them all if your not sure which one it is.

[VisionImp]

Thank you very, very muchly! I was really frustrated with it, since the Gnomeregan instance is going to be used a lot and all on my server and just felt really stupid about it.

+Rep, and I'd give more if I could. :B And thank you to Kiev, as well!

[Kiev]

Thats fine Always useful to use that backup feature every few days/weeks if you feel safe without backing up in a while.