Database Management

The database management tool is used to check the integrity of your database. This tool will determine if there are any missing tables or incorrect columns in your database.

Note

Typically you should never need to use this tool, but it can be useful when performing custom development.

If any problems are detected they will be listed on this page and you will be given the option to deploy or repair any tables. Any tables found in the database that aren't expected by Recite CMS will also be listed, although it's up to you whether or not these remain in the database (you might be using them for some unrelated purpose).

Figure 9.4. The database management tool with an incorrect table and an undeployed table.

The database management tool with an incorrect table and an undeployed table.

To deploy new tables, check the box beside any undeployed table and click Create Selected Tables. You will be prompted to confirm the table deployment.

To repair existing tables, check the box beside each item that needs repairing and click Repair Selected Items. You will be prompted before any changes are made to the tables.

Warning

As always, you should back up your database before making changes to it. While we are confident the database management tool works as advertised, we cannot take responsibility for any data loss you may suffer if your database is adversely affected.