Markdown-Reader

Sql Operations Documentation En

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

text

?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