Feature: SQL Operations #

Database maintenance tool. Integrity checks, statistics, table optimisation, export (SQL or ZIP) and import. Admin only.

---

Installation and Configuration #

Via FTP: Upload the `sql_operations/` directory into `/plugins/`.

Via package manager: Select `sql_operations` from the available plugins list.

Paths:

• Main plugin: `/plugins/sql_operations/sql_operations.php`
• Configuration: `/plugins/sql_operations/conf/sql_operations.conf.inc.php`

Configuration parameters:

| Variable | Default | Description |

|---|---|---|

| `$basedisplevel` | `BASE_LEVEL_ADMIN` | Minimum required level |

| `$ftype` | `3` | Plugin type (system) |

---

Usage #

Available actions #

| Action (`?sql_action=`) | Description |

|---|---|

| `check` | Table integrity check (ANALYZE / CHECK TABLE) |

| `stats` | Statistics: size and row count per table |

| `optimize` | Table optimisation (OPTIMIZE TABLE) |

| `export` | SQL export with optional ZIP compression |

| `import` | SQL file import (statement by statement) |

| `abort` | Cancel an ongoing operation |

Export #

• Generates a `.sql` or `.sql.zip` file
• Stored temporarily before download
• Includes structure and data

Import #

• Statement-by-statement execution
• Per-statement error report
• Does not drop existing data before import (must be done manually if required)

---

Hooks and Entry Points #

?obj=sql_operations.php&sql_action=check
?obj=sql_operations.php&sql_action=stats
?obj=sql_operations.php&sql_action=optimize
?obj=sql_operations.php&sql_action=export
?obj=sql_operations.php&sql_action=import

---

Dependencies #

• `Beamreactor\Database\SQL`
• PHP ZipArchive extension — for compressed export
• Write permission on the temporary directory — for export files