Remote Configuration

Sets up the connection to the PHP backend and the target MySQL/MariaDB database.
Must be configured before any other operation on the remote server.

Connection Fields

Field	Description
API URL	Full URL to `edbapi.php` (e.g. `https://yourserver.com/edbapi.php`). Include the scheme (`https://` or `http://`).
User	MySQL/MariaDB username. Can be left empty if `DB_USER` is set in `config.php`.
Password	MySQL/MariaDB password. Can be left empty if `DB_PASS` is set in `config.php`.
Target Database	Name of the target MySQL/MariaDB database. Can be left empty if `DB_NAME` is set in `config.php`.
API Key	Must match `API_KEY` in `config.php`. Leave empty if the server does not require a key.

Testing the Connection

Test API — sends a ping to edbapi.php. Verifies the API is reachable, enabled, and accepts the API key. No database connection is attempted.

Test DB — opens a PDO connection to the target database and reports success or the MySQL/MariaDB error.

Server Information

Click Get Server Information to query the server. Populates the server panel and auto-configures BLOB and batch size limits.

Field	Description
Version	MySQL or MariaDB version string
Max packet	`max_allowed_packet`
Server charset	Server default character set
Table names	Case-sensitivity of table names (`lower_case_table_names`)
Strict	Whether `STRICT_TRANS_TABLES` or `STRICT_ALL_TABLES` is active
PHP post	`post_max_size`
PHP upload	`upload_max_filesize`
PHP exec	`max_execution_time`
PHP memory	`memory_limit`
PHP ver	PHP version

The View button opens a detailed list of all charsets and collations available on the server.

Maintenance Actions

Clear Database — drops all tables, views, stored procedures and functions in the target database. Destructive — requires confirmation.

Get Server Log — retrieves the contents of edb2mysql-api.log from the server.

Clear Server Log — clears the server-side log file.

Application Log