How to Perform Database Repairs

From TrainzOnline
(Difference between revisions)
Jump to: navigation, search
m
Line 1: Line 1:
−
The information in this Wiki Page applies to '''TANE''', '''TRS19''', '''Trainz Plus''' and '''TRS22'''.<br>
+
<table width=1000>
 +
<tr valign="top">
 +
<td>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.
+
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.</td>
 +
</tr>
 +
</table>
  
 
__TOC__
 
__TOC__
−
<table> <!-- BEGIN Nav Buttons Table -->
+
<table width=1000> <!-- BEGIN Nav Buttons Table -->
 
<tr valign="top">
 
<tr valign="top">
 
<td width=729><span id="stepWhat"></span>&nbsp;</td>
 
<td width=729><span id="stepWhat"></span>&nbsp;</td>
Line 16: Line 20:
 
='''What is the "Trainz Database"?'''=
 
='''What is the "Trainz Database"?'''=
  
−
<table cellpadding=4 bgcolor=#c1e7e7>
+
<table width=1000 bgcolor="lightcyan" cellpadding=2>
 
<tr valign="top">
 
<tr valign="top">
−
<td>[[file:DotPoint.JPG|link=]]</td>
+
<td width=10>[[image:BlueDot10x10.png|link=]]</td>
 
<td>The '''Trainz Database''' contains all the installed assets</td>
 
<td>The '''Trainz Database''' contains all the installed assets</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
−
<br>
+
 
−
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.
+
<table width=1000>
 +
<tr valign="top">
 +
<td>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.
 
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.
+
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.</td>
 +
</tr>
 +
</table>
 
<br>
 
<br>
−
<table width=100%>
+
<table width=1000>
 
<tr>
 
<tr>
−
<td>
+
<td>[[file:DBR_EDBR20.png|link=]]</td>
−
[[file:DBR_EDBR20.png|link=]]
+
−
</td>
+
 
</tr>
 
</tr>
 
</table>
 
</table>
 
<br>
 
<br>
−
<table> <!-- BEGIN Nav Buttons Table -->
+
<table width=1000> <!-- BEGIN Nav Buttons Table -->
 
<tr valign="top">
 
<tr valign="top">
 
<td width=729><span id="stepWhy"></span>&nbsp;</td>
 
<td width=729><span id="stepWhy"></span>&nbsp;</td>
Line 48: Line 54:
 
='''Why Would a Database Repair (DBR) Be Needed?'''=
 
='''Why Would a Database Repair (DBR) Be Needed?'''=
  
−
'''Quote from N3V'''
+
<span style="font-weight: 700; font-size: 15px;">A Quote from N3V</span>
−
<table>
+
 
 +
<table width=1000>
 
<tr valign="top">
 
<tr valign="top">
 
<td>&nbsp;&nbsp;&nbsp;&nbsp;</td>
 
<td>&nbsp;&nbsp;&nbsp;&nbsp;</td>
Line 56: Line 63:
 
</table>
 
</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.
+
<table width=1000>
 +
<tr valign="top">
 +
<td>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.</td>
 +
</tr>
 +
</table>
 
<br>
 
<br>
−
<table bgcolor=#000000 width=900>
+
<table width=1000 bgcolor=#000000>
 
<tr valign="top">
 
<tr valign="top">
 
<td>
 
<td>
−
<table bgcolor=#ffffe0 width=896>
+
<table bgcolor=#ffffe0>
 
<tr valign="top">
 
<tr valign="top">
 
<td>[[file:PencilTips.PNG|link=]]</td>
 
<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>
+
<td>A common, but not exclusive, cause of database problems and even '''CTD'''s (crashes to desktop) may be your antivirus program. Everytime '''Trainz''' accesses the database your AV program may perform 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 database.
−
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>
 
</td>
 
</tr>
 
</tr>
Line 74: Line 84:
 
</table>
 
</table>
 
<br>
 
<br>
−
<table> <!-- BEGIN Nav Buttons Table -->
+
<table width=1000> <!-- BEGIN Nav Buttons Table -->
 
<tr valign="top">
 
