PHPackages                             heyday/laravel-anonymised-sql-dumps - 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. heyday/laravel-anonymised-sql-dumps

ActiveLibrary[Database & ORM](/categories/database)

heyday/laravel-anonymised-sql-dumps
===================================

Generate anonymised SQL dumps for Laravel. Wrapper for ifsnop/mysqldump-php

1.0.0(7y ago)2222MITPHPPHP ^7.0

Since Feb 28Pushed 7y ago4 watchersCompare

[ Source](https://github.com/heyday/laravel-anonymised-sql-dumps)[ Packagist](https://packagist.org/packages/heyday/laravel-anonymised-sql-dumps)[ Docs](https://github.com/heyday/laravel-anonymised-sql-dumps)[ RSS](/packages/heyday-laravel-anonymised-sql-dumps/feed)WikiDiscussions master Synced today

READMEChangelog (1)Dependencies (2)Versions (2)Used By (0)

Laravel Anonymised SQL dumps
============================

[](#laravel-anonymised-sql-dumps)

Essentially a wrapper around [ifsnop/mysqldump-php](https://github.com/ifsnop/mysqldump-php) that allows you to specify what columns to anonymise using [Faker](https://github.com/fzaninotto/Faker)

Helpful tool to debug production DBs while staying GDPR compliant.

Installation
------------

[](#installation)

You can install the package via Composer:

```
composer require heyday/laravel-anonymised-sql-dumps

```

In Laravel 5.5 and above, the package should autoregister the service provider. For Laravel 5.4 or below you must install this service provider to `config/app.php`:

```
'providers' => [
    // ...
    Heyday\AnonymisedSQLDumps\AnonymisedSQLDumpsServiceProvider::class,
];

```

Publish the config file:

```
php artisan vendor:publish --provider="Heyday\AnonymisedSQLDumps\AnonymisedSQLDumpsServiceProvider" --tag="config"

```

Update the published config file (`config/anonymised-sql-dumps.php`) to match your DB structure (only the columns you want to anonymise) and specify a Faker property to replace original data, eg:

```