README

A set of Laravel Artisan commands for database management.

Installation

You can install the package via composer:

composer require nachopitt/db-commands

Create a new MySQL database.

php artisan db:create {name?}

Argument	Description
`name`	The name of the database to create. If not provided, the command will use the database name from your `database.php` config file.

Drop an existing MySQL database.

php artisan db:drop {name?}

Argument	Description
`name`	The name of the database to drop. If not provided, the command will use the database name from your `database.php` config file.

Export an existing MySQL database into SQL statements.

php artisan db:export {schema?}

Argument	Description
`schema`	The name of the database to export. If not provided, the command will use the database name from your `database.php` config file.

Import a SQL file into an existing MySQL database.

php artisan db:import {file?} {--s|schema=} {--i|ignore-foreign-key-checks}

Argument	Description
`file`	The path to the SQL file to import. If not provided, the command will use `database_model/{database}.sql`.
`--schema`	The name of the database to import into. If not provided, the command will use the database name from your `database.php` config file.
`--ignore-foreign-key-checks`	Ignore foreign key checks while importing.

Truncate tables from database.

php artisan db:truncate {tables?} {--s|schema=} {--i|ignore-foreign-key-checks}

Argument	Description
`tables`	A comma-separated list of tables to truncate. If not provided, the command will truncate all tables in the database.
`--schema`	The name of the database to truncate tables from. If not provided, the command will use the database name from your `database.php` config file.
`--ignore-foreign-key-checks`	Ignore foreign key checks while truncating.

The MIT License (MIT). Please see License File for more information.