ziffmedia/laravel-mysql-snapshots

A set of commands that will create and load MySQL snapshots with the mysql-client command line tools

Maintainers

Details

github.com/ziffmedia/laravel-mysql-snapshots

Source

Issues

Installs: 94 184

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 13

Forks: 1

Open Issues: 2

v1.0.2 2023-06-14 16:26 UTC

Requires

  • php: >=8.1

Requires (Dev)

MIT 38a77e5ab1ade076ef5ea9fc0e446820b268c371

  • Ralph Schindler <ralph.schindler.woop@ziffmedia.com>

This package is auto-updated.

Last update: 2024-12-20 21:02:07 UTC

README

Laravel Mysql Snapshots
R

Installation

You can install the package via composer:

composer require ziffmedia/laravel-mysql-snapshots

You can publish the config file with:

php artisan vendor:publish --provider='ZiffMedia\LaravelMysqlSnapshots\MysqlSnapshotsServiceProvider'

Note: the configuration file will lock writing new snapshots to disk to the production environment while loading snapshots will be locked to the local environment.

Usage

List Snapshots

artisan mysql-snapshots:list

Create Snapshots

artisan mysql-snapshots:create daily

To create snapshots, and automatically cleanup up old snapshots:

artisan mysql-snapshots:create daily --cleanup

Load Snapshots

To load the newest snapshot in the first available plan:

artisan mysql-snapshots:load

With Plan:

artisan mysql-snapshots:load daily

Additional options

--cached Keeps a copy of the snapshot so that you don't need to redownload it on the next run

--recached Downloads a fresh sql file, even if one exists locally, and then keeps it cached

--no-drop Do not drop all tables in the database before loading the snapshot