How to Perform Database Repairs
m (→What is the "Trainz Database"?) |
|||
(40 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
− | This guide will take you through the process of performing manual database repairs and clean database installs. | + | The information in this Wiki Page applies to '''TANE''', '''TRS19''', '''Trainz Plus''' and '''TRS22'''.<br> |
+ | |||
+ | This guide will take you through the process of performing manual database repairs and clean database installs. '''Trainz''' will automatically perform database repairs when it detects corruption in the Trainz database but sometimes a manual repair or even a manual clean install of the database is required. | ||
+ | |||
+ | __TOC__ | ||
+ | <table> <!-- BEGIN Nav Buttons Table --> | ||
+ | <tr valign="top"> | ||
+ | <td width=729><span id="stepWhat"></span> </td> | ||
+ | <td width=46>[[file:BackToTop.png|link=#top|alt=Top|Top]]</td> | ||
+ | <td width=75> </td> | ||
+ | <td width=75>[[file:NextDown.png|link=#stepWhy|alt=Next Down|Next Down]]</td> | ||
+ | <td width=75>[[file:BackToBottom.png|link=#bottom|alt=Bottom|Bottom]]</td> | ||
+ | </tr> | ||
+ | </table> <!-- END Nav Buttons Table --> | ||
='''What is the "Trainz Database"?'''= | ='''What is the "Trainz Database"?'''= | ||
− | <table cellpadding= | + | <table cellpadding=4 bgcolor=#c1e7e7> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:DotPoint.JPG]]</td> | + | <td>[[file:DotPoint.JPG|link=]]</td> |
<td>The '''Trainz Database''' contains all the installed assets</td> | <td>The '''Trainz Database''' contains all the installed assets</td> | ||
</tr> | </tr> | ||
Line 19: | Line 32: | ||
<tr> | <tr> | ||
<td> | <td> | ||
− | [[file:DBR_EDBR20.png]] | + | [[file:DBR_EDBR20.png|link=]] |
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
<br> | <br> | ||
− | + | <table> <!-- BEGIN Nav Buttons Table --> | |
+ | <tr valign="top"> | ||
+ | <td width=729><span id="stepWhy"></span> </td> | ||
+ | <td width=46>[[file:BackToTop.png|link=#top|alt=Top|Top]]</td> | ||
+ | <td width=75>[[file:NextUp.png|link=#stepWhat|alt=Next Up|Next Up]]</td> | ||
+ | <td width=75>[[file:NextDown.png|link=#stepHow|alt=Next Down|Next Down]]</td> | ||
+ | <td width=75>[[file:BackToBottom.png|link=#bottom|alt=Bottom|Bottom]]</td> | ||
+ | </tr> | ||
+ | </table> <!-- END Nav Buttons Table --> | ||
+ | ='''Why Would a Database Repair (DBR) Be Needed?'''= | ||
+ | |||
+ | '''Quote from N3V''' | ||
+ | <table> | ||
+ | <tr valign="top"> | ||
+ | <td> </td> | ||
+ | <td>"In terms of DB repairs, it should only be necessary if the program is updated or crashes. My understanding of the additional repairs are for things that are done outside the program function [i.e. outside of '''Content Manager''' and '''Surveyor'''] (like manually adding content into the local data folder) so in that case the db repair 'discovers' the new content".</td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | |||
+ | When '''Trainz''' is operating there is a great deal of database activity going on with records being opened and closed, and data being read and written. Corruption of the data is always possible, particularly if the power supply is interrupted or the program is suddenly terminated (a "crash") while records are open or being written. For this reason, '''Content Manager''' comes equipped with automatic and manual database repair tools. | ||
<br> | <br> | ||
+ | <table bgcolor=#000000 width=900> | ||
+ | <tr valign="top"> | ||
+ | <td> | ||
+ | <table bgcolor=#ffffe0 width=896> | ||
+ | <tr valign="top"> | ||
+ | <td>[[file:PencilTips.PNG|link=]]</td> | ||
+ | <td>A common, but not exclusive, cause of database problems and even CTDs (crashes to desktop) may be your Antivirus program. Each time Trainz accesses the database your AV program may be performing a scan of the database.<br><br> | ||
+ | Adding '''TANE.exe''', '''TRS19.exe''' and '''TRS22.exe''' to your AV programs '''real time scan''' exclusion list can potentially resolve many of these issues by preventing the AV from accessing the Trainz database. | ||
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | <br> | ||
+ | <table> <!-- BEGIN Nav Buttons Table --> | ||
+ | <tr valign="top"> | ||
+ | <td width=729><span id="stepHow"></span> </td> | ||
+ | <td width=46>[[file:BackToTop.png|link=#top|alt=Top|Top]]</td> | ||
+ | <td width=75>[[file:NextUp.png|link=#stepWhy|alt=Next Up|Next Up]]</td> | ||
+ | <td width=75>[[file:NextDown.png|link=#stepEDBR|alt=Next Down|Next Down]]</td> | ||
+ | <td width=75>[[file:BackToBottom.png|link=#bottom|alt=Bottom|Bottom]]</td> | ||
+ | </tr> | ||
+ | </table> <!-- END Nav Buttons Table --> | ||
='''How to Perform a Database Repair (a DBR)'''= | ='''How to Perform a Database Repair (a DBR)'''= | ||
− | <table cellpadding= | + | <table cellpadding=4 bgcolor=#c1e7e7> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:DotPoint.JPG]]</td> | + | <td>[[file:DotPoint.JPG|link=]]</td> |
<td>A '''DBR''' performs a "surface scan" of the database detecting missing content and content errors. It will update your database and can clean up some corrupted data.</td> | <td>A '''DBR''' performs a "surface scan" of the database detecting missing content and content errors. It will update your database and can clean up some corrupted data.</td> | ||
</tr> | </tr> | ||
Line 38: | Line 94: | ||
This is the simplest and (usually) the fastest option.<br> | This is the simplest and (usually) the fastest option.<br> | ||
− | <table | + | <table bgcolor=#000000 width=900> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:NotePad.PNG]]</td> | + | <td> |
− | <td><font size | + | <table bgcolor=#ffffb0 width=896> |
+ | <tr valign="top"> | ||
+ | <td>[[file:NotePad.PNG|link=]]</td> | ||
+ | <td><span style="font-size: 17px;">'''Notes:'''</span><br> | ||
+ | ---- | ||
Perform a '''DBR''' if you have:- | Perform a '''DBR''' if you have:- | ||
*'''unexpected problems''' with missing content | *'''unexpected problems''' with missing content | ||
Line 48: | Line 108: | ||
</td> | </td> | ||
</tr> | </tr> | ||
− | |||
− | |||
− | |||
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file: | + | <td colspan=2> |
− | <td>If you have installed a new asset that | + | <table bgcolor=#ffffe0> |
+ | <tr valign="top"> | ||
+ | <td>[[file:PencilTips.PNG|link=]]</td> | ||
+ | <td>If you have installed a new asset that '''Content Manager''' reports has having '''missing''' or '''unknown''' assets then a '''DBR''' is '''very unlikely''' to find those missing assets. | ||
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
<br> | <br> | ||
− | + | <table cellpadding=4 bgcolor=#ffffff> | |
− | <table cellpadding= | + | |
<tr valign="top"> | <tr valign="top"> | ||
<td colspan="2"> | <td colspan="2"> | ||
Line 64: | Line 130: | ||
</tr> | </tr> | ||
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:Steps.PNG]]</td> | + | <td>[[file:Steps.PNG|link=]]</td> |
− | <td><font size | + | <td><span style="font-size: 17px;">'''Steps:'''</span><br> |
− | <table cellpadding= | + | <table cellpadding=4 bgcolor=#ffffff> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:DBR_EDBR01.png]]</td> | + | <td>[[file:DBR_EDBR01.png|link=]]</td> |
− | <td>[[file:DBR_EDBR02.png]]</td> | + | <td>[[file:DBR_EDBR02.png|link=]]</td> |
</tr> | </tr> | ||
<tr valign="top"> | <tr valign="top"> | ||
Line 85: | Line 151: | ||
The process will proceed automatically and unaided through a number of steps, '''only some of which are shown below'''. The time required for each step will vary enormously (some will take much longer than others) and the total time involved will depend on the number of assets installed, the speed of your system and other factors.<br><br> | The process will proceed automatically and unaided through a number of steps, '''only some of which are shown below'''. The time required for each step will vary enormously (some will take much longer than others) and the total time involved will depend on the number of assets installed, the speed of your system and other factors.<br><br> | ||
1. '''Scanning for deleted asset files'''<br> | 1. '''Scanning for deleted asset files'''<br> | ||
− | [[file:DBR_EDBR03.png]]<br><br> | + | [[file:DBR_EDBR03.png|link=]]<br><br> |
2. '''Scanning for added asset files'''<br> | 2. '''Scanning for added asset files'''<br> | ||
− | [[file:DBR_EDBR04.png]]<br><br> | + | [[file:DBR_EDBR04.png|link=]]<br><br> |
3. '''Importing built in assets'''<br> | 3. '''Importing built in assets'''<br> | ||
− | [[file:DBR_EDBR06.png]]<br><br> | + | [[file:DBR_EDBR06.png|link=]]<br><br> |
4. '''Rebuilding cached asset data'''<br> | 4. '''Rebuilding cached asset data'''<br> | ||
− | [[file:DBR_EDBR07.png]]<br><br> | + | [[file:DBR_EDBR07.png|link=]]<br><br> |
− | The '''Rebuilding Trainz Asset | + | The '''Rebuilding Trainz Asset Database''' window will disappear if the DBR process has been successfully completed without finding any errors. If errors have been found then the window will remain on the screen to report on the number of errors and warnings.<br> |
<br> | <br> | ||
+ | <table> <!-- BEGIN Nav Buttons Table --> | ||
+ | <tr valign="top"> | ||
+ | <td width=729><span id="stepEDBR"></span> </td> | ||
+ | <td width=46>[[file:BackToTop.png|link=#top|alt=Top|Top]]</td> | ||
+ | <td width=75>[[file:NextUp.png|link=#stepHow|alt=Next Up|Next Up]]</td> | ||
+ | <td width=75>[[file:NextDown.png|link=#stepClean|alt=Next Down|Next Down]]</td> | ||
+ | <td width=75>[[file:BackToBottom.png|link=#bottom|alt=Bottom|Bottom]]</td> | ||
+ | </tr> | ||
+ | </table> <!-- END Nav Buttons Table --> | ||
='''How to Perform an Extended Database Repair (an EDBR)'''= | ='''How to Perform an Extended Database Repair (an EDBR)'''= | ||
− | <table cellpadding= | + | <table cellpadding=4 bgcolor=#c1e7e7> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:DotPoint.JPG]]</td> | + | <td>[[file:DotPoint.JPG|link=]]</td> |
<td>An '''EDBR''' performs a "deep scan" of the database and checks that the data in every asset conforms to the rules for that type of asset</td> | <td>An '''EDBR''' performs a "deep scan" of the database and checks that the data in every asset conforms to the rules for that type of asset</td> | ||
</tr> | </tr> | ||
Line 105: | Line 180: | ||
<br> | <br> | ||
− | <table | + | <table bgcolor=#000000 width=800> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:NotePad.PNG]]</td> | + | <td> |
− | <td><font size | + | <table bgcolor=#ffffb0 width=796> |
− | * | + | <tr valign="top"> |
− | *An EDBR puts every single asset in the database through the same error and compliance checks that are run when a new asset is installed | + | <td>[[file:NotePad.PNG|link=]]</td> |
+ | <td><span style="font-size: 17px;">'''Notes:'''</span><br> | ||
+ | ---- | ||
+ | *An '''EDBR''' is a more complex, slower and potentially more troublesome repair process | ||
+ | *An '''EDBR''' puts every single asset in the database through the same error and compliance checks that are run when a new asset is installed | ||
*Perform a '''EDBR''' if you have '''serious problems''' with your database that a DBR does not fix | *Perform a '''EDBR''' if you have '''serious problems''' with your database that a DBR does not fix | ||
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
− | + | </td> | |
− | <table | + | </tr> |
+ | </table> | ||
+ | <br> | ||
+ | <table bgcolor=#ff0000 width=800> | ||
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:Stop.PNG]]</td> | + | <td> |
− | <td>It is not unusual for | + | <table bgcolor=#fcbcbc> |
+ | <tr valign="top"> | ||
+ | <td>[[file:Stop.PNG|link=]]</td> | ||
+ | <td><span style="font-size: 15px; font-weight: 700;">CAUTION:</span><br> | ||
+ | It is not unusual for '''Content Manager''' to display a list of faulty assets '''after an EDBR''' that were not shown as faulty before the '''EDBR''' was run | ||
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
<br> | <br> | ||
− | <table cellpadding= | + | <table cellpadding=4 bgcolor=#ffffff> |
<tr valign="top"> | <tr valign="top"> | ||
<td colspan="2"> | <td colspan="2"> | ||
Line 129: | Line 219: | ||
</tr> | </tr> | ||
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:Steps.PNG]]</td> | + | <td>[[file:Steps.PNG|link=]]</td> |
− | <td><font size | + | <td><span style="font-size: 17px;">'''Steps:'''</span><br> |
− | <table cellpadding= | + | <table cellpadding=4 bgcolor=#ffffff> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:DBR_EDBR01.png]]</td> | + | <td>[[file:DBR_EDBR01.png|link=]]</td> |
− | <td>[[file:DBR_EDBR02.png]]</td> | + | <td>[[file:DBR_EDBR02.png|link=]]</td> |
</tr> | </tr> | ||
<tr valign="top"> | <tr valign="top"> | ||
Line 154: | Line 244: | ||
<tr> | <tr> | ||
<td> | <td> | ||
− | [[file:DBR_EDBR10.png]] | + | [[file:DBR_EDBR10.png|link=]] |
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
<br> | <br> | ||
+ | <table> <!-- BEGIN Nav Buttons Table --> | ||
+ | <tr valign="top"> | ||
+ | <td width=729><span id="stepClean"></span> </td> | ||
+ | <td width=46>[[file:BackToTop.png|link=#top|alt=Top|Top]]</td> | ||
+ | <td width=75>[[file:NextUp.png|link=#stepEDBR|alt=Next Up|Next Up]]</td> | ||
+ | <td width=75> </td> | ||
+ | <td width=75>[[file:BackToBottom.png|link=#bottom|alt=Bottom|Bottom]]</td> | ||
+ | </tr> | ||
+ | </table> <!-- END Nav Buttons Table --> | ||
='''How to Create a "Clean Database"'''= | ='''How to Create a "Clean Database"'''= | ||
− | <table cellpadding= | + | <table cellpadding=4 bgcolor=#c1e7e7> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:DotPoint.JPG]]</td> | + | <td>[[file:DotPoint.JPG|link=]]</td> |
<td>Creating a '''Clean Database''':- | <td>Creating a '''Clean Database''':- | ||
− | *will return your | + | *will return your '''Trainz''' database to its original, newly installed, condition |
*is usually performed when the Trainz Database contains faulty installed assets that are causing crashes and other major problems | *is usually performed when the Trainz Database contains faulty installed assets that are causing crashes and other major problems | ||
*does not destroy your original database</td> | *does not destroy your original database</td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
− | + | <br> | |
− | <table | + | <table bgcolor=#000000 width=900> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:NotePad.PNG]]</td> | + | <td> |
− | <td><font size | + | <table bgcolor=#ffffb0 width=896> |
− | This process will create a new Trainz database containing only the '''built in''' and '''base''' assets that came with the original Trainz | + | <tr valign="top"> |
+ | <td>[[file:NotePad.PNG|link=]]</td> | ||
+ | <td><span style="font-size: 17px;">'''Notes:'''</span><br> | ||
+ | ---- | ||
+ | This process will create a new Trainz database containing only the '''built in''' and '''base''' assets that came with the original Trainz installation (a "clean" database). Use this option if you want to remove from your Trainz install all:- | ||
*'''DLS''' assets | *'''DLS''' assets | ||
*'''DLC''' assets - these will have to be reinstalled if you want them back | *'''DLC''' assets - these will have to be reinstalled if you want them back | ||
*third party assets | *third party assets | ||
− | *assets you have created yourself (e.g. routes, sessions, etc) - but make sure that you have the original data files backed up somewhere</td> | + | *assets you have created yourself (e.g. routes, sessions, etc) - but make sure that you have the original data files backed up somewhere |
+ | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
− | + | </td> | |
− | + | ||
− | + | ||
− | + | ||
− | + | ||
</tr> | </tr> | ||
</table> | </table> | ||
+ | <br> | ||
+ | <table bgcolor=#ff0000 width=900> | ||
+ | <tr valign="top"> | ||
+ | <td> | ||
+ | <table bgcolor=#fcbcbc> | ||
+ | <tr valign="top"> | ||
+ | <td>[[file:Stop.PNG|link=]]</td> | ||
+ | <td>You will be creating '''another copy''' of the database but without any downloaded content. You will need enough space on your selected data drive to hold the data.<br> | ||
− | <table cellpadding= | + | Your original database will not be affected and will remain in its current location until you choose to delete, move or restore it. |
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | <br> | ||
+ | <table cellpadding=4 bgcolor=#ffffff> <!-- BEGIN Step table --> | ||
<tr> | <tr> | ||
<td colspan="2"> | <td colspan="2"> | ||
Line 197: | Line 313: | ||
</tr> | </tr> | ||
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:Steps.PNG]]</td> | + | <td>[[file:Steps.PNG|link=]]<br><br> |
− | <td><font size | + | <span style="font-size: 17px; font-weight: 700;">Steps</span></td> |
− | <table | + | <td>[[file:DotPoint1.JPG|link=]] <span style="font-size: 17px; font-weight: 700;">Create a Container:</span><br> |
+ | <table> <!-- BEGIN Step 1 table --> | ||
<tr valign="top"> | <tr valign="top"> | ||
− | |||
<td> | <td> | ||
#use '''Windows File Explorer''' to create a new folder on your data drive ('''D:''' if you have one, '''C:''' if you don't) | #use '''Windows File Explorer''' to create a new folder on your data drive ('''D:''' if you have one, '''C:''' if you don't) | ||
#give the folder a meaningful and easy to remember name such as '''TRS19_Clean_Database'''<br> | #give the folder a meaningful and easy to remember name such as '''TRS19_Clean_Database'''<br> | ||
</td> | </td> | ||
− | < | + | <td>[[file:DBR_EDBR30.png|link=]] |
− | + | </td> | |
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 213: | Line 329: | ||
----</td> | ----</td> | ||
</tr> | </tr> | ||
− | </table> | + | </table> <!-- END Step 1 table --> |
− | + | </td> | |
− | < | + | |
− | + | ||
− | + | ||
− | ----</td> | + | |
</tr> | </tr> | ||
<tr valign="top"> | <tr valign="top"> | ||
− | <td> | + | <td> </td> |
− | <td><font size | + | <td>[[file:DotPoint2.JPG|link=]] <span style="font-size: 17px; font-weight: 700;">In Trainz Launcher:</span><br> |
− | <table | + | <table> <!-- BEGIN Step 2 table --> |
− | <tr> | + | <tr valign="top"> |
<td> | <td> | ||
#click the '''Trainz Settings''' button | #click the '''Trainz Settings''' button | ||
Line 236: | Line 348: | ||
You will see a progress bar as the built in assets are copied across to the new folder. | You will see a progress bar as the built in assets are copied across to the new folder. | ||
</td> | </td> | ||
− | <td>[[file:DBR_EDBR31.png]] | + | <td>[[file:DBR_EDBR31.png|link=]] |
− | + | </td> | |
− | + | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
Line 244: | Line 355: | ||
----</td> | ----</td> | ||
</tr> | </tr> | ||
− | </table> | + | </table> <!-- END Step 2 table --> |
− | + | </td> | |
− | < | + | |
− | + | ||
− | + | ||
− | ----</td> | + | |
</tr> | </tr> | ||
<tr valign="top"> | <tr valign="top"> | ||
− | <td> | + | <td> </td> |
− | <td><font size | + | <td>[[file:DotPoint3.JPG|link=]] <span style="font-size: 17px; font-weight: 700;">Restart Trainz and Reconfigure Settings:</span><br> |
− | #restart | + | <table> <!-- BEGIN Step 3 table --> |
− | #open the '''Trainz Settings''' again and click the '''Internet''' tab | + | <tr valign="top"> |
+ | <td colspan=2> | ||
+ | #restart '''Trainz''' when you are prompted to do so | ||
+ | #open the '''Trainz Settings''' again and click the '''Internet''' tab. <span style="background-color: yellow;"> In '''TRS19 SP3''' and later the '''Internet''' tab has been renamed to '''MyTrainz''' </span> | ||
#delete and re-enter your username and password | #delete and re-enter your username and password | ||
− | #when your username/password have been accepted, restart | + | #when your username/password have been accepted, restart '''Trainz''' again |
#open the '''Trainz Settings''' again and click the '''General''' tab | #open the '''Trainz Settings''' again and click the '''General''' tab | ||
#adjust the settings to your preferred values | #adjust the settings to your preferred values | ||
#click the '''Performance''' tab and adjust the settings to your preferred values | #click the '''Performance''' tab and adjust the settings to your preferred values | ||
− | #exit '''Trainz Settings''' | + | #exit '''Trainz Settings'''. Depending on which settings you have changed, you may be prompted to restart '''Trainz''' again |
− | + | #click on '''Start Trainz''' | |
+ | In '''TANE''' you will be prompted to download any '''DLC''' assets that you may have previously purchased. You can install them now or delay their install until later.<br> | ||
+ | |||
+ | In '''TRS19/22''' the '''Content Store''', accessed from the '''Trainz Launcher''', will allow you to select and install any previously purchased '''DLC''' assets. | ||
</td> | </td> | ||
</tr> | </tr> | ||
Line 269: | Line 382: | ||
----</td> | ----</td> | ||
</tr> | </tr> | ||
− | </table> | + | </table> <!-- END Step 3 table --> |
+ | </td> | ||
+ | </tr> | ||
+ | </table> <!-- END Steps Table --> | ||
− | <table | + | <table bgcolor=#000000 width=600> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:NotePad.PNG]]</td> | + | <td> |
− | <td><font size | + | <table bgcolor=#ffffb0 width=596> |
+ | <tr valign="top"> | ||
+ | <td>[[file:NotePad.PNG|link=]]</td> | ||
+ | <td><span style="font-size: 17px;">'''Notes:'''</span><br> | ||
+ | ---- | ||
Your original database is still on your system at the location you recorded in '''Step 2''' above. You may choose to:- | Your original database is still on your system at the location you recorded in '''Step 2''' above. You may choose to:- | ||
*leave it there (it will take up many GBs of space) | *leave it there (it will take up many GBs of space) | ||
*archive or move it to offline storage | *archive or move it to offline storage | ||
*delete it | *delete it | ||
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
<br> | <br> | ||
− | + | <table> <!-- BEGIN Nav Buttons Table --> | |
+ | <tr valign="top"> | ||
+ | <td width=729><span id="bottom"></span> </td> | ||
+ | <td width=46>[[file:BackToTop.png|link=#top|alt=Top|Top]]</td> | ||
+ | <td width=75>[[file:NextUp.png|link=#stepClean|alt=Next Up|Next Up]]</td> | ||
+ | <td width=75> </td> | ||
+ | <td width=75> </td> | ||
+ | </tr> | ||
+ | </table> <!-- END Nav Buttons Table --> | ||
---- | ---- | ||
---- | ---- | ||
='''Trainz Wiki'''= | ='''Trainz Wiki'''= | ||
− | <table cellpadding= | + | <table cellpadding=4 bgcolor=#ffffff> |
<tr valign="top"> | <tr valign="top"> | ||
− | <td>[[file:TrainzWiki.png]]</td> | + | <td>[[file:TrainzWiki.png|link=]]</td> |
<td> | <td> | ||
− | <font size | + | <span style="font-size: 17px;">'''More Tutorials and Guides to Using Trainz'''</span><br> |
*'''<span class="plainlinks">[http://online.ts2009.com/mediaWiki/index.php/HowTo How to Guides]</span>''' | *'''<span class="plainlinks">[http://online.ts2009.com/mediaWiki/index.php/HowTo How to Guides]</span>''' | ||
*'''[[Driver Commands List]]''' | *'''[[Driver Commands List]]''' | ||
Line 300: | Line 431: | ||
</tr> | </tr> | ||
</table> | </table> | ||
− | + | ---- | |
+ | This page was created by Trainz user '''<span class="plainlinks">[http://online.ts2009.com/mediaWiki/index.php/User:Pware pware]</span>''' in January 2019 and was last updated as shown below. | ||
+ | ---- | ||
[[Category:How-to guides]] | [[Category:How-to guides]] |
Revision as of 10:38, 19 June 2022
The information in this Wiki Page applies to TANE, TRS19, Trainz Plus and TRS22.
This guide will take you through the process of performing manual database repairs and clean database installs. Trainz will automatically perform database repairs when it detects corruption in the Trainz database but sometimes a manual repair or even a manual clean install of the database is required.
Contents |
What is the "Trainz Database"?
The Trainz Database contains all the installed assets |
In the earliest Trainz versions all the assets that came installed with Trainz, or that you installed from the DLS or downloaded as .cdp files, were stored as separate folders on your designated data drive. This made it easy to access the assets for editing and other operations. However the penalty was that each time you started Trainz it had to scan the assets to check their integrity and the more assets you had the longer the startup took. This led to a great many complaints from users.
Today, all installed Trainz assets are added as records in an asset database which has significantly sped up the startup process and has reduced the possibility of accidental data corruption by users. The penalty is that users can no longer access the installed assets by using Windows Explorer. Access to the assets in the database for editing and examination is through the Content Manager program.
Because it is a database manager, Content Manager also provides users with many more search, display and management options than were ever previously possible. Each entry in the display shown below is a single record in the Trainz database. Each entry can be easily opened for editing, it can be deleted, copied (cloned) and updated. New assets can be manually created or installed from other sources.
|
Why Would a Database Repair (DBR) Be Needed?
Quote from N3V
"In terms of DB repairs, it should only be necessary if the program is updated or crashes. My understanding of the additional repairs are for things that are done outside the program function [i.e. outside of Content Manager and Surveyor] (like manually adding content into the local data folder) so in that case the db repair 'discovers' the new content". |
When Trainz is operating there is a great deal of database activity going on with records being opened and closed, and data being read and written. Corruption of the data is always possible, particularly if the power supply is interrupted or the program is suddenly terminated (a "crash") while records are open or being written. For this reason, Content Manager comes equipped with automatic and manual database repair tools.
|
How to Perform a Database Repair (a DBR)
A DBR performs a "surface scan" of the database detecting missing content and content errors. It will update your database and can clean up some corrupted data. |
This is the simplest and (usually) the fastest option.
|
|
|||||
Steps:
|
|||||
|
The process will proceed automatically and unaided through a number of steps, only some of which are shown below. The time required for each step will vary enormously (some will take much longer than others) and the total time involved will depend on the number of assets installed, the speed of your system and other factors.
1. Scanning for deleted asset files
2. Scanning for added asset files
3. Importing built in assets
4. Rebuilding cached asset data
The Rebuilding Trainz Asset Database window will disappear if the DBR process has been successfully completed without finding any errors. If errors have been found then the window will remain on the screen to report on the number of errors and warnings.
How to Perform an Extended Database Repair (an EDBR)
An EDBR performs a "deep scan" of the database and checks that the data in every asset conforms to the rules for that type of asset |
|
|
|
|||||
Steps:
|
|||||
|
A possible result of an EDBR.
|
How to Create a "Clean Database"
Creating a Clean Database:-
|
|
|
|
|||||
Steps |
Create a Container:
|
||||
In Trainz Launcher:
|
|||||
Restart Trainz and Reconfigure Settings:
|
|
Trainz Wiki
More Tutorials and Guides to Using Trainz |
This page was created by Trainz user pware in January 2019 and was last updated as shown below.