PHPackages inigopascall/clone-db - 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. inigopascall/clone-db ActiveLaravel-package[Database & ORM](/categories/database) inigopascall/clone-db ===================== Package for cloning medium-size databases by ordering tables by foreign-key dependencies and running batch inserts 1.0.1(1y ago)048↓50%PHP Since Nov 1Pushed 1y ago1 watchersCompare [ Source](https://github.com/inigopascall/clone-db)[ Packagist](https://packagist.org/packages/inigopascall/clone-db)[ RSS](/packages/inigopascall-clone-db/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (2)DependenciesVersions (3)Used By (0) A Laravel package for cloning medium-size databases =================================================== [](#a-laravel-package-for-cloning-medium-size-databases) This package was created as a solution to the problem of cloning medium/large databases between connections, for example pulling in a live database (or a subet of one) to staging or development environments where there is a need to play with real data. Large sql dump files are often too big to import in one go and can hit issues with memory limits (packet size), especially on micro servers. While [this is an old problem](https://stackoverflow.com/questions/13717277/how-can-i-import-a-large-14-gb-mysql-dump-file-into-a-new-mysql-database), there are still surprisingly few straightforward ways to go about it. This package is an attempt at an out-of-the-box solution in the form of a Laravel package which provides a new artisan command for cloning one database to another. - Attempts to preserve data integrity and avoid foreign-key constraint errors by automatically ordering tables by foreign key dependencies, creating the 'master' tables first, and dependent tables sequentially afterwards, ignoring new rows added to the latter tables since the script was initiated. (Note that mutually-dependent data sets are not supported). - Avoids php/mysql memory limits by 'chunking' data, i.e. selecting & inserting in configurable batch sizes. Obviously, running this script is destructive. Please ensure backups of all relevant databases have been taken before starting. Instructions ============ [](#instructions) `composer require inigopascall/clone-db` `php artisan vendor:publish --provider="InigoPascall\CloneDB\Providers\CloneDBProvider"` ### 1. Configure the config file as needed [](#1-configure-the-config-file-as-needed) **app/config/clone-db.php** Sensible defaults have been pre-set, with examples given in the comments in this file of how to fine-tune things to suit your needs. ### 2. Make sure the source & target databases are configured correctly in your app's config [](#2-make-sure-the-source--target-databases-are-configured-correctly-in-your-apps-config) **app/config/database.php** ``` 'my_source_db_connection' => [ 'driver' => 'mysql', 'host' => env('SOURCE_DB_HOST', '127.0.0.1'), 'port' => env('SOURCE_DB_PORT', '3306'), 'database' => env('SOURCE_DB_DATABASE', 'forge'), 'username' => env('SOURCE_DB_USERNAME', 'forge'), 'password' => env('SOURCE_DB_PASSWORD', '') ], 'my_target_db_connection' => [ 'driver' => 'mysql', 'host' => env('TARGET_DB_HOST', '127.0.0.1'), 'port' => env('TARGET_DB_PORT', '3306'), 'database' => env('TARGET_DB_DATABASE', 'forge'), 'username' => env('TARGET_DB_USERNAME', 'forge'), 'password' => env('TARGET_DB_PASSWORD', '') ] ``` **.env** ``` SOURCE_DB_HOST=localhost SOURCE_DB_PORT=3306 SOURCE_DB_DATABASE=source_database_name SOURCE_DB_USERNAME=mysqlusername SOURCE_DB_PASSWORD=mysluserpass TARGET_DB_HOST=localhost TARGET_DB_PORT=3306 TARGET_DB_DATABASE=target_database_name TARGET_DB_USERNAME=mysqlusername TARGET_DB_PASSWORD=mysqluserpass ``` 3. run the command with the source & target connection names as parameters. Check & confirm output. =========================================================================================================== [](#3-run-the-command-with-the-source--target-connection-names-as-parameters-check--confirm-output) `php artisan clone:db my_source_db_connection my_target_db_connection` Cloning a remote database via SSH --------------------------------- [](#cloning-a-remote-database-via-ssh) SSH config for your server pointing to the private key location **~/.ssh/config** ``` Host remoteservername Hostname {server ip address} User username IdentityFile ~/.ssh/remoteservernameprivatekey ``` Open SSH connection with `ssh remoteservername -N -L 13306:localhost:3306 username@{server ip address}` `app/config/database.php` entry for the connection would then be set with localhost and the local port number specified in the above command (13306): ``` 'my_source_db_connection' => [ 'driver' => 'mysql', 'host' => env('SOURCE_DB_HOST', '127.0.0.1'), 'port' => env('SOURCE_DB_PORT', '13306'), 'database' => env('SOURCE_DB_DATABASE', 'remotedb'), 'username' => env('SOURCE_DB_USERNAME', 'remotedbuser'), 'password' => env('SOURCE_DB_PASSWORD', 'remotedbpass') ] ``` ### Health Score 27 — LowBetter than 49% of packages Maintenance37 Infrequent updates — may be unmaintained Popularity10 Limited adoption so far Community7 Small or concentrated contributor base Maturity44 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 ~344 days Total 2 Last Release 577d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/8db9fa343831fbb55e5cf8c477fe978157731abfe5397ca46f8c9996ae31c27a?d=identicon)[Inigo Pascall](/maintainers/Inigo%20Pascall) --- Top Contributors [![inigopascall](https://avatars.githubusercontent.com/u/2178803?v=4)](https://github.com/inigopascall "inigopascall (4 commits)") ### Embed Badge ![Health badge](/badges/inigopascall-clone-db/health.svg) ``` [![Health](https://phpackages.com/badges/inigopascall-clone-db/health.svg)](https://phpackages.com/packages/inigopascall-clone-db) ``` ### Alternatives [doctrine/orm Object-Relational-Mapper for PHP 10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter a PHP SQL highlighting library 3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database The Illuminate Database package. 2.8k52.4M9.3k](/packages/illuminate-database)[mongodb/mongodb MongoDB driver library 1.6k64.0M545](/packages/mongodb-mongodb)[ramsey/uuid-doctrine Use ramsey/uuid as a Doctrine field type. 90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel Reliese Components for Laravel Framework code generation. 1.7k3.4M16](/packages/reliese-laravel) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)