Dump

• Excluding tables from the dump
• For Windows

Sometimes it is necessary to dump the database. This process is very simple, just run the following command:

php vinci db:dump

Any dump files you run will be stored in app/Storage/dump.

Excluding tables from the dump

If there are tables in your database that you do not want to dump, use the --exclude argument

php vinci db:dump --exclude=table1,table2

For Windows

The process to perform the dump on Windows is a little different, you first need to edit the database.yaml file. You will need to indicate the location of mysqldump as shown below:

dump_windows:
  mysql: C:\wamp64\bin\mysql\mysql8.2.0\bin
  pgsql: C:\Program Files\PostgreSQL\14\bin
  sqlite: 

Then run the command php vinci db:dump.

---

What to see next?

1. ← Seeders
2. Katrina ORM →