Query to wipe everything except login details

[Zirius]

hello! my server is currently on beta test we are doing fine and we are going for official launch. I just want to make sure which database should be truncated.

So basically, the only data that should remain is the login details of the players.

Other DBs like: Character, Storage, Guild, Guild storage, pet, account variables, player variables, NPC variables, etc, should be reset.

I have a copy of database and is using it in my localhost anyway so I can test.

I am planning to truncate each DB one by one, but I'm afraid I might miss something.

Can somebody please help me with this?

Thanks!

 

[Samuel]

Just make sure to backup login table then you could delete everything, then just re-run the main.sql then copy the insert from your backup and run it