<tr valign="top">
 
<td width=729><span id="stepHow"></span>&nbsp;</td>
 
<td width=729><span id="stepHow"></span>&nbsp;</td>
Line 85: Line 95:
 
='''How to Perform a Database Repair (a DBR)'''=
 
='''How to Perform a Database Repair (a DBR)'''=
  
−
<table cellpadding=4 bgcolor=#c1e7e7>
+
<table width=1000 bgcolor="lightcyan" cellpadding=2>
 
<tr valign="top">
 
<tr valign="top">
−
<td>[[file:DotPoint.JPG|link=]]</td>
+
<td width=10>[[image:BlueDot10x10.png|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 94: Line 104:
 
This is the simplest and (usually) the fastest option.<br>
 
This is the simplest and (usually) the fastest option.<br>
  
−
<table bgcolor=#000000 width=900>
+
<table bgcolor=#000000>
 
<tr valign="top">
 
<tr valign="top">
 
<td>
 
<td>
−
<table bgcolor=#ffffb0 width=896>
+
<table bgcolor=#ffffb0>
 
<tr valign="top">
 
<tr valign="top">
 
<td>[[file:NotePad.PNG|link=]]</td>
 
<td>[[file:NotePad.PNG|link=]]</td>
Line 103: Line 113:
 
----
 
----
 
Perform a '''DBR''' if you have:-
 
Perform a '''DBR''' if you have:-
−
*'''unexpected problems''' with missing content
+
<table>
−
*content errors with installed assets (particularly if those assets did not previously show any problems)
+
<tr valign="top">
−
A DBR process updates your database, revalidates the content and can often clear up any corruption that has occurred.
+
<td width=10>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>'''unexpected problems''' with missing content</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>content '''errors with installed assets''' (particularly if those assets did not previously show any problems)</td>
 +
</tr>
 +
<tr valign="top">
 +
<td colspan=2>A '''DBR''' updates your database, revalidates the content and can often clear up any corruption that has occurred.</td>
 +
</tr>
 +
</table>
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 124: Line 144:
 
</table>
 
</table>
 
<br>
 
<br>
−
<table cellpadding=4 bgcolor=#ffffff>
+
<table width=1000>
 
<tr valign="top">
 
<tr valign="top">
−
<td colspan="2">
+
<td colspan=2><span style="font-weight: 700; font-size: 17px;">Steps:</span></td>
−
----</td>
+
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
−
<td>[[file:Steps.PNG|link=]]</td>
+
<td width=25>[[image:DotPoint1.JPG|link=]]</td>
−
<td><span style="font-size: 17px;">'''Steps:'''</span><br>
+
<td><span style="font-size: 17px; font-weight: 700;">Open the Developer Menu</span>
−
<table cellpadding=4 bgcolor=#ffffff>
+
<table>
 +
<tr valign="top">
 +
<td colspan=2>From either the '''Launcher''' (below left) or '''Content Manager''' (below right) open the '''Developer''' menu and select the '''Rebuild Database''' option</td>
 +
</tr>
 
<tr valign="top">
 
<tr valign="top">
 
<td>[[file:DBR_EDBR01.png|link=]]</td>
 
<td>[[file:DBR_EDBR01.png|link=]]</td>
 
<td>[[file:DBR_EDBR02.png|link=]]</td>
 
<td>[[file:DBR_EDBR02.png|link=]]</td>
 
</tr>
 
</tr>
 +
</table>
 +
</td>
 +
</tr>
 +
</table>
 +
 +
<table width=1000>
 
<tr valign="top">
 
<tr valign="top">
−
<td colspan="2">From either the '''Launcher''' (left) or '''Content Manager''' (right):-
+
<td>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.
−
#open the '''Developer''' menu
+
<table>
−
#select the '''Rebuild Database''' option</td>
+
<tr valign="top">
 +
<td width=25>[[image:DotPoint1Blue.png|link=]]</td>
 +
<td>'''Scanning for deleted asset files'''<br>
 +
[[file:DBR_EDBR03.png|link=]]</td>
 
</tr>
 
</tr>
−
</table></td>
+
<tr valign="top">
 +
<td>[[image:DotPoint2Blue.png|link=]]</td>
 +
<td>'''Scanning for added asset files'''<br>
 +
[[file:DBR_EDBR04.png|link=]]</td>
 
</tr>
 
</tr>
−
<tr>
+
<tr valign="top">
−
<td colspan="2">
+
<td>[[image:DotPoint3Blue.png|link=]]</td>
−
----</td>
+
<td>'''Importing built in assets'''<br>
 +
[[file:DBR_EDBR06.png|link=]]</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint4Blue.png|link=]]</td>
 +
