ksarien / l5-db-commands
A set of commands to create/drop/dump/restore databases on Laravel 5
Requires
- php: >=7.0
- illuminate/console: ~5.3.0|~5.4.0|~5.5.0
- illuminate/support: ~5.3.0|~5.4.0|~5.5.0
Requires (Dev)
- phpunit/phpunit: ^5.7|^6.2
This package is not auto-updated.
Last update: 2024-11-20 03:07:48 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
~/.pgpassfile withlocalhost:5432:mydbname:postgres:mypassand chmod 600.
Options:
--database: The name of the database connection in the configuration file.