How to Perform Database Repairs

From TrainzOnline
(Difference between revisions)
Jump to: navigation, search
(What is the "Trainz Database"?)
m (added Trainz Plus where needed, replaced references to multiple Trainz versions with "Trainz")
(10 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. TRS19 and TANE will automatically perform database repairs when they detect corruption in the Trainz database but sometimes a manual repair or even a manual clean install of the database is required.
+
The information in this Wiki Page applies to '''TANE''', '''TRS19''' and '''Trainz Plus'''.
 +
 
 +
__TOC__
 +
This guide will take you through the process of performing manual database repairs and clean database installs. '''Trainz''' will automatically perform database repairs when they detect corruption in the Trainz database but sometimes a manual repair or even a manual clean install of the database is required.
  
 
='''What is the "Trainz Database"?'''=
 
='''What is the "Trainz Database"?'''=
Line 5: Line 8:
 
<table cellpadding="4" bgcolor=#c1e7e7>
 
<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 22:
 
<tr>
 
<tr>
 
<td>
 
<td>
[[file:DBR_EDBR20.png]]
+
[[file:DBR_EDBR20.png|link=]]
 
</td>
 
</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
 
<br>
 
<br>
When TRS19 or TANE are in use there is a great 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 while records are open. For this reason, Content Manager in TRS19 and TANE come equipped with automatic and manual database repair tools.
+
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>
  
Line 31: Line 34:
 
<table cellpadding="4" bgcolor=#c1e7e7>
 
<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 40: Line 43:
 
<table cellpadding="4" bgcolor=#ffffb0>
 
<table cellpadding="4" bgcolor=#ffffb0>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:NotePad.PNG]]</td>
+
<td>[[file:NotePad.PNG|link=]]</td>
<td><font size="3">'''Notes:'''</font><br>
+
<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 49: Line 52:
 
</tr>
 
</tr>
 
</table>
 
</table>
<br>
+
 
<table cellpadding="4" bgcolor=#c1e7e7>
+
<table cellpadding="4" bgcolor=#ffffb0>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:DotPoint.JPG]]</td>
+
<td>[[file:PencilTips.PNG|link=]]</td>
<td>If you have installed a new asset that CM reports has having "missing" or "unknown" assets then a DBR is very '''unlikely''' to find those missing assets.</td>
+
<td>If you have installed a new asset that CM reports has having "missing" or "unknown" assets then a DBR is '''very unlikely''' to find those missing assets.</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
 
<br>
 
<br>
 
 
<table cellpadding="4" bgcolor=#ffffff>
 
<table cellpadding="4" bgcolor=#ffffff>
 
<tr valign="top">
 
<tr valign="top">
Line 64: Line 66:
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:Steps.PNG]]</td>
+
<td>[[file:Steps.PNG|link=]]</td>
<td><font size="3">'''Steps (both TRS19 and TANE):'''</font><br>
+
<td><span style="font-size: 17px;">'''Steps:'''</span><br>
 
<table cellpadding="4" bgcolor=#ffffff>
 
<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 87:
 
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 Data''' 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>
+
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>
  
Line 99: Line 101:
 
<table cellpadding="4" bgcolor=#c1e7e7>
 
<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 107: Line 109:
 
<table cellpadding="4" bgcolor=#ffffb0>
 
<table cellpadding="4" bgcolor=#ffffb0>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:NotePad.PNG]]</td>
+
<td>[[file:NotePad.PNG|link=]]</td>
<td><font size="3">'''Notes:'''</font><br>
+
<td><span style="font-size: 17px;">'''Notes:'''</span><br>
 
*This is a more complex, slower and potentially more troublesome repair process
 
*This 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
 
*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
Line 118: Line 120:
 
<table cellpadding="4" bgcolor=#fcbcbc>
 
<table cellpadding="4" bgcolor=#fcbcbc>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:Stop.PNG]]</td>
+
<td>[[file:Stop.PNG|link=]]</td>
<td>It is not unusual for CM to display a list of faulty assets that were not shown as faulty before the EDBR was run</td>
+
<td>It is not unusual for CM to display a list of faulty assets '''after an EDBR''' that were not shown as faulty before the EDBR was run</td>
 
</tr>
 
</tr>
 
</table>
 
</table>
Line 129: Line 131:
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:Steps.PNG]]</td>
+
<td>[[file:Steps.PNG|link=]]</td>
<td><font size="3">'''Steps (both TRS19 and TANE):'''</font><br>
+
<td><span style="font-size: 17px;">'''Steps:'''</span><br>
 
<table cellpadding="4" bgcolor=#ffffff>
 
<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 156:
 
<tr>
 
<tr>
 
<td>
 
<td>
[[file:DBR_EDBR10.png]]
+
[[file:DBR_EDBR10.png|link=]]
 
</td>
 
</td>
 
</tr>
 
</tr>
Line 164: Line 166:
 
<table cellpadding="4" bgcolor=#c1e7e7>
 
<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 TRS19 or TANE database to its original, newly installed, condition
+
*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>
Line 174: Line 176:
 
<table cellpadding="4" bgcolor=#ffffb0>
 
<table cellpadding="4" bgcolor=#ffffb0>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:NotePad.PNG]]</td>
+
<td>[[file:NotePad.PNG|link=]]</td>
<td><font size="3">'''Notes:'''</font><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 (TRS19 or TANE) 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
 
*'''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
Line 186: Line 188:
 
<table cellpadding="4" bgcolor=#fcbcbc>
 
<table cellpadding="4" bgcolor=#fcbcbc>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:Stop.PNG]]</td>
+
<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. Your original database will not be affected and will remain in its current location until you choose to delete, move or restore it.</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. 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>
 
