Jump to content

CleanCharacterDB


Guest ilija

Recommended Posts

Sometimes, due to server crashes or when updating the database to newer server revisions, "trash" data can be left behind. This can include old spells, items, and pets that are no longer used or have changed IDs, instances that did not reset correctly, mail that was not properly deleted, and so forth.

These "Character Cleaning" SQL scripts attempt to find and remove this old data. Having an accurate, up to date database is important to prevent crashes and "bugged" characters that may become unplayable due to faults in their data. Be careful which cleaning script you choose. Make sure it is for your server and database version, plus check that it uses proper procedures like creating backups in case an error is made and data needs to be restored as well as using IF EXISTS with DELETE and INSERT instead of simply using REPLACE INTO when modifying tables.

To be safe, always make sure you run your own backup of any tables before modifying or cleaning them with any scripts or queries.

Link to comment
Share on other sites

Sometimes, due to server crashes or when updating the database to newer server revisions, "trash" data can be left behind. This can include old spells, items, and pets that are no longer used or have changed IDs, instances that did not reset correctly, mail that was not properly deleted, and so forth.

These "Character Cleaning" SQL scripts attempt to find and remove this old data. Having an accurate, up to date database is important to prevent crashes and "bugged" characters that may become unplayable due to faults in their data. Be careful which cleaning script you choose. Make sure it is for your server and database version, plus check that it uses proper procedures like creating backups in case an error is made and data needs to be restored as well as using IF EXISTS with DELETE and INSERT instead of simply using REPLACE INTO when modifying tables.

To be safe, always make sure you run your own backup of any tables before modifying or cleaning them with any scripts or queries.

I think they are referring to:

http://github.com/mangos/mangos/commit/1d1ec20a02eccb9fb3fd43156146f7e71b482c19

Link to comment
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use