<td>'''Rebuilding cached asset data'''<br>
 +
[[file:DBR_EDBR07.png|link=]]</td>
 +
</tr>
 +
</table>
 +
</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>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.</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
−
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>
 
−
[[file:DBR_EDBR03.png|link=]]<br><br>
 
−
2. '''Scanning for added asset files'''<br>
 
−
[[file:DBR_EDBR04.png|link=]]<br><br>
 
−
3. '''Importing built in assets'''<br>
 
−
[[file:DBR_EDBR06.png|link=]]<br><br>
 
−
4. '''Rebuilding cached asset data'''<br>
 
−
[[file:DBR_EDBR07.png|link=]]<br><br>
 
−
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 -->
+
<table width=1000> <!-- BEGIN Nav Buttons Table -->
 
<tr valign="top">
 
<tr valign="top">
 
<td width=729><span id="stepEDBR"></span>&nbsp;</td>
 
<td width=729><span id="stepEDBR"></span>&nbsp;</td>
Line 172: Line 208:
 
='''How to Perform an Extended Database Repair (an EDBR)'''=
 
='''How to Perform an Extended Database Repair (an EDBR)'''=
  
−
<table cellpadding=4 bgcolor=#c1e7e7>
+
<table width=1000 bgcolor="lightcyan" cellpadding=2>
 
<tr valign="top">
 
