...
- Browse into your ...\sql\updates\world folder and import all*_world_*.sql files into your world DB that have a date later than your previous revision.
- Do the same above step for the characters and auth folders, if they exist. If these folders don't exist, there have not been any characters or auth database updates.
| Sugerencia | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
Note: If you are comfortable with executing batch files, you are welcome to use the batch file below to make the importing process easier. Also note that doing this will also gather up .sql files you may have already imported. In most cases this is safe, but you should use this batch file at your own risk. Take a look on the Combine SQL Updates thread in the TrinityCore forum for a more detailed batch script and informations. If you don't change the batch script, it must be saved and executed in your ...\sql\updates folder.
If you still have problems, read http://www.trinitycore.org/f/topic/328-unknown-column-missing-table-duplicate-column-error-sql-problems-sqldriverlogfile-answer-on-1st-post-of-1st-page/ |
...
| Sugerencia | ||
|---|---|---|
| ||
If your world database is ever corrupted (ex. creatures or objects are accidentally deleted), it is easy to revert it back to its original state by re-importing the TDB_FULL.sql into your world database. If you updated your core using the (Advanced) instructions, make sure you also re-import all of the necessary C:\Trinity\sql\updates as explained above. |
...