create database on live server (heroku)

I work with the dynamic database I have a lot of databases and I wanna testing with hosting that free now I have found (Heroku) but when I use the command of laravel to create more database I got message say ( SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied to create database ) is possible or not if I wanna push my database to Heroku with data and I don't want to migrate it?

Tray2

5 years ago

Level 73

As the error message states you don't have the correct privileges to create a database.

If you want to move the data from one database to another you need to export it.

Not knowing what RDBMS you are using I can't point you to any guide on how to do that.

If it's just the database structure I recommend using Laravel migrations. If it's just a few tables with a few records in each that has default values use seeders for those.

1 like

kh_dev1

5 years ago

Level 2

thanks for the reply, but I really need to push 3 databases for my project what I should do?

martinbean

5 years ago

Level 80

@nithapple Heroku isn’t a “traditional” hosting platform. You have to “attach” databases to your application as add-ons; you can’t just create databases on demand from your application.

Have a read of https://devcenter.heroku.com/categories/data-management

1 like

Please or to participate in this conversation.