How to Perform Database Repairs

From TrainzOnline
(Difference between revisions)
Jump to: navigation, search
m (How to Perform a Database Repair (a DBR))
m (How to Perform a Database Repair (a DBR))
Line 27: Line 27:
 
=How to Perform a Database Repair (a DBR)=
 
=How to Perform a Database Repair (a DBR)=
  
This is the simplest and (usually) the fastest option.
+
<table cellpadding="4" bgcolor=#c1e7e7>
 +
<tr valign="top">
 +
<td>[[file:DotPoint.JPG]]</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>
 +
</table>
 +
<br>
 +
This is the simplest and (usually) the fastest option.<br>
  
 +
The option to perform a DBR should be used if you have unexpected problems with missing content or content errors with installed assets. If you have installed an asset that CM reports has having "missing assets" then a DBR is very unlikely to find those assets. A DBR process updates your database, revalidates the content and can often clear up any corruption that has occurred.<br>
 +
 
<table cellpadding="4" bgcolor=#ffffff>
 
<table cellpadding="4" bgcolor=#ffffff>
 
<tr valign="top">
 
<tr valign="top">

Revision as of 13:32, 26 January 2019

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.

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


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.

The option to perform a DBR should be used if you have unexpected problems with missing content or content errors with installed assets. If you have installed an asset that CM reports has having "missing assets" then a DBR is very unlikely to find those assets. A DBR process updates your database, revalidates the content and can often clear up any corruption that has occurred.


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 stages, only some of which are shown below. The time required for each process will vary enormously (some will take much longer than others) and the total time involved will depend on the number of assets that are installed.

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

Eventually, the Building Trainz Asset Database window will disappear indicating that the process has been completed.

Personal tools