Ahoy everyone,
Here comes another weird question out of the blue which again shouldn't be that difficult to answer. I'm pretty sure others have the same question but ow well, here goes.. I'm just wondering
What tables can/should I wipe in SQL if I want a completely reset of the server?
Please if you're gonna reply, include ALL the tables that can/should be wiped for a clean start or else don't bother writing into this post. Thanks for your concern, have a good day.
Regards,
Alex
.______.
^ lol she mad
Why don't you just delete current databases and replace them with new ones?
she?....
@Sir Versa I'm actually quite serious in this thread. Like I mentioned in my other thread, I'm a perfectionist and I'll go ballistic if I don't do this perfectly.
So please if you're going to post in this thread, make it worth it. I have nothing against you.
Go back to copying everything someone else does.Originally Posted by Nutello
@Lunerica I have the Odin databases, It's just I wanna be certain I don't wipe something like the tGuildAcademyRewardType table which rows must NOT be wiped.
Who? You?
Google is your friend.
SQL server - delete rows where multiple columns have either null or zero value - Stack Overflow
something like that may help you.
@Nutello - I apologize, I got bored.
That's not quite what I mean.. xd
For example, do you have installed SQL? It's ok and normal to wipe the w00_Character..tFriend but I'd like you to check the table w00_Character..tGuildTournament
Is it ok to wipe that one? It looks to me like it stores needed data for the game to function.
Just delete the whole databases and restore a new ones and re-do the other tables. Not much work, you know ;p
So they're fully wiped and clean? I'm very picky.. xD
EDIT: I wiped everything I was sure was OK to wipe with 2 exceptions.
w00_Character..tGuildTournament
StatisticsData..tSameTimeChar (I think this one is fine to wipe, not fully sure tho.)
Last edited by Alsm97; 24-05-13 at 07:17 PM.
Reply With Quote