</tr>
Line 197: Line 199:
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:Steps.PNG]]</td>
+
<td>[[file:Steps.PNG|link=]]</td>
<td><font size="3">'''Step 1: Create a Container'''</font><br>
+
<td><span style="font-size: 17px;">'''Step 1: Create a Container'''</span><br>
 
<table cellpadding="4" bgcolor=#ffffff>
 
<table cellpadding="4" bgcolor=#ffffff>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:DBR_EDBR30.png]]</td>
+
<td>[[file:DBR_EDBR30.png|link=]]</td>
 
<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)
Line 221: Line 223:
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:Steps.PNG]]</td>
+
<td>[[file:Steps.PNG|link=]]</td>
<td><font size="3">'''Step 2: In TRS19 (or TANE) Launcher'''</font><br>
+
<td><span style="font-size: 17px;">'''Step 2: In Trainz Launcher'''</span><br>
 
<table cellpadding="4" bgcolor=#ffffff>
 
<table cellpadding="4" bgcolor=#ffffff>
<tr>
+
<tr valign="top">
 
<td>
 
<td>
 
#click the '''Trainz Settings''' button
 
#click the '''Trainz Settings''' button
Line 236: Line 238:
 
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>
+
<td>[[file:DBR_EDBR31.png|link=]]</td>
 
</tr>
 
</tr>
 
</table></td>
 
</table></td>
Line 252: Line 254:
 
</tr>
 
</tr>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:Steps.PNG]]</td>
+
<td>[[file:Steps.PNG|link=]]</td>
<td><font size="3">'''Step 3: Restart and Reconfigure'''</font><br>
+
<td><span style="font-size: 17px;">'''Step 3: Restart and Reconfigure'''</span><br>
#restart TRS19/TANE when you are prompted to do so
+
#restart '''Trainz''' when you are prompted to do so
 
#open the '''Trainz Settings''' again and click the '''Internet''' tab
 
#open the '''Trainz Settings''' again and click the '''Internet''' tab
 
#delete and re-enter your username and password
 
#delete and re-enter your username and password
#when your username/password have been accepted, restart TRS19/TANE again
+
#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
Line 273: Line 275:
 
<table cellpadding="4" bgcolor=#ffffb0>
 
<table cellpadding="4" bgcolor=#ffffb0>
 
<tr valign="top">
 
<tr valign="top">
<td>[[file:NotePad.PNG]]</td>
+
<td>[[file:NotePad.PNG|link=]]</td>
<td><font size="3">'''Notes:'''</font><br>
+
<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)
Line 290: Line 292:
 
<table cellpadding="4" bgcolor=#ffffff>
 
<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="3">'''More Tutorials and Guides to Using Trainz'''</font><br>
+
<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]]'''

Revision as of 21:26, 1 November 2019

The information in this Wiki Page applies to TANE, TRS19 and Trainz Plus.

Contents

This guide will take you through the process of performing manual database repairs and clean database installs. Trainz will automatically perform database repairs when they detect corruption in the Trainz database but sometimes a manual repair or even a manual clean install of the database is required.

What is the "Trainz Database"?

DotPoint.JPG 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


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)

DotPoint.JPG 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:-

  • unexpected problems with missing content
  • content errors with installed assets (particularly if those assets did not previously show any problems)

A DBR process 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 CM reports has having "missing" or "unknown" assets then a DBR is very unlikely to find those missing assets.



Steps.PNG Steps:
DBR EDBR01.png DBR EDBR02.png
From either the Launcher (left) or Content Manager (right):-
  1. open the Developer menu
  2. select the Rebuild Database option

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
DBR EDBR03.png

2. Scanning for added asset files
DBR EDBR04.png

3. Importing built in assets
DBR EDBR06.png

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

How to Perform an Extended Database Repair (an EDBR)

DotPoint.JPG 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:
  • This 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
Stop.PNG It is not unusual for CM to display a list of faulty assets after an EDBR that were not shown as faulty before the EDBR was run



Steps.PNG Steps:
DBR EDBR01.png DBR EDBR02.png
From either the Launcher (left) or Content Manager (right):-
  1. open the Developer menu
  2. hold down the Ctrl key
  3. select the Rebuild Database option


A possible result of an EDBR.

DBR EDBR10.png


How to Create a "Clean Database"

DotPoint.JPG Creating a Clean Database:-
  • 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
  • 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:-

  • DLS assets
  • DLC assets - these will have to be reinstalled if you want them back
  • 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
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.PNG Step 1: Create a Container
DBR EDBR30.png
  1. use Windows File Explorer to create a new folder on your data drive (D: if you have one, C: if you don't)
  2. give the folder a meaningful and easy to remember name such as TRS19_Clean_Database


Steps.PNG Step 2: In Trainz Launcher
  1. click the Trainz Settings button
  2. click the Install tab
  3. write down the location of the Local Data Folder - you may need it again!
  4. click the button [...] next to the local folder display name
  5. browse to your new data folder created in Step 1: Create a Container above
  6. select (click on but do not open) your new data folder
  7. click the button [Select folder]
  8. 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


Steps.PNG Step 3: Restart and Reconfigure
  1. restart Trainz when you are prompted to do so
  2. open the Trainz Settings again and click the Internet tab
  3. delete and re-enter your username and password
  4. when your username/password have been accepted, restart Trainz again
  5. open the Trainz Settings again and click the General tab
  6. adjust the settings to your preferred values
  7. click the Performance tab and adjust the settings to your preferred values
  8. exit Trainz Settings and click Start Trainz

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.


NotePad.PNG Notes:

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)
  • archive or move it to offline storage
  • delete it




Trainz Wiki

TrainzWiki.png

More Tutorials and Guides to Using Trainz

Personal tools