ipx-digital/db-copy

There is no license information available for the latest version (0.5) of this package.

Copies your production database to your development environment.

Maintainers

Details

github.com/ipx-digital/db-copy

Source

Issues

Installs: 82

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 1

Forks: 0

Open Issues: 1

0.5 2020-04-30 21:27 UTC

Requires

Unknown License d3e07ffd8f645807bd8739e998fdb864afa16199

This package is auto-updated.

Last update: 2024-04-29 04:40:02 UTC

README

Quickly and easily refresh your local MySQL database with production data by automating the process of copying your production database to your local development database.

Installation

  1. Use composer require ipx-digital/db-copy in your project's directory to include it.
  2. Since you're using this with Laravel, you likely already have a .env file with your developemnt database config variables. All you need to do is add the following for your production DB to your .env:
PRODUCTION_DB_CONNECTION=mysql
PRODUCTION_DB_HOST=<address to production DB>
PRODUCTION_DB_DATABASE=<database name>
PRODUCTION_DB_USERNAME=<mysql username>
PRODUCTION_DB_PASSWORD=<mysql password>
SSH_USERNAME=<only needed if you're connecting over SSH>

Usage

Simply use php artisan db:copy.

Disclaimer

We're dealing with databases here, so remember to be careful. Make backups often and be careful with protected data and PII concerns.

Built by IPX for internal use with largely Laravel projects, but works with any PHP and MySQL application or framework.