<tr valign="top">
−
<td>[[file:DotPoint.JPG|link=]]</td>
+
<td width=10>[[image:BlueDot10x10.png|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>
 
</table>
 
</table>
 
<br>
 
<br>
−
 
+
<table width=XXX bgcolor=#000000 cellpadding=2>
−
<table bgcolor=#000000 width=800>
+
 
<tr valign="top">
 
<tr valign="top">
 
<td>
 
<td>
−
<table bgcolor=#ffffb0 width=796>
+
<table width=XXX-4 bgcolor=#ffffb0 cellpadding=2>
 
<tr valign="top">
 
<tr valign="top">
−
<td>[[file:NotePad.PNG|link=]]</td>
+
<td width=25>[[image:NotePad.PNG|link=]]</td>
 
<td><span style="font-size: 17px;">'''Notes:'''</span><br>
 
<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
 
 
</td>
 
</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>An '''EDBR''' is a more complex, slower and potentially more troublesome repair process</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>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>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>Perform an '''EDBR''' if you have '''serious problems''' with your database that a DBR does not fix</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
Line 198: Line 242:
 
</table>
 
</table>
 
<br>
 
<br>
−
<table bgcolor=#ff0000 width=800>
+
<table bgcolor=#ff0000>
 
<tr valign="top">
 
<tr valign="top">
 
<td>
 
<td>
Line 213: Line 257:
 
</table>
 
</table>
 
<br>
 
<br>
−
<table cellpadding=4 bgcolor=#ffffff>
+
<table width=1000>
 
<tr valign="top">
 
<tr valign="top">
−
<td colspan="2">
+
<td colspan=2><span style="font-weight: 700; font-size: 17px;">Steps:</span></td>
−
----</td>
+
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
−
<td>[[file:Steps.PNG|link=]]</td>
+
<td width=25>[[image:DotPoint1.JPG|link=]]</td>
−
<td><span style="font-size: 17px;">'''Steps:'''</span><br>
+
<td><span style="font-size: 17px; font-weight: 700;">Open the Developer Menu</span></td>
−
<table cellpadding=4 bgcolor=#ffffff>
+
</tr>
 +
<tr valign="top">
 +
<td colspan=2>
 +
<table> <!-- BEGIN Step 1 table -->
 
<tr valign="top">
 
<tr valign="top">
 
<td>[[file:DBR_EDBR01.png|link=]]</td>
 
<td>[[file:DBR_EDBR01.png|link=]]</td>
 
<td>[[file:DBR_EDBR02.png|link=]]</td>
 
<td>[[file:DBR_EDBR02.png|link=]]</td>
 
</tr>
 
</tr>
 +
</table>
 +
<table>
 
<tr valign="top">
 
<tr valign="top">
−
<td colspan="2">From either the '''Launcher''' (left) or '''Content Manager''' (right):-
+
<td colspan=2>From either the '''Launcher''' (left) or '''Content Manager''' (right):-</td>
−
#open the '''Developer''' menu
+
−
#hold down the '''Ctrl''' key
+
−
#select the '''Rebuild Database''' option</td>
+
 
</tr>
 
</tr>
−
</table></td>
+
<tr valign="top">
 +
<td width=25>[[image:DotPoint1Blue.png|link=]]</td>
 +
<td>open the '''Developer''' menu</td>
 
</tr>
 
</tr>
−
<tr>
+
<tr valign="top">
−
<td colspan="2">
+
<td>[[image:DotPoint2Blue.png|link=]]</td>
−
----</td>
+
<td>hold down the <span style="font-weight: 700; font-size: 15px; color: white; background-color: black;">&#160;Ctrl&#160;</span> key</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint3Blue.png|link=]]</td>
 +
<td>select the '''Rebuild Database''' option</td>
 +
</tr>
 +
</table>
 +
</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
 
<br>
 
<br>
 
A possible result of an EDBR.<br>
 
A possible result of an EDBR.<br>
−
<table width=100%>
+
<table width=1000>
 
<tr>
 
<tr>
 
<td>
 
<td>
Line 249: Line 303:
 
</table>
 
</table>
 
<br>
 
<br>
−
<table> <!-- BEGIN Nav Buttons Table -->
+
<table width=1000> <!-- BEGIN Nav Buttons Table -->
 
<tr valign="top">
 
<tr valign="top">
 
<td width=729><span id="stepClean"></span>&nbsp;</td>
 
<td width=729><span id="stepClean"></span>&nbsp;</td>
Line 261: Line 315:
 
='''How to Create a "Clean Database"'''=
 
='''How to Create a "Clean Database"'''=
  
−
<table cellpadding=4 bgcolor=#c1e7e7>
+
<table width=1000 bgcolor="lightcyan" cellpadding=2>
 
<tr valign="top">
 
<tr valign="top">
−
<td>[[file:DotPoint.JPG|link=]]</td>
+
<td width=10>[[image:BlueDot10x10.png|link=]]</td>
 
<td>Creating a '''Clean Database''':-
 
<td>Creating a '''Clean Database''':-
−
*will return your '''Trainz''' database to its original, newly installed, condition
+
<table>
−
*is usually performed when the Trainz Database contains faulty installed assets that are causing crashes and other major problems
+
<tr valign="top">
−
*does not destroy your original database</td>
+
<td width=10>[[image:DotPointBlueSquare.png|10px|link=]]</td>
 +
<td>will return your '''Trainz''' database to its original, newly installed, condition</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPointBlueSquare.png|10px|link=]]</td>
 +
<td>is usually performed when the Trainz Database contains faulty installed assets that are causing crashes and other major problems</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPointBlueSquare.png|10px|link=]]</td>
 +
<td>does not destroy your original database</td>
 +
</tr>
 +
</table>
 +
</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
 
<br>
 
<br>
−
<table bgcolor=#000000 width=900>
+
<table width=1000 bgcolor=#000000>
 
<tr valign="top">
 
<tr valign="top">
 
<td>
 
<td>
−
<table bgcolor=#ffffb0 width=896>
+
<table bgcolor=#ffffb0>
 
<tr valign="top">
 
<tr valign="top">
 
<td>[[file:NotePad.PNG|link=]]</td>
 
