The files in the updates folder will update all of your character tables without losing any toon data. You want to source in every update in that folder in order, from the last time you updated. If you have a db_version table in your database, that will tell you which version you are running. Just source in all updates after that point. If you do not have that table, then you'll need to compare the EQEmu changelog and what your database schema looks like with the updates files to see which you need to source. If it's really old, (before the EQEmu code moved to SVN) then you will need to source them all.
The actual content of the database is simple. Source drop_system.sql, and then source the file contained within the .gz file. Of course, this will destroy any custom content you have added to the server. The best way to keep that intact is to maintain a sql of all your changes, and source that back in after you've updated the content part of the DB.
|