Database Manager (phpMyAdmin)

Collation: utf8mb4_unicode_ci

Database Size

384 KB

Total Tables

14

Total Rows

48

Indexes

24

Table	Actions	Rows	Engine	Collation	Size
geminibook_admin		6	InnoDB	utf8mb4_unicode_ci	32 KB
geminibook_ads_settings		1	InnoDB	utf8mb4_unicode_ci	16 KB
geminibook_cache_registry		0	InnoDB	utf8mb4_unicode_ci	32 KB
geminibook_cache_settings		0	InnoDB	utf8mb4_unicode_ci	32 KB
geminibook_categories		2	InnoDB	utf8mb4_unicode_ci	32 KB
geminibook_gemini_studio		1	InnoDB	utf8mb4_unicode_ci	16 KB
geminibook_header_footer		1	InnoDB	utf8mb4_unicode_ci	16 KB
geminibook_media		0	InnoDB	utf8mb4_unicode_ci	16 KB
geminibook_pages		0	InnoDB	utf8mb4_unicode_ci	32 KB
geminibook_prompts		3	InnoDB	utf8mb4_unicode_ci	48 KB
geminibook_seo_settings		25	InnoDB	utf8mb4_unicode_ci	32 KB
geminibook_settings		9	InnoDB	utf8mb4_unicode_ci	32 KB
geminibook_sitemap_settings		0	InnoDB	utf8mb4_unicode_ci	32 KB
geminibook_trash		0	InnoDB	utf8mb4_unicode_ci	16 KB
14 Tables	Summary	48	Total	utf8mb4	384 KB

With selected: 0

14 tables total in u368291745_geminibook

Create new table on database u368291745_geminibook

One-Click Database Backup (.sql)

Download complete SQL snapshot containing DDL table structures, indexes, and full dataset. Automatically logged to backup history.

Server Backup History (database/backups/)

File Name	Type	Size	Created	Actions
geminibook_backup_2026-09-29_21-18-20.sql	Standard Backup	36.58 KB	2026-09-29 21:18:20	Download
geminibook_backup_2026-09-29_16-51-00.sql	Standard Backup	36.58 KB	2026-09-29 16:51:00	Download
geminibook_backup_initial.sql	Standard Backup	124.63 KB	2026-09-29 16:23:41	Download

Database Restoration (.sql)

Restore database schema and records from an uploaded file or existing backup.

Execution Safety Warning: Restoring a database will execute SQL DROP & CREATE statements that overwrite existing tables and all their data. An automated safety rollback snapshot will be created before execution, but downloading a fresh backup first is highly recommended.

Table Optimization & Integrity Repair Utilities

Rebuild indexes, defragment pages (VACUUM / OPTIMIZE), and perform zero-corruption structural verification.

Storage Defragmentation

Runs VACUUM to reclaim deleted page buffers and compact the storage file on disk.

Integrity Verification

Runs PRAGMA integrity_check to detect B-tree or index corruption.

Index Rebuild & Planner

Executes REINDEX and PRAGMA optimize to accelerate search query speeds.

Run SQL query/queries on database u368291745_geminibook

Query Results

Active Database Connection Local SQLite

Live database connection currently active for table inspection, CRUD, and backups.

MySQL (Config Default)

Driver Engine MYSQL

Database Name u368291745_geminibook

Host / Location localhost:3306

CMS Schema Complete (14/14)

Dynamic MySQL Database Connector

Connect to Hostinger, cPanel, or any external MySQL database without editing configuration files.

DB Host / IP Address * Use 'localhost' inside host, or Remote IP if connecting remotely

DB Port Default MySQL port: 3306

Database Name * Target MySQL database

Database Username * MySQL user account

Database Password

Credentials stored safely only in your active admin session

First-Time Setup & One-Click Schema Import

Automatically initialize all 14 required GeminiBook CMS tables and default meta keys on this database.

14 Core CMS Tables Managed by GeminiBook:

geminibook_admin

geminibook_prompts

geminibook_categories

geminibook_pages

geminibook_media

geminibook_trash

geminibook_gemini_studio

geminibook_seo_settings

geminibook_ads_settings

geminibook_cache_settings

geminibook_cache_registry

geminibook_sitemap_settings

geminibook_settings

geminibook_header_footer

Clicking "Import Default Schema / Setup Tables" safely creates missing tables without dropping existing data, and seeds the necessary initial administrative configuration keys so the CMS can operate immediately.

Table: table_name

SELECT * FROM table LIMIT 0, 25;

Number of rows:

Showing rows 0 - 0 (0 total)

With selected: 0

Table Structure / Columns

#	Name	Type	Null	Default	Key

Add column:

Null

Indexes & Constraints

Keyname	Type	Unique	Column(s)

Edit row in table geminibook_prompts

Review and modify column values. Changes are written directly to connected database.

Column	Type	Null	Value

u368291745_geminibook

Database Incomplete: Missing CMS Tables 0 missing