<td>[[file:NotePad.PNG|link=]]</td>
 
<td><span style="font-size: 17px;">'''Notes:'''</span><br>
 
<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:-
+
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
+
<table>
−
*'''DLC''' assets - these will have to be reinstalled if you want them back
+
<tr valign="top">
−
*third party assets
+
<td width=10>[[image:DotPoint.JPG|10px|link=]]</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>'''DLS''' assets</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>'''DLC''' assets - these will have to be reinstalled if you want them back</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>third party assets</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>assets you have created yourself (e.g. routes, sessions, etc) - make sure that you have them backed up (as .cdp files)</td>
 +
</tr>
 +
</table>
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 291: Line 371:
 
</table>
 
</table>
 
<br>
 
<br>
−
<table bgcolor=#ff0000 width=900>
+
<table width=1000 bgcolor=#ff0000>
 
<tr valign="top">
 
<tr valign="top">
 
<td>
 
<td>
−
<table bgcolor=#fcbcbc>
+
<table width=996 bgcolor=#fcbcbc>
 
<tr valign="top">
 
<tr valign="top">
 
<td>[[file:Stop.PNG|link=]]</td>
 
<td>[[file:Stop.PNG|link=]]</td>
Line 307: Line 387:
 
</table>
 
</table>
 
<br>
 
<br>
−
<table cellpadding=4 bgcolor=#ffffff> <!-- BEGIN Step table -->
+
<table width=1000>
−
<tr>
+
<tr valign="top">
−
<td colspan="2">
+
<td colspan=2><span style="font-weight: 700; font-size: 17px;">Steps:</span></td>
−
----</td>
+
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
−
<td>[[file:Steps.PNG|link=]]<br><br>
+
<td width=25>[[image:DotPoint1.JPG|link=]]</td>
−
<span style="font-size: 17px; font-weight: 700;">Steps</span></td>
+
<td><span style="font-size: 17px; font-weight: 700;">Create a Container:</span><br>
−
<td>[[file:DotPoint1.JPG|link=]]&nbsp;<span style="font-size: 17px; font-weight: 700;">Create a Container:</span><br>
+
 
<table> <!-- BEGIN Step 1 table -->
 
<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)
+
<table>
−
#give the folder a meaningful and easy to remember name such as '''TRS19_Clean_Database'''<br>
+
<tr valign="top">
 +
<td width=25>[[image:DotPoint1Blue.png|link=]]</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)</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint2Blue.png|link=]]</td>
 +
<td>give the folder a meaningful and easy to remember name such as '''TRS19_Clean_Database'''</td>
 +
</tr>
 +
</table>
 
</td>
 
</td>
 
<td>[[file:DBR_EDBR30.png|link=]]
 
<td>[[file:DBR_EDBR30.png|link=]]
 
</td>
 
</td>
 
</tr>
 
</tr>
−
<tr>
+
</table>
−
<td colspan="2">
+
−
----</td>
+
−
</tr>
+
−
</table> <!-- END Step 1 table -->
+
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
−
<td>&nbsp;</td>
+
<td>[[image:DotPoint2.JPG|link=]]</td>
−
<td>[[file:DotPoint2.JPG|link=]]&nbsp;<span style="font-size: 17px; font-weight: 700;">In Trainz Launcher:</span><br>
+
<td><span style="font-size: 17px; font-weight: 700;">In Trainz Launcher:</span><br>
 
<table> <!-- BEGIN Step 2 table -->
 
<table> <!-- BEGIN Step 2 table -->
 
<tr valign="top">
 
<tr valign="top">
 
<td>
 
<td>
−
#<span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''Trainz Settings''' button
+
<table>
−
#<span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''Install''' tab
+
<tr valign="top">
−
#write down the location of the '''Local Data Folder''' - you may need it again!
+
<td width=25>[[image:DotPoint1Blue.png|link=]]</td>
−
#<span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the button '''[...]''' next to the local folder display name
+
<td><span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''Trainz Settings''' button</td>
−
#browse to your new data folder created in '''Step 1: Create a Container''' above
+
</tr>
−
#select (<span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> on but do not open) your new data folder
+
<tr valign="top">
−
#<span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the button '''[Select folder]'''
+
<td>[[image:DotPoint2Blue.png|link=]]</td>
−
#close any open '''File Explorer''' windows
+
<td><span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''Install''' tab</td>
−
You will see a progress bar as the built in assets are copied across to the new folder.
+
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint3Blue.png|link=]]</td>
 +
