How to create a mysql db with a Knex migrator CLI command?

Question

I have a knex powered app that once I clone from github, I can run yarn migrate:latest to get the database up to date.

The problem is, in some cases, like a new developer, the database might not yet exist.

What is the right way to first create the database? Do I need to do that outside of KNEX or is there a KNEX CLI/Migration type of commend for this need?

easiest way, create database externally. If you like to do it on migration, you have to create migration file which should be the first file on migration folder. — Fazal Rasel
– Fazal Rasel, Commented Nov 30, 2017 at 7:31

Mikael Lepistö · Accepted Answer · 2017-11-30 09:00:35Z

1

Thats not supported (knex 0.14.2). You need to create database + db users in advance. If you like to have node library helping in that knex-db-manager is knex based helper lib for database management like creating DBs and db owner user etc.

answered Nov 30, 2017 at 9:00

Mikael Lepistö

19.9k4 gold badges73 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a mysql db with a Knex migrator CLI command?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related