PHPackages aktolu/php-db-backup - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. aktolu/php-db-backup ActiveLibrary[Database & ORM](/categories/database) aktolu/php-db-backup ==================== A lightweight and portable PHP database backup and restore system with native Composer support. v1.1.2(1mo ago)018MITPHPPHP >=8.1 Since Jun 6Pushed 1mo agoCompare [ Source](https://github.com/aktolu/php-db-backup)[ Packagist](https://packagist.org/packages/aktolu/php-db-backup)[ RSS](/packages/aktolu-php-db-backup/feed)WikiDiscussions main Synced 1w ago READMEChangelog (1)DependenciesVersions (6)Used By (0) PDB - Database Backup and Restore for PHP ========================================= [](#pdb---database-backup-and-restore-for-php) A lightweight, high-performance, and portable PHP database backup and restore system using PDO. Since it is written in pure PHP, it does not depend on any external CLI tools (like `mysqldump`, `pg_dump`, `sqlite3`, or `sqlcmd`), making it extremely portable and suitable for shared hosting environments. Installation ------------ [](#installation) You can install the package via Composer: ``` composer require aktolu/php-db-backup ``` *(Note: Since this is a custom package, ensure you configure your repository source or load it locally in your projects).* --- Quick Start (MySQL Backup & Restore) ---------------------------------------- [](#quick-start-mysql-backup--restore) ``` require 'vendor/autoload.php'; use aktolu\PDB; // Configure database connection $pdb = new PDB(PDB::MySQL, 'root', 'SECRET', 'database_name', 'localhost', 3306); // Backup database to a file (creates directories automatically if they don't exist) $pdb->backup('backups/my_database_backup.sql'); // Restore database from a file $pdb->restore('backups/my_database_backup.sql'); ``` --- Features -------- [](#features) - **Flexible Configuration (Fluent Interface)**: Instantiate without arguments and configure dynamically later using setters with method chaining. - **Lazy Connection Loading**: Connection is only established when running a database action (`backup()` or `restore()`). - **Multi-Database Support**: Works out of the box with **MySQL**, **PostgreSQL**, **SQLite**, and **MS SQL Server**. - **Pure PHP implementation**: Works anywhere PDO is enabled. - **Composer integration**: Easily installable via Composer. - **Low Memory Footprint**: Uses database chunking and file streams to support very large databases. - **Transparent Gzip Compression**: Automatically compresses/decreases backup files if they end in `.gz`. - **Generated/Computed Column Safeguard**: Automatically detects and skips virtual/stored generated or computed columns to prevent schema errors during restores. - **Inline phpMyAdmin-style Foreign Key Checks**: Automatically writes constraint-disabling headers directly into the backup SQL files for seamless imports. - **Identity Insert Compatibility (MS SQL)**: Automatically wraps table insertions with `SET IDENTITY_INSERT [table] ON` / `OFF` for tables containing auto-incrementing identity keys. - **Auto-Sequence Syncing (PostgreSQL)**: Reconstructs sequence resets (`setval`) for Serial columns to keep sequences in sync after data restore. - **Index Reconstruction (SQLite / MS SQL)**: Automatically detects and dumps indexes. - **Advanced Object Backup & Delimiter Parsing**: Automatically backs up database **Views**, **Triggers**, and **Functions/Stored Procedures (Routines)**. Objects are generated in a strict dependency sequence: 1. Constraint bypass headers 2. Tables & Indexes 3. Data Insertion (`INSERT INTO`) 4. Views (`CREATE VIEW`) 5. Functions & Procedures (`CREATE FUNCTION`/`PROCEDURE`) 6. Triggers (`CREATE TRIGGER`) 7. Re-enable constraints The restore engine uses character-level block and quote parsing (tracking standard `BEGIN ... END`, `CASE ... END`, PostgreSQL dollar quotes `$$`, and custom `DELIMITER` statements) to prevent nested block semicolons from causing premature statement splitting errors during restoration. --- Usage Examples -------------- [](#usage-examples) ### 1. Fluent/Method-Chained Initialization (MySQL Example) [](#1-fluentmethod-chained-initialization-mysql-example) ``` require 'vendor/autoload.php'; use aktolu\PDB; // Create PDB without arguments and configure dynamically $pdb = (new PDB()) ->setDriver(PDB::MySQL) ->setHost('127.0.0.1') ->setPort(3306) ->setUser('root') ->setPassword('SECRET') ->setDatabase('my_database'); // Backup (Connection is created here, lazily) $pdb->backup('backups/backup.sql'); ``` ### 2. SQLite [](#2-sqlite) For SQLite, pass the path of your database file as the database name parameter. Username and password can be left blank. ``` // Initialize for SQLite $pdb = new PDB(PDB::SQLite, '', '', 'path/to/database.db'); $pdb->backup('backups/sqlite_backup.sql.gz'); // Gzipped automatically ``` ### 3. PostgreSQL [](#3-postgresql) ``` // Initialize for PostgreSQL $pdb = new PDB(PDB::PostgreSQL, 'postgres', 'SECRET', 'database_name', 'localhost', 5432); $pdb->backup('backups/pgsql_backup.sql'); ``` ### 4. Microsoft SQL Server (MS SQL) [](#4-microsoft-sql-server-ms-sql) The MS SQL driver dynamically builds DSN bindings. It adapts to the Windows-native `sqlsrv` driver if available, and automatically falls back to `dblib` on Linux. ``` // Initialize for MS SQL Server $pdb = new PDB(PDB::MSSQL, 'sa', 'SECRET', 'database_name', 'localhost', 1433); // Backup (Automatically checks tables for Identity columns and handles constraints) $pdb->backup('backups/mssql_backup.sql'); ``` --- Configuration API Reference --------------------------- [](#configuration-api-reference) ### Getters and Setters [](#getters-and-setters) All setters return the `PDB` instance (`$this`) to support method chaining. GetterSetterArgument TypeDescription`getDriver()``setDriver(string $driver)``string` (`PDB::MySQL`, `PDB::PostgreSQL`, `PDB::SQLite`, `PDB::MSSQL`)Sets the database type.`getUser()``setUser(string $user)``string`Sets the database connection username.`getPassword()``setPassword(string $pass)``string`Sets the database connection password.`getDatabase()``setDatabase(string $dbName)``string`Sets the database name (or SQLite file path).`getHost()``setHost(string $host)``string`Sets the database host server.`getPort()``setPort(int $port)``int`Sets the database connection port.`getOptions()``setOptions(array $options)``array`Sets database/driver configuration options.`getTablePrefix()``setTablePrefix(string $prefix)``string`Sets the table prefix to prepend dynamically when writing the backup.`getPrefixReplace()``setPrefixReplace(string $old, string $new)``array`Sets table prefix replacement keys to map dynamically when writing the backup.`getOnlyTablesWithPrefix()``onlyTablesWithPrefix(string $prefix)``string`Sets a prefix filter; only tables and views matching this prefix are backed up.### Backup Options [](#backup-options) You can configure the behavior of the backup using the 2nd argument of `$pdb->backup()`: OptionTypeDefaultDescription`tables``array``[]`List of tables to include. If empty, includes all tables.`exclude_tables``array``[]`List of tables to exclude from export.`include_structure``bool``true`Export table schema definitions (`CREATE TABLE`).`include_data``bool``true`Export table data (`INSERT` statements).`chunk_size``int``1000`Records fetched per cursor chunk to prevent PHP memory exhaustion.`compress``bool``auto`Force gzip compression. If not set, checks if file ends with `.gz`.`add_drop_table``bool``true`Include `DROP TABLE IF EXISTS` statement before table creation in the backup.`prefix``string``''`Dynamically prepends a table prefix (e.g. `wp_`) when writing the backup stream.`prefix_replace``array``null`Mapped array `['old_', 'new_']` to replace table prefixes dynamically when writing the backup.`only_tables_with_prefix``string``null`Filters backup; only exports tables and views starting with the specified prefix (e.g., `wp_`).### Restore Options [](#restore-options) You can configure the behavior of the restore using the 2nd argument of `$pdb->restore()`: OptionTypeDefaultDescription`drop_tables``bool``true`If `true`, executes `DROP TABLE` statements from the SQL backup. If `false`, ignores/skips all `DROP TABLE` queries entirely during import.`compress``bool``auto`Force gzip decompression. If not set, checks if file ends with `.gz`.--- Inline Foreign Key Control Behavior ----------------------------------- [](#inline-foreign-key-control-behavior) When backing up, PDB writes standard commands to temporarily disable foreign key constraints at the top of the file, and enables them at the bottom. This mimics the behavior of native phpMyAdmin exports: - **MySQL**: - Top: `SET FOREIGN_KEY_CHECKS = 0; SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";` - Bottom: `SET FOREIGN_KEY_CHECKS = 1;` - **SQLite**: - Top: `PRAGMA foreign_keys = OFF;` - Bottom: `PRAGMA foreign_keys = ON;` - **PostgreSQL**: - Top: `SET session_replication_role = 'replica';` - Bottom: `SET session_replication_role = 'origin';` - **MS SQL Server**: - Top: `ALTER TABLE [tableName] NOCHECK CONSTRAINT ALL;` (for all exported tables) - Bottom: `ALTER TABLE [tableName] CHECK CONSTRAINT ALL;` (for all exported tables) --- Modifying Table Prefixes ------------------------ [](#modifying-table-prefixes) ### 1. Rename Prefixes Post-Backup [](#1-rename-prefixes-post-backup) You can dynamically rename table prefixes in an SQL backup file (or compressed `.gz` backup file) using the `renamePrefixInBackup` method. This handles database-specific quotes safely without altering user data or string contents. ``` // Rename table prefixes from 'wp_' to 'newwp_' in a finished backup file $pdb->renamePrefixInBackup( 'backups/backup.sql.gz', // Source file path 'wp_', // Old prefix 'newwp_', // New prefix 'backups/renamed_backup.sql.gz' // (Optional) Destination file path ); ``` ### 2. Rename/Replace Prefixes During Backup Generation (Streaming/Memory-Efficient) [](#2-renamereplace-prefixes-during-backup-generation-streamingmemory-efficient) For very large databases, you can replace table prefixes dynamically **as the SQL backup file is being written** to avoid reading huge files into memory. ``` // If tables in the database are named 'old_users', 'old_posts', etc. // They will be written as 'new_users', 'new_posts' directly inside the backup file $pdb->setPrefixReplace('old_', 'new_'); $pdb->backup('backups/backup.sql.gz'); ``` ### 3. Backup Only Tables Starting with Prefix [](#3-backup-only-tables-starting-with-prefix) You can configure PDB to only backup tables and views starting with a specific prefix. ``` // Backup only tables starting with 'wp_' $pdb->onlyTablesWithPrefix('wp_'); $pdb->backup('backups/wp_backup.sql'); ``` License ------- [](#license) This project is licensed under the MIT License. ### Health Score 39 — LowBetter than 84% of packages Maintenance90 Actively maintained with recent releases Popularity6 Limited adoption so far Community6 Small or concentrated contributor base Maturity46 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~0 days Total 5 Last Release 47d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/f7c6f7c0420fd67819a433e523a18277a0505cc3796bef5999688cac1fd695e2?d=identicon)[aktolu](/maintainers/aktolu) --- Top Contributors [![aktolu](https://avatars.githubusercontent.com/u/8854485?v=4)](https://github.com/aktolu "aktolu (7 commits)") ### Embed Badge ![Health badge](/badges/aktolu-php-db-backup/health.svg) ``` [![Health](https://phpackages.com/badges/aktolu-php-db-backup/health.svg)](https://phpackages.com/packages/aktolu-php-db-backup) ``` ### Alternatives [jdorn/sql-formatter a PHP SQL highlighting library 3.9k117.2M118](/packages/jdorn-sql-formatter)[propel/propel1 Propel is an open-source Object-Relational Mapping (ORM) for PHP5. 8351.6M87](/packages/propel-propel1)[jfelder/oracledb Oracle DB driver for Laravel 11518.4k](/packages/jfelder-oracledb) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)