<td>write down the location of the '''Local Data Folder''' - you may need it again!</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint4Blue.png|link=]]</td>
 +
<td><span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the button '''[...]''' next to the local folder display name</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint5Blue.png|link=]]</td>
 +
<td>browse to your new data folder created in '''Step 1: Create a Container''' above</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint6Blue.png|link=]]</td>
 +
<td>select (<span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> on but do not open) your new data folder</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint7Blue.png|link=]]</td>
 +
<td><span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the button '''[Select folder]'''</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint8Blue.png|link=]]</td>
 +
<td>close any open '''File Explorer''' windows</td>
 +
</tr>
 +
</table>
 +
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|link=]]
 
<td>[[file:DBR_EDBR31.png|link=]]
 
</td>
 
</td>
 
</tr>
 
</tr>
−
<tr>
+
</table>
−
<td colspan="2">
+
−
----</td>
+
−
</tr>
+
−
</table> <!-- END Step 2 table -->
+
 
</td>
 
</td>
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
−
<td>&nbsp;</td>
+
<td>[[image:DotPoint3.JPG|link=]]</td>
−
<td>[[file:DotPoint3.JPG|link=]]&nbsp;<span style="font-size: 17px; font-weight: 700;">Restart Trainz and Reconfigure Settings:</span><br>
+
<td><span style="font-size: 17px; font-weight: 700;">Restart Trainz and Reconfigure Settings:</span><br>
 
<table> <!-- BEGIN Step 3 table -->
 
<table> <!-- BEGIN Step 3 table -->
 
<tr valign="top">
 
<tr valign="top">
−
<td colspan=2>
+
<td width=25>[[image:DotPoint1Blue.png|link=]]</td>
−
#restart '''Trainz''' when you are prompted to do so
+
<td>restart '''Trainz''' when you are prompted to do so</td>
−
#open the '''Trainz Settings''' again and <span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''Internet''' tab. <span style="background-color: yellow;"> In '''TRS19 SP3''' and later the '''Internet''' tab has been renamed to '''MyTrainz''' </span>
+
</tr>
−
#delete and re-enter your username and password
+
<tr valign="top">
−
#when your username/password have been accepted, restart '''Trainz''' again
+
<td>[[image:DotPoint2Blue.png|link=]]</td>
−
#open the '''Trainz Settings''' again and <span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''General''' tab
+
<td>open the '''Trainz Settings''' again and <span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''MyTrainz''' tab (in '''T:ANE''' and '''TRS19''' versions up to '''SP2''' the '''MyTrainz''' tab is named '''Internet''')</td>
−
#adjust the settings to your preferred values
+
</tr>
−
#<span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''Performance''' tab and adjust the settings to your preferred values
+
<tr valign="top">
−
#exit '''Trainz Settings'''. Depending on which settings you have changed, you may be prompted to restart '''Trainz''' again
+
<td>[[image:DotPoint3Blue.png|link=]]</td>
−
#<span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> on '''Start Trainz'''
+
<td>delete and re-enter your username and password</td>
−
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>
+
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint4Blue.png|link=]]</td>
 +
<td>when your username/password have been accepted, restart '''Trainz''' again</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint5Blue.png|link=]]</td>
 +
