mayconbordin / l5-db-commands
A set of commands to create/drop/dump/restore databases on Laravel 5
Installs: 1 005
Dependents: 0
Suggesters: 0
Security: 0
Stars: 5
Watchers: 3
Forks: 2
Open Issues: 0
Requires
- php: >=5.4.0
- illuminate/console: 5.x
- illuminate/support: 5.x
Requires (Dev)
- phpunit/phpunit: ~4.0
This package is not auto-updated.
Last update: 2024-10-26 18:17:26 UTC
README
A set of commands to create/drop/dump/restore/shell databases on Laravel 5.
Supported DBMSs: MySQL, PostgreSQL and SQLite.
Installation
In order to install just add
"mayconbordin/l5-db-commands": "dev-master"
to your composer.json. Then run composer install
or composer update
.
Then in your config/app.php
add
'Mayconbordin\DbCommands\DbCommandsServiceProvider'
in the providers
array.
Commands
db:create [options]
Create a new database with the default connection from the configuration file.
Options:
--database
: The name of the database connection in the configuration file.
db:drop [options]
Drop an existing database with the default connection from the configuration file.
Options:
--database
: The name of the database connection in the configuration file.
db:dump [options] [--] [<output>]
Dump the schema and data of an existing database with the default connection from the configuration file. By
default the dump is printed on the screen, optionally it can be written to <output>
.
Options:
--database
: The name of the database connection in the configuration file.--data-only
: Dumps only the data.
db:restore [options] [--] <dump-file>
Restore the schema and data from <dump-file>
to an existing database with the default connection from the configuration file.
Options:
--database
: The name of the database connection in the configuration file.
db:shell [options]
Open a shell to an existing database with the default connection from the configuration file.
For PostgreSQL you might have to create a
~/.pgpass
file withlocalhost:5432:mydbname:postgres:mypass
and chmod 600.
Options:
--database
: The name of the database connection in the configuration file.
db:exec:sql [options] [--] <file>
Execute SQL file from <file>
to an existing database with the default connection from the configuration file.
Options:
--database
: The name of the database connection in the configuration file.