Wipe out?

[aerolite]

Hi! I really need to wipe out my server just all the character + items without accounts. How could I do that? which tables should I empty?

Thank you in advance!

[NickoNiklas]

Easiest way (bot not always the correct one),

is to drop the characters database (and recreate it from an empty database structure),

and then set realmcharacters.numchars in the realmd database to 0 for all accounts.

[aerolite]

I did this and got a problem in re-updating my database.

SQL: SELECT required_10148_01_mangos_mangos_string FROM db_version LIMIT 1

query ERROR: Unknown column 'required_10148_01_mangos_mangos_string' in 'field list'

[0 ms] SQL: SELECT * FROM db_version LIMIT 1

The table `db_version` in your [WORLD] database indicates that this database is out of date!

[A] You have: --> `10314_02_mangos_command.sql`

You need: --> `10148_01_mangos_mangos_string.sql`

You must apply all updates after [A] to to use mangos with this database.

These updates are included in the sql/updates folder.

Please read the included [README] in sql/updates for instructions on updating.

[0 ms] SQL: SET NAMES `utf8`

[0 ms] SQL: SET CHARACTER SET `utf8`

[A] You have: --> `10314_02_mangos_command.sql`

You need: --> `10148_01_mangos_mangos_string.sql`

it wants me to go back into 10148? please help I really have no idea whats going on.

[Patman128]

Recompile/reinstall mangos?