Resetting everything but Character and their levels.

[ryuseikai]

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]

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

 

[ryuseikai]

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.