Resetting everything but Character and their levels.

[ryuseikai 0]

I was conducting mock server wipe but i end up destroying my database. After searching for solution for sometime, it turns out diff people have diff request not specifically to mine.

 

So is there anyway to delete/reset database without touching the players character and their levels/job levels?

 

I don't feel like destroying my sql again so... can some devs shed some light on this?

[Dastgir 1246]

TRUNCATE every table except `login` and `char` (but, will delete inventory,guilds,storage, and all other things..)

[ryuseikai 0]

Thank you! It works! although it scares me abit that when its truncating, it takes too long and the workbench seems like not responding. I have to kill-process and restart workbench again to see the end results.

 

Thanks again.