<td>open the '''Trainz Settings''' again and <span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''General''' tab</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint6Blue.png|link=]]</td>
 +
<td>adjust the settings to your preferred values</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint7Blue.png|link=]]</td>
 +
<td><span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> the '''Performance''' tab and adjust the settings to your preferred values</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint8Blue.png|link=]]</td>
 +
<td>exit '''Trainz Settings'''. Depending on which settings you have changed, you may be prompted to restart '''Trainz''' again</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint9Blue.png|link=]]</td>
 +
<td><span style="font-weight: 700; font-size: 15px; background-color: lightcyan;">Left Click</span> on '''Start Trainz'''</td>
 +
</tr>
 +
<tr valign="top">
 +
<td colspan=2>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.
+
In '''Trainz Plus''' and '''TRS19/22''' the '''Content Store''', accessed from the '''Trainz Launcher''', will allow you to select and re-install any previously purchased '''DLC''' assets.
 
</td>
 
</td>
 
</tr>
 
</tr>
−
<tr>
+
</table>
−
<td colspan="2">
+
−
----</td>
+
−
</tr>
+
−
</table> <!-- END Step 3 table -->
+
 
</td>
 
</td>
 
</tr>
 
</tr>
−
</table> <!-- END Steps Table -->
+
</table>
  
−
<table bgcolor=#000000 width=600>
+
<table bgcolor=#000000 cellpadding=2>
 
<tr valign="top">
 
<tr valign="top">
 
<td>
 
<td>
−
<table bgcolor=#ffffb0 width=596>
+
<table bgcolor=#ffffb0 cellpadding=2>
 
<tr valign="top">
 
<tr valign="top">
 
<td>[[file:NotePad.PNG|link=]]</td>
 
<td>[[file:NotePad.PNG|link=]]</td>
Line 396: Line 522:
 
----
 
----
 
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)
+
<table>
−
*archive or move it to offline storage
+
<tr valign="top">
−
*delete it
+
<td width=10>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>leave it there (it will take up many GBs of space)</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>archive or move it to offline storage</td>
 +
</tr>
 +
<tr valign="top">
 +
<td>[[image:DotPoint.JPG|10px|link=]]</td>
 +
<td>delete it</td>
 +
</tr>
 +
</table>
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 406: Line 543:
 
</table>
 
</table>
 
<br>
 
<br>
−
<table> <!-- BEGIN Nav Buttons Table -->
+
<table width=1000> <!-- BEGIN Nav Buttons Table -->
 
<tr valign="top">
 
<tr valign="top">
 
<td width=729><span id="bottom"></span>&nbsp;</td>
 
<td width=729><span id="bottom"></span>&nbsp;</td>
Line 419: Line 556:
  
 
='''Trainz Wiki'''=
 
='''Trainz Wiki'''=
−
<table cellpadding=4 bgcolor=#ffffff>
+
<table cellpadding=2 bgcolor=#ffffff>
 
<tr valign="top">
 
<tr valign="top">
 
<td>[[file:TrainzWiki.png|link=]]</td>
 
<td>[[file:TrainzWiki.png|link=]]</td>

Revision as of 07:51, 6 November 2023

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

  Top   Next Down Bottom

What is the "Trainz Database"?

BlueDot10x10.png 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.


DBR EDBR20.png


  Top Next Up Next Down Bottom

Why Would a Database Repair (DBR) Be Needed?

A 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.


PencilTips.PNG A common, but not exclusive, cause of database problems and even CTDs (crashes to desktop) may be your antivirus program. Everytime Trainz accesses the database your AV program may perform a scan of the database.

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 database.


  Top Next Up Next Down Bottom

How to Perform a Database Repair (a DBR)

BlueDot10x10.png 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.

NotePad.PNG Notes:

Perform a DBR if you have:-

DotPoint.JPG unexpected problems with missing content
DotPoint.JPG content errors with installed assets (particularly if those assets did not previously show any problems)
A DBR updates your database, revalidates the content and can often clear up any corruption that has occurred.
PencilTips.PNG 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.


Steps:
DotPoint1.JPG Open the Developer Menu
From either the Launcher (below left) or Content Manager (below right) open the Developer menu and select the Rebuild Database option
DBR EDBR01.png DBR EDBR02.png
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.
DotPoint1Blue.png Scanning for deleted asset files
DBR EDBR03.png
DotPoint2Blue.png Scanning for added asset files
DBR EDBR04.png
DotPoint3Blue.png Importing built in assets
DBR EDBR06.png
DotPoint4Blue.png Rebuilding cached asset data
DBR EDBR07.png
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.


  Top Next Up Next Down Bottom

How to Perform an Extended Database Repair (an EDBR)

BlueDot10x10.png 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


NotePad.PNG Notes:
DotPoint.JPG An EDBR is a more complex, slower and potentially more troublesome repair process
DotPoint.JPG 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
DotPoint.JPG Perform an EDBR if you have serious problems with your database that a DBR does not fix


Stop.PNG CAUTION:

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


Steps:
DotPoint1.JPG Open the Developer Menu
DBR EDBR01.png DBR EDBR02.png
From either the Launcher (left) or Content Manager (right):-
DotPoint1Blue.png open the Developer menu
DotPoint2Blue.png hold down the  Ctrl  key
DotPoint3Blue.png select the Rebuild Database option


A possible result of an EDBR.

DBR EDBR10.png


  Top Next Up   Bottom

How to Create a "Clean Database"

BlueDot10x10.png Creating a Clean Database:-
DotPointBlueSquare.png will return your Trainz database to its original, newly installed, condition
DotPointBlueSquare.png is usually performed when the Trainz Database contains faulty installed assets that are causing crashes and other major problems
DotPointBlueSquare.png does not destroy your original database


NotePad.PNG Notes:

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:-

DotPoint.JPG DLS assets
DotPoint.JPG DLC assets - these will have to be reinstalled if you want them back
DotPoint.JPG third party assets
DotPoint.JPG assets you have created yourself (e.g. routes, sessions, etc) - make sure that you have them backed up (as .cdp files)


Stop.PNG 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.

Your original database will not be affected and will remain in its current location until you choose to delete, move or restore it.


Steps:
DotPoint1.JPG Create a Container:
DotPoint1Blue.png use Windows File Explorer to create a new folder on your data drive (D: if you have one, C: if you don't)
DotPoint2Blue.png give the folder a meaningful and easy to remember name such as TRS19_Clean_Database
DBR EDBR30.png
DotPoint2.JPG In Trainz Launcher:
DotPoint1Blue.png Left Click the Trainz Settings button
DotPoint2Blue.png Left Click the Install tab
DotPoint3Blue.png write down the location of the Local Data Folder - you may need it again!
DotPoint4Blue.png Left Click the button [...] next to the local folder display name
DotPoint5Blue.png browse to your new data folder created in Step 1: Create a Container above
DotPoint6Blue.png select (Left Click on but do not open) your new data folder
DotPoint7Blue.png Left Click the button [Select folder]
DotPoint8Blue.png close any open File Explorer windows

You will see a progress bar as the built in assets are copied across to the new folder

DBR EDBR31.png
DotPoint3.JPG Restart Trainz and Reconfigure Settings:
DotPoint1Blue.png restart Trainz when you are prompted to do so
DotPoint2Blue.png open the Trainz Settings again and Left Click the MyTrainz tab (in T:ANE and TRS19 versions up to SP2 the MyTrainz tab is named Internet)
DotPoint3Blue.png delete and re-enter your username and password
DotPoint4Blue.png when your username/password have been accepted, restart Trainz again
DotPoint5Blue.png open the Trainz Settings again and Left Click the General tab
DotPoint6Blue.png adjust the settings to your preferred values
DotPoint7Blue.png Left Click the Performance tab and adjust the settings to your preferred values
DotPoint8Blue.png exit Trainz Settings. Depending on which settings you have changed, you may be prompted to restart Trainz again
DotPoint9Blue.png Left 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.

In Trainz Plus and TRS19/22 the Content Store, accessed from the Trainz Launcher, will allow you to select and re-install any previously purchased DLC assets.

NotePad.PNG Notes:

Your original database is still on your system at the location you recorded in Step 2 above. You may choose to:-

DotPoint.JPG leave it there (it will take up many GBs of space)
DotPoint.JPG archive or move it to offline storage
DotPoint.JPG delete it


  Top Next Up    

Trainz Wiki

TrainzWiki.png

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.

Retrieved from "https://game.ts2009.com/mediaWiki/index.php?title=How_to_Perform_Database_Repairs&oldid=39244"
Personal tools