> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zonely.gen.tr/llms.txt
> Use this file to discover all available pages before exploring further.

# Database

> Check tables, edit records and use maintenance tools with JSON backup.

**Settings → Database** open the screen. Select the table you will work first; then **General, Structure, Insert, Spare, Transactions** and **Records** Go to the tabs.

## Open the table

[![Size and density, open the table](https://mintcdn.com/zonely-a8cd49e7/zHDHV03fZcc2n-EW/images/panel/system-security-guide-20261027/veritabani-01-en.png?fit=max\&auto=format\&n=zHDHV03fZcc2n-EW\&q=85\&s=f751d82606c338618052a9f8bfc8294e)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-01-en.png)

> [card] 1. Size and density
>
> Compare tables with the most space and the most rows.

> [card] 2. Open the table
>
> Log in with a Open button of a table.

Top **largest paintings** graph covered area, **row density** shows the number of records. Check the table name, motor, number of lines and size from the bottom list. **open** double click on the button or the line, switch to the table.

Close **displayed** the area shows the selected table. **historical tables** from the list you can return to your openings before, **Back to tables** with all the list. Without table selection, the structure and insert tools are not available.

## View link information

[![Connection information, Server capacity](https://mintcdn.com/zonely-a8cd49e7/_i4983VN4UZSjv0x/images/panel/system-security-guide-20261027/veritabani-02-en.png?fit=max\&auto=format\&n=_i4983VN4UZSjv0x\&q=85\&s=078b4339629324c2a64c9d06c8a4fca7)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-02-en.png)

> [card] 1. Connection information
>
> Get Host, port, database and user information here.

> [card] 2. Server capacity
>
> Monitor connection numbers and package limit in the same window.

**Database Information** Press the button. **Host, Port, Database** and **User** Get the values from the corresponding copy buttons. The password is shown with mask; you can change the visibility with the show button.

The same window has connection limits, instant usage, package limit, timeout values and character set. These are the information of the available connection. When connecting with separate vehicles, it is necessary to access the database of the server it works by the vehicle. For access problem [Database connection](https://docs.zonely.gen.tr/en/troubleshooting/access-issues-to-zonely-and-database.md) Use the guide.

**phpMyAdmin** can open the input window from the button, **Log in to phpMyAdmin** you can get in the connection.

## Create integration draft

[![Select the plugin, Pre-configured](https://mintcdn.com/zonely-a8cd49e7/_i4983VN4UZSjv0x/images/panel/system-security-guide-20261027/veritabani-03-en.png?fit=max\&auto=format\&n=_i4983VN4UZSjv0x\&q=85\&s=6a6a6f9be5696a4cdf7ffb879dd39e96)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-03-en.png)

> [card] 1. Select the plugin
>
> Open AuthMe, LuckPerms, LimboAuth or SkinsRestorer tasla.

> [card] 2. Ready-to-configure
>
> Copy the text that consists of link information and transfer the plugin into the setting file.

**Integration Builder** press the button and left **AuthMe, LuckPerms, LimboAuth** or **SkinsRestorer** Select. Formed text **Copy** Get with. Transfer the connection values into the setting file of the plugin by comparing the fields of the table prefix and the add-on version you use.

Complete the installation with the relevant guide: [AuthMe](https://docs.zonely.gen.tr/en/integrations/authme.md), [LuckPerms](https://docs.zonely.gen.tr/en/integrations/luckperms.md), [LimboAuth](https://docs.zonely.gen.tr/en/integrations/limboauth.md), [SkinsRestorer](https://docs.zonely.gen.tr/en/integrations/skinsrestorer.md). For nLogin, which is not available in the builder [NLogin](https://docs.zonely.gen.tr/en/integrations/nlogin.md) Follow the mappings on the guide.

## Search and edit registration

[![Search in table, Cell and line editing](https://mintcdn.com/zonely-a8cd49e7/_i4983VN4UZSjv0x/images/panel/system-security-guide-20261027/veritabani-04-en.png?fit=max\&auto=format\&n=_i4983VN4UZSjv0x\&q=85\&s=bae3f66bc0d487565a7c486eb610bc6c)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-04-en.png)

> [card] 1. Search in table
>
> Select the table, column and the value to be searched and press Ara.

> [card] 2. Cell and line arrangement
>
> Click Edit for the cell for the single area; for the entire registration.

**Table**, **column** and **Data to search** fill and fill the fields **Search** Press the button. For example `userslist` table `subname` column `Deniz` Search for: **All columns**makes the search without limitation with one domain. **Clear**removes search size.

Click on the cell to change the single value. To open the areas of the line together **Edit** Use the button. Line arrangement and deletion options are presented in tables with primary key to defining registration.

### Save cell change

[![New value is taken to the taste first](https://mintcdn.com/zonely-a8cd49e7/_i4983VN4UZSjv0x/images/panel/system-security-guide-20261027/veritabani-05-en.png?fit=max\&auto=format\&n=_i4983VN4UZSjv0x\&q=85\&s=a3b5958353677e0702a98de2e9dbee60)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-05-en.png)

> [card] 1. New value
>
> This window regulates the value of the selected column.

> [card] 2. Firstly taken into the taste
>
> It adds change to the list of those waiting to confirm the cell.

Check the column and table on the header, write new value and **Apply** Press the button. If the column supports **NULL** You can choose; blank text with NULL is different values. Closed areas to edit like primary key or dual data are only read.

[![Waiting arrangements](https://mintcdn.com/zonely-a8cd49e7/_i4983VN4UZSjv0x/images/panel/system-security-guide-20261027/veritabani-06-en.png?fit=max\&auto=format\&n=_i4983VN4UZSjv0x\&q=85\&s=8525dac4120cfb993a1f34a39a9aaacb)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-06-en.png)

> [card] 1. Waiting arrangements
>
> Authors to Save changes; Cancel draft changes.

**Apply** After the process, the changes are added to the bar. To write to the database **Save Changes** Press the button. **Stupid**removes pending arrangements. So you can prepare multiple cells and save them together in the last step.

## Read the structure tab

[![Column structure, Building SQL](https://mintcdn.com/zonely-a8cd49e7/I_XUxPU3E6OOeZQF/images/panel/system-security-guide-20261027/veritabani-07-en.png?fit=max\&auto=format\&n=I_XUxPU3E6OOeZQF\&q=85\&s=a9cffe290e610f50728fd26d657d639d)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-07-en.png)

> [card] 1. Column structure
>
> Type, Read the NULL, key, default value and AUTO information.

> [card] 2. Creating SQL
>
> Check the current CREATE TABLE definition of the table.

The column names, data types, NULL acceptance, switches and default values of the selected table are found here. **Home** primary switch, **Home** unique switch; **auto\_increment** automatic indicates increased value.

Indexes and **CREATE TABLE** View the definition. This text field shows the current structure of the table; the query run tool is not.

## Add new line

[![Save new line, form according to columns](https://mintcdn.com/zonely-a8cd49e7/I_XUxPU3E6OOeZQF/images/panel/system-security-guide-20261027/veritabani-08-en.png?fit=max\&auto=format\&n=I_XUxPU3E6OOeZQF\&q=85\&s=289a1fbab3f0d391138031fe8ca6a152)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-08-en.png)

> [card] 1. Save new line
>
> After checking the table and values, use Save.

> [card] 2. Form according to columns
>
> Leave the AUTO space empty; you can choose NULL in the appropriate columns.

**Add** Go to the tab. Fill in the fields in accordance with the information of the side. Automatic to be produced **Home** Leave the ID area empty; tick the option on the appropriate column you want to use NULL. Checking table and values **Save** Press the button.

## Get backup and restore

[![Select tables, restore backup the backup](https://mintcdn.com/zonely-a8cd49e7/I_XUxPU3E6OOeZQF/images/panel/system-security-guide-20261027/veritabani-09-en.png?fit=max\&auto=format\&n=I_XUxPU3E6OOeZQF\&q=85\&s=b79107a560c606f5d08e22978852b55f)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-09-en.png)

> [card] 1. Select tables
>
> Export structure and data of selected tables as JSON.

> [card] 2. Restore backup
>
> Select Zonely JSON file or paste JSON content.

**Spare** tab **Export JSON** Check tables in the section. **structure**table definition; **Data**adds lines to the level. Keep Data option open if you want to get logs.

**Rows per table** Check the limit. Default **10000** value does not allow all records to be received in large tables. Determine and identify the scope **Download** Get JSON file with.

To restore **Import JSON** In the section select the file of Zonely backup or paste the JSON text.

| Option | Effect |
| - | - |
| missing table | Create tables that are not available from the definitions in the backup. |
| Clean first | Removes existing lines in the target before importing. |
| Add line | The records in the backup add to the target table. |

**Upload** Check the target and preferences in the submitted approval. Firstly removes the existing data; get your current backup before restore. Re-connecting the same data from cleaning can also lead to key conflicts.

## Use table operations

[![Maintenance and deletion](https://mintcdn.com/zonely-a8cd49e7/I_XUxPU3E6OOeZQF/images/panel/system-security-guide-20261027/veritabani-10-en.png?fit=max\&auto=format\&n=I_XUxPU3E6OOeZQF\&q=85\&s=d1bb5516d48c747fb9222f311b909b08)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-10-en.png)

> [card] 1. Maintenance and deletion
>
> CHECK, ANALYZE, OPTIMIZE, and REPAIR are maintenance operations; truncating and deleting are separate operations.

**Transactions** The tab works on the selected table on the left. **CHECK** audit, **ANALYZE** statistics analysis, **OPTIMIZED** improvement, **REPAIR** if it is supported, it is necessary to repair in the engines. Read the result in the same section.

**cum**removes lines of the table. **Delete Table**removes the structure. Check your table name and backup in the approval of these processes.

## View transaction registration

[![Follow the process back](https://mintcdn.com/zonely-a8cd49e7/I_XUxPU3E6OOeZQF/images/panel/system-security-guide-20261027/veritabani-11-en.png?fit=max\&auto=format\&n=I_XUxPU3E6OOeZQF\&q=85\&s=04be817c74e648088b77add1d30531b6)](https://docs.zonely.gen.tr/images/panel/system-security-guide-20261027/veritabani-11-en.png)

> [card] 1. Follow the process back
>
> Read action, target table, SQL, IP and date areas together.

**Records** Read the action, target, SQL, IP and date information on the tab. **Refresh** Get the list again with it. Match the target table and time while researching a certain change. For other management records [Pasts](https://docs.zonely.gen.tr/en/guides/activity-logs.md) See guide.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.