# Database Management

<figure><img src="/files/kbiSpXEMKhMeNSlQaUCL" alt=""><figcaption></figcaption></figure>

## Optimize Tables

| Button          | Description                          |
| --------------- | ------------------------------------ |
| Optimize Tables | Initiates a MySQL table optimization |

## Clean Up

The clean up feature allows to delete obsolete records from the past, like month templates or daynotes.

| Button   | Description                   |
| -------- | ----------------------------- |
| Clean Up | Cleans up the selected tables |

## Repair

The repair feature allows to to check your current database structure against the one distribute with the release you have installed.

| Button | Description              |
| ------ | ------------------------ |
| Repair | Check database structure |

## Delete Records

| Button         | Description                  |
| -------------- | ---------------------------- |
| Delete Records | Deletes the selected records |

## Administration

TeamCal Neo does not offer an own export/import feature anymore. Why create the wheel twice when there are more capable and secure free applications out there to manage databases, e.g. phpMyAdmin. What you can do here is enter the URL to your favorite database management tool, save it and launch it then by clicking/tapping on \[ Database Administration ].

| Button                  | Description                                                                              |
| ----------------------- | ---------------------------------------------------------------------------------------- |
| Save                    | Saves the link to your database administration tool                                      |
| Database Administration | Launches the link given in the URL field. If no link is saved, the button will not show. |

## Reset Database

| Button         | Description                                                              |
| -------------- | ------------------------------------------------------------------------ |
| Reset Database | Will replace all your information with the installation sample database. |

## TeamCal Pro Import

TeamCal Neo is not compatible with TeamCal Pro anymore. However, you can import core data from TeamCal Pro, like user accounts, if you have used TeamCal Pro before and want to migrate to TeamCal Neo. I recommend to try this with a test database first.

| Button | Description                              |
| ------ | ---------------------------------------- |
| Import | Will launch the TeamCal Pro import page. |

## Database Information

The Database Information tab shows some basic information about your database server and the database engine.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://lewe.gitbook.io/teamcal-neo/administration/database-management.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
