Delete all characters without deleting any account

[steemadafaka]

Hi there, can someone tell me if there is some way to delete only all characters from my data base and leave only the accounts? I'm runnig on TrinityCore2 3.3.5 :confused:

[steemadafaka]

Please I need this answer as soon as possible.. ! Please :?

[diviee3]

umm yea? just delete all the entrys from character table, or run a query to delete them all at once.

[predattak]

open the database with any program ..navicat heidi etc .. open the character database open the table characters and u will see all the characters from all the accounts there .. delete them all and ure done

[steemadafaka]

I did as you told me, I mark all the characters in table SQLyog > Characters > Characters and delete them. But now when I try to make a character nothing happens, I saw something strange.. If I make character with new name (i mean name what was non existing before deleting all characters in the char table) I see him and I can play with him.. but if the name was used before I cant even see my character

---------- Post added at 10:27 AM ---------- Previous post was at 10:25 AM ----------

EDIT: If the class is the same as before nothing happens, If I make same name but other class I can see my char.

[steemadafaka]

Please... guys...

[Saridormi]

That's because you only deleted the contents of 1 table. If you're wanting to wipe characters just drop and